Merry-Go-Round or Advanced Scan

The merry-go-round scan or advanced scan is something that I've seen mentioned a few times recently and it's a lovely little feature of Enterprise Edition that not all that many people seem to know about. The thing to remember here that this is only available in Enterprise Edition, so unfortunately those of you on Standard... Continue Reading →

Find All Heaps In Your Database

This is just going to be a quick post but I was asked the question the other day, how can I find all the tables in the database that don't have a clustered index? Tables without clustered indexes, known as heaps can give you quite a few different performance problems for various reasons. I don't... Continue Reading →

Undercover Tools: June Updates

Undercover Catalogue Update 0.4.3 An update to the tables module, Row count and size infotmation added Fix - LocalInterrogation There was an issue with the LocalInterrogation stored proc not updating the execution log, this has now been fixed. Undercover Inspector Updates we forgot to mention from May (V2.2): Added EmailGroup column to ReportData table #216Added... Continue Reading →

Undercover Tools: February Updates and Change Log

Below is the February list of changes and updates to the Undercover Tools. Undercover Catalogue Update 0.4.2Two new modules were added to the Catalogue. Trace Flags - Capture trace flags which are switched on on your SQL Servers Cluster - Capture details on any clusters that your SQL Servers sit on top of. Undercover Inspector

Create a website or blog at WordPress.com

Up ↑