Browse Blog Posts by Tags

All Tags » SQL Server » best practices (RSS)

Browse Blog Posts by Tags

Showing related tags and posts for the Blogs application. See all tags in the site

SQL Server Manageability series - shortcut for SSMS keyboard shortcuts!

For any user manage the work with short-cut is desirable, for better productivity in your work (with UI tools) I always suggest to manage it by keyboard not with the mouse. Here is another block of SQL manageability series I want to cover based on feedback...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Fri, Oct 30 2009
Filed under: Filed under: sql server, server, best practices, management studio, tips, query plan, nodes, query editor, shortcut, keyboard
Build an effiective Disaster Recovery solution for SQL Server Reporting Services

As a Systems Administrator/DBA or even as an user have you ever realised "What is your data worth to you?" If so then an important aspect of data recovery solution is a required step, whatever is the application or system you use data access...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Sat, Oct 24 2009
Filed under: Filed under: sql server, databases, high availability, solution, machine, best practices, disaster recovery, clustering, reporting services
Problems you face when you do not check features not supported in SQL Server

Few developers on a client's place raised a question that why they should really be concerned about deprecated features or commands in SQL Server? Until SQL Server 2000 version it used to be a workaround to get the old scripts executed in a way. It...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Fri, Sep 18 2009
Filed under: Filed under: sql server, tools, query, best practices, deprecated, feature, disabled, upgrade advisor
SQL Server Upgrade from 2005 to 2008 - Notes and Best Practices from field :session from SQLBits conference

During the SQLBits IV conference I had presented a session on the topic: " Upgrading To SQL Server 2005 & 2008: Notes & Best Practices " with an excellent feedback from users. In this session the areas are covered such as SQL Server...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Thu, Aug 27 2009
Filed under: Filed under: sql server, tools, upgrade, version, best practices, media, uninstall, upgrade advisor, in-place, side-by-side
Removal of SQL DMO in future release of SQL Server - take action now!

If you remember about SQL Server 2005 installation & feature documentation SQL-DMO has been referred as backward compatibility, and that feature will be removed in a future version of SQL Server. So the documentation has been heavy on users to avoid...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, Aug 18 2009
Filed under: Filed under: sql server, msdn, replication, features, best practices, smo, dmo, backward compatibility
SQL Server Peer-to-Peer replicaton - how to achieve scalability and availability

Replication will be very handy to distribute the load of application when you have large scale of data management, as it evolved from SQL Server 6.0 version the transactional replication is first baby that was primarily used to support reporting applications...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, Jul 28 2009
Filed under: Filed under: sql server, availability, replication, BOL, best practices, scalability, tablediff, replication monitor, peer-to-peer
SQL Server TEMPDB - A key factor in monitoring and keeping up the performance! (update)

You may think on the subject line why TEMPDB is a key factor, a simple term is the size and physical placement of the tempdb database can affect the performance of a system. Even a simple query requires the access/process to TEMPDB, which is a part of...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, Jul 28 2009
Filed under: Filed under: sql server, best practices, multiple, table, storage, tempdb, create, files, performance monitoring
SQL Server error: Msg 6101, Level 16, State 1, Line 1 Process ID -2 is not a valid process ID. Choose a number between 1 and 2048 - update

Here is the quirky error that has caused a resources crunch on a SQL instance, Error : Process ID -2 is not a valid process ID . The actual issue occurred during an update to a table that has been used by Online application to update the action log, intially...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, Jul 27 2009
Filed under: Filed under: sql server, dmv, error, best practices, spid, connections, code, msdtc, kill, rollback, orphan, distributed transactions
SQL Server performance problem, how bad it is or rather I ask how good are you to find the root cause?

I always trust how good your resources are to find out a root cause than how bad the problem is? It is one of the best point of disaster recovery position I wanted to be to get to work on solution on quicker basis than worrying about the impact, the business...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, Jul 27 2009
Filed under: Filed under: sql server, perfmon, performance, ssms, tools, best practices, encryption, locks, baseline, benchmarking, performance monitoring
Do you know how many Monitoring Tools and Resources available in SQL Server?

Monitoring Tools and Resources are essential for performance tuning & better manageability in SQL Server. Many times the users think that collection and analysis of performance data is not a day-to-day job, also I feel that it is difficult at best...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, Jun 1 2009
Filed under: Filed under: sql server, performance, ssms, tools, best practices, bids, monitoring, resources, readtrace, profiller
Proactive caching for Analysis Services databases - performance techniques and better usage

