Verify Last successful CHECKDB on all databases
Creates a resultset that expresses the last time a successful CHECKDB was performed on every database in the instance.
Does not work on SQL 2000.
2011-09-28 (first published: 2008-03-19)
5,064 reads
Scripts
Find all objects in Server Owned by a Login
Find every object in every database owned by a particular Login.
2011-09-27 (first published: 2008-07-07)
11,294 reads
2011-09-26 (first published: 2011-09-14)
1,803 reads
Generate Create All Secondary Indexes For Entire Database
Generate Script to create all secondary indexes for a database. I have included the ability to generate online indexes if possible and the ability to move to another file group.
2011-09-23 (first published: 2008-07-05)
3,272 reads
Check Full Recovery DBs Have Tran Log Backups
A quick procedure to check which full recovery databases have not had a tran log backup in the given period (default is 7 days). This could mean that the recovery mode might need changing or the transaction log backup jobs need investigating.
2011-09-22 (first published: 2007-08-03)
1,712 reads
Calculating the Number of Business Hours Passed Since a Point of Time
A set of user defined functions used to calculate the number of business or working hours (excluding the non working hours) that have passed since a certain point of time.
2011-09-21 (first published: 2007-11-20)
3,156 reads
2011-09-20 (first published: 2008-01-11)
2,493 reads
Set standard database options
Ensure all your databases have standardised options by running this script weekly.
2011-09-19 (first published: 2007-12-17)
2,140 reads
How to Test Connectivity for a Linked Server
Just one way of testing for a linked server based on data within your database.
2011-09-16 (first published: 2007-08-07)
2,631 reads
2011-09-15 (first published: 2011-09-05)
2,921 reads
Blogs
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Forums
How to change the FDLaunch Error log file location
The file FDLAUNCHERRORLOG gets created in the default <instance>\MSSQL\Log folder. So far, I've found...
what data type i should use for roversion col and can i use less than greater
can i use Rowversioncol ( in my database it's synonyme timestamp is used) to...
Radius Latitude Longitude
I have a table with latitude longitude in the format. 45.123456 , -111.123456 ,...
Question of the Day
A Fun Computer Quote
Which movie featured this quote?
"All programs have a desire to be useful."Happy April Fools! See possible answers