Dec 20, 2010 | Index, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server Internals |
This is kind of a follow up to a post I published last week regarding autogrowth. A forum poster said they had turned on AutoGrow and they were using autogrow as way of managing the growth of their databases – No! This post titled “Should I have AutoGrowth enabled on...
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...
