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

Archives: September 2011

Missing indexes

One of the most common things I encounter when asked to help with performance problems, is wrong or inadequate indexing. Creating the optimal indexes for a system, is no where near a trivial excercise. You need to consider the read/write ratio as well as how you write your queries. This… Read more

0 comments, 634 reads

Posted in SQL Server Notes from the Field on 27 September 2011

How to monitor number of VLF’s in your database

A few weeks back we did a blog post about a file grow bug that has been fixed with SQL Server Denali (Autogrow bug – fixed with Denali). The same blog posted explained why it is important not to have millions of VLF’s (Virtual Log Files). The method… Read more

0 comments, 813 reads

Posted in SQL Server Notes from the Field on 20 September 2011

T-SQL Function: EOMONTH

We have all been in a situation where we had to get the last day of the month with T-SQL. The world would just be so much easier with 30 days in every month, which is not the case. To calculate if the last day is 31, 30, 28 or… Read more

9 comments, 2,283 reads

Posted in SQL Server Notes from the Field on 13 September 2011

Blog Series: T-SQL Enhancements

Three months back in this blog post – T-SQL Enhancements in SQL Server Denali (2011) – we promised to do a series of blog posts, focusing on some of the new T-SQL enhancements that we all are looking forward to in SQL Server Denali.

This is not a post to… Read more

0 comments, 603 reads

Posted in SQL Server Notes from the Field on 6 September 2011

New LOGICAL functions in SQL Server Denali

IFF Function

If you are an old Access or Excel “developer” you know this one. This is not a function I have been missing before I read about it today. If you, like me, is so tired of writing CASE statements with only 2 possible outcoms – you will love… Read more

20 comments, 1,393 reads

Posted in SQL Server Notes from the Field on 6 September 2011