Understanding the relationship between statistics, indexes and constraints in SQL Server. What meaning does stats_id of 1 mean?
Book List
Planned books:
None
Current books:
-
SQL Server 2012 T-SQL Recipes: A Problem-Solution Approach (Expert’s Voice in SQL Server) by Jason Brimhall, David Dye, Jonathon Gennick, Andy Roberts, Wayne Sheffield
-
SQL Server T-SQL Recipes by Jason Brimhall, Jonathan Gennick, Wayne Sheffield
Recent books:
None
Browsing Posts tagged myth
One thing that I have seen repeatedly is that (too) many people believe that if you have a clustered index on a table, that you can run a SELECT statement without an ORDER BY clause from that table and the results will be in the order of the clustered index key. Nope, this is absolutely […]