By default SQL Server has a pool of memory that is used to store both execution plans and data buffers. This pool of memory is managed by default within Analysis Services for SQL Server and such percentage of the pool allocated to either execution plans...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Sun, May 31 2009
Filed under: Filed under: sql server, performance, data, cache, best practices, cube, Analysis Services, rolap, molap, proactive, advantage
SQL Server Error Msg:911 Could not locate entry in sysdatabases for database 'mssqlsystemresource'.

The error on the subject line is not a good sign when you have the mammoth task of moving SQL Server system databases, I would agree that the task of system databases migration is not a day-to-day task and you must have practised the required steps. For...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Sat, May 23 2009
Filed under: Filed under: sql server, restore, tech-ed, mvp, error, BOL, best practices, backups, corrupted, system databases, resource databases
SQL Server Edition - which is the best one to choose for your database needs?

When I look at the question, I feel that no direct answer to it! The reason being SQL Server has outgrown into an important enterprise RDBMS product from a simple desktop based database application, but still maintains the ease of installation and use...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Sun, May 17 2009
Filed under: Filed under: sql server, performance, standard, best practices, edition, enterprise, statistics, monitoring, e-learning
SQL Server Performance patterns of a UDF with datetime parameters

There was an interesting discussion about User Defined Fuctions (UDF) performance and patterns, the actual phenomenon is that UDF has got parameters to pass on during the execution. Just to talk about introduction of such options in the SQL Server history...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, May 11 2009
Filed under: Filed under: sql server, performance, best practices, function, table-valued, testing, udf, user-defined
Troubleshooting blocking in SQL Server 2005 and 2008 - new tool

How do you monitor and catch the blocked process within your SQL environment? Using Query Editor in SQL Server Management Studio to find the blocked processes is a common approach and further to that you can use the advanced configuration (SP_CONFIGURE...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Fri, May 1 2009
Filed under: Filed under: sql server, mvp, community, version, best practices, code-plex, blocked processes
Pattern and Practices - deprecate and discontinued Transact SQL features

Deprecate and Discontinued features, are not a words for Developers and DBAs which is a first point of option that they must be concentrated. What they mean is the defined features include a complete/partial change in supported compatibility levels, for...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Thu, Apr 23 2009
Filed under: Filed under: sql server, version, features, best practices, deprecated, tsql, dependancies, discontinued
A big question in SQL Server - create a table with more than 1024 columns?

IT was an interesting question to ask/know about create a table with more than 1024 columns? If you try to do so then obvious error: CREATE TABLE failed because column '<ColName>' in table 'MaxSparseColumnTest' exceeds the maximum...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, Apr 6 2009
Filed under: Filed under: sql server, blog, best practices, tsql, 1024, sparse columns, limit, db engine, create table
Get a mixture of Technical content from MIX09 sessions

MIX & PDC, 2 popular and catchy conferences for Developers in IT world! I favour MIX conference more than PDC as you get to know in-depth knowledge & features about cloud computing, .NET services and other major exciting developing technologies...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, Mar 24 2009
Filed under: Filed under: sql server, microsoft, developer, best practices, conference, mix, pdc, sql server 2005
SQL Server Deadlock and Trace Flag 1204 and 1222- a big question every time

I have seen few users out there thinks that Deadlocks in SQL Server is a bug which has not be corrected by Microsoft since its release! Even few times they get think that deadlocks and blocking are similar reactions in SQL Server, a typical situation...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, Mar 17 2009
Filed under: Filed under: sql server, performance, indexes, i/o, best practices, locking, deadlock, monitoring, beginner
Build your BI skills in SQL Server Fast Track Data Warehouse programme

Fast Track learning and Jump start of your skills is a recent buzzword in Cyberworld. What is required when you need to deploy a new technology? What kind of hardware is required for the deployment? Project Madison is the answer as a whole. The answer...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Thu, Feb 26 2009
Filed under: Filed under: sql server, machine, best practices, installation, business intelligence, new features, deployment, data warehouse

Page 1 of 6 (111 items) 1 2 3 4 5 Next > ... Last »

Questions? Contact Susan at Susan-at-msmvps.com. Each post's copyright held by the original author. All rights reserved. Blog site is an independent site not sponsored by Microsoft.
Our servers would like to thank www.ownwebnow.com and www.exchangedefender.com. We wouldn't be here without the generosity of Vlad Mazek and his companies.

Powered by Community Server (Commercial Edition), by Telligent Systems

Theme based on the Paperclip Blog Theme included in Community Server.
Enhanced to a Site-Wide Theme by Interscape Technologies.

Recent Posts

Tags

Browse Blog Posts by Tags