Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: June 2009

Querying the Procedural Cache on Canada Day (July 1st)

The goal of this post is to understand the procedure cache and execution plans to ensure we use fewer resources and that queries run better.  Better means higher throughput, more concurrency and fewer resources – as described by MVP Joe Webb during SQLTeach in Vancouver (my original hometown,…

Read more

1 comments, 985 reads

Posted in The Database Hive for SQL Server DBAs on 30 June 2009

How to Avoid Database Restore Issues by a Simple Script Edit - A DB Restore Work-around

During the process of applying changes to a production database - let's call it Change Management (pick your ITIL or COBIT method accordingly), we should always go through a thorough testing process on an exact copy and environment too, if possible, of the production database itself.  Straight to the point, there is a… Read more

3 comments, 1,044 reads

Posted in The Database Hive for SQL Server DBAs on 25 June 2009

Why You'll Want to Create Your Temp Tables Before Populating them

The point of this post is to cleary explain how the combination of the use of data definition language for your temporary tables and non-clustered indexes can improve the performance of stored procedures that much join data from many large tables by up to seventeen times - as I have seen on… Read more

0 comments, 532 reads

Posted in The Database Hive for SQL Server DBAs on 11 June 2009

TRY/CATCH - The Great Way to Handle Exceptions in SQL 2005/8

This is based on the original post in Franglais.

The goal of this post is to explain how to handle errors thanks to a useful T-SQL functionality, available since SQL 2005 onwards, that developers are already used to – and similar to how exceptions are handled in the Visual…
Read more

7 comments, 1,180 reads

Posted in The Database Hive for SQL Server DBAs on 3 June 2009