Wayne Sheffield

My blog about SQL Server

Browsing Posts published in June, 2018

Understanding the relationship between statistics, indexes and constraints in SQL Server. What meaning does stats_id of 1 mean?

After you’ve messed up all of the configuration settings in SSMS affecting windows, how to you fix things? Read on for how to reset the window layout!

New SQL blogger Jamie Wick

Performance testing various methods for removing the time element from the datetime data type. While they all execute quickly, one method is faster than the others.