SEO my SQL Server Blog

I was going to spend today finishing off some SQL Server related blog posts, I currently have a list of four or five titles saved as draft that I am keen to publish including “special data file pages”, “Restoring master DB”, “Locks” but instead I have spent the day...

Wildcards in WHERE Clauses

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...

XML Index – ALTER INDEX with REBUILD Issue

I run into a small issue at the end last week, a CHECKDB job was reporting corruption on one of my development databases: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 965578478, index ID 1, partition ID 72057594042515456, alloc unit ID 72057594052083712...

Instant File Initialisation

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...