2011-10-03 (first published: 2008-03-27)
5,716 reads
2011-10-03 (first published: 2008-03-27)
5,716 reads
Copy Multiple objects from One Schema to Another Schema
2011-09-30 (first published: 2011-09-07)
1,453 reads
A function to replace tab characters with the correct number of spaces to align the text as originally intended.
2011-09-29 (first published: 2007-10-11)
2,139 reads
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)
4,134 reads
Find every object in every database owned by a particular Login.
2011-09-27 (first published: 2008-07-07)
8,997 reads
2011-09-26 (first published: 2011-09-14)
1,781 reads
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,178 reads
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,699 reads
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,060 reads
2011-09-20 (first published: 2008-01-11)
2,387 reads
By Steve Jones
A customer recently wanted to know if any of their instances were too old...
A reader of one of my previous posts pointed out that the legend order...
Please, let me reiterate: The only valid test of a backup is a restore....
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers