Tool to measure Index Selectivity
by Michal Tinthofer on 05/06/2012Sometimes when you plan to change your index design is good to know the columns of your tables. But not just a data type and max size.
Read moreSometimes when you plan to change your index design is good to know the columns of your tables. But not just a data type and max size.
Read moreFew days ago I have noticed that there will be a change (again) in certification paths for next generation of SQL servers. So I would like to recommend some thoughts about this from Microsoft Certified Masters (MCM) of Brent Ozar PLF Company.
Read moreRecently I had some issues with SQL server 2008 R2 service pack 1 installation. From first perspective it looks like an issue with corrupted installation package, but true issue was somewhere else. It was a windows installer.
Read moreI think there is more simple and harmless way. First we need to understand the process of tempdb collation setting.
Read moreFew days ago I have been asked for help in process of installation a SCOM. Admins wasn’t been able to install some parts of this system because installation wizards reports some unexpected errors. When I arrived to the SQL instance I found something inte
Read moreSometimes is nice to have a tool/report which could allow you to see how much your backup storage is degraded over time. Especially by fragmentation and auto growth/shrink operations.
Read more