I’m in the process of creating a post about statistics and came across something in SQL Server Management Studio that was driving me crazy. I thought I’d post it here so that others might not waste an hour or two like I did puzzling over this. When you create in index in SQL Server, SQL […]
UPDATE: This has been fixed with SQL 2016 CU2 and SQL 2016 SP1 CU2. UPDATE TO THE UPDATE: Today, July 3, 2018, I installed a brand new copy of SQL 2016 and patched it to SQL 2016 SP2 CU1. The .Net 3.5 framework was still not installed and I still had the same problems with […]
I’m pleased to announce that prices have been permanently reduced on ALL my online SQL Server courses! Additionally, use the links below to save an additional 15% off the newly reduced prices! Microsoft SQL Server 101 – This course is designed for new DBAs and involuntary DBAs or anyone who needs to learn the […]
Reader Dick H. posted a comment on my last version of this script stating that he got an error when this was run against tables containing sparse columns. Data compression does not support tables with sparse columns, so they should be excluded from this process. I’ve modified this script to correct this. I don’t have […]
This is just a bug fix from my last post of this code. I ran into a case where you would not get notified if the only indexes in a database that were being repeatedly defragged had fill factors of 50 or less. I would think this would be a pretty rare case, but it […]