Jan 31, 2010 | Performance, Performance Monitoring, SQL PASS, SQL Training |
I recently discovered the Professional Association of SQL Server (PASS) virtual chapters. For those of you who struggle to make chapter and user group meetings (like me) this can be an excellent way of getting some excellent SQL Server training. I only came across the...
Jan 27, 2010 | Index, Performance
This is just a very short post regarding the use of wildcards in a WHERE Clause It is possible that the first WHERE clause below can use an Index seek Where LastName like ‘[a-z]%ent’ can use an index This second statement will not be able to use a seek and will result...
Jan 21, 2010 | Performance
I have been reading up on instant file initialization and I have read a couple of good blog posts by Kimberly Tripp(http://www.sqlskills.com/blogs/kimberly/post/Instant-Initialization-What-Why-and-How.aspx ), Paul Randal...