sp_RestoreScript 1.7 Released

sp_RestoreScript 1.7 has been released. For information and documentation please visit https://sqlundercover.com/2017/06/29/undercover-toolbox-sp_restorescript-a-painless-way-to-generate-sql-server-database-restore-scripts/ Changes in 1.7 New Parameters @IncludeCopyOnly - 1 - Copy only backups are included0 - Copy only backups are excluded @SingleUser - Put the database into single user mode before restoring @StopAtMark - Append stopatmark clause to any log restores @StopBeforeMark - Append... Continue Reading →

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 →

Create a website or blog at WordPress.com

Up ↑