Subscribe to this blog
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,…
1 comments, 682 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, 770 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, 378 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, 745 reads
Posted in The Database Hive for SQL Server DBAs on 3 June 2009