Automating T-SQL Code Analysis – Grant Fritchey

With all the options available within T-SQL these days, it’s more and more imperative that our code be clear and consistent. For example, there are clustered indexes and nonclustered indexes. Oh, but those are rowstore indexes. You also have clustered columnstore and nonclustered columnstore indexes. When you write T-SQL that says “CREATE INDEX MakeMyQueriesFast ON dbo.MySlowTable” which one do you mean?

Well, the default there will be a nonclustered rowstore index. How do I know…

Read the entire article at the source link… Grant Fritchey

We're happy to share this resource that we found. The content displayed on this page is property of it's original author and/or their organization.

Leave a Reply