usp_addcolumns
This is a stored procedure to add a columns to multiple tables, if column doesn't exist
2013-07-09 (first published: 2008-05-27)
946 reads
This is a stored procedure to add a columns to multiple tables, if column doesn't exist
2013-07-09 (first published: 2008-05-27)
946 reads
This will generate a script that drops and recreates existing db mail accounts and change the smpt server.
2013-07-08 (first published: 2013-06-19)
689 reads
2013-07-03 (first published: 2013-06-07)
845 reads
I wrote this script to help determine which data files are taking up space on an instance.
2013-07-02 (first published: 2013-06-05)
1,548 reads
A stored procedure which provides wildcard column selections plus some additional bells and whistles
2013-07-01 (first published: 2009-01-28)
857 reads
2013-06-25 (first published: 2013-06-03)
1,525 reads
This utility will locate a column across a subset or all databases across a server. Can be configured to run across versions, and can search tables, views or both.
2013-06-24 (first published: 2013-05-31)
1,218 reads
Script will give you the list of fragemented indexes.
(For SQL 2005-2008)
2013-06-21 (first published: 2013-05-31)
1,898 reads
Create restore script from a SQL Backup file. A must have for your DBA Tool Belt.
2013-06-18 (first published: 2013-05-30)
2,164 reads
This script will attempt to re-trust untrusted foreign keys and will report counts of successes and failures.
2013-06-17 (first published: 2013-05-30)
1,033 reads
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
At a recent conference I was asked how I executed code during my presentation....
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