Here’s a TSQL snippet that will give you the sizes of the indexes that the query optimiser isn’t using. Note that the NULL values are SINCE THE LAST RESTART. So if you just restarted your server then this is rather a waste of time.
Read More →Archive for October, 2013
Error while enabling windows feature: netfx3. – resolved
Something I have run into a few times now which is an annoying timewaster is the following error: You’ll get it on windows 2012 installations when installing SQL 2012(And probably lower versions) and it’s caused by dotnet 3.5not being enabled on the windows installation. It’s frustrating because it happens during the actual installation and is […]
Read More →