This procedure provides you the progess of the database backup or restore. We can execute the procedure to find the remaining time for completion of the backup or restore.
2011-07-18 (first published: 2010-02-19)
2,365 reads
Consolidated script generator for multiple stored procedures (existing and/or newly created) in MS Sql Server 2000/2005/2008 at one go
2011-07-15 (first published: 2011-03-28)
2,048 reads
2011-07-12 (first published: 2011-07-01)
1,123 reads
2011-07-11 (first published: 2011-07-02)
2,073 reads
Give information in tables such as type size and description of each of the columns
2011-07-08 (first published: 2011-07-06)
1,465 reads
This script will email info about the longest running SPID in an HTML formatted table
2011-07-07 (first published: 2011-06-27)
2,180 reads
Rename the Foreign keys to standard notation - FK_childTable_ParentTable
2011-07-06 (first published: 2010-02-09)
1,159 reads
T-SQL Script for Time Dimension Table Data: Populates Data between two dates for Reporting Solutions.
2011-07-04 (first published: 2010-06-14)
3,795 reads
A short script to backup all filegroups, for those who utilise filegroups within a database.
2011-06-29 (first published: 2010-07-20)
1,337 reads
Script to setup transactional replication with updatable subscriptions when also using mirroring
2011-06-28 (first published: 2010-06-16)
5,154 reads
Have you ever wondered where a certain field is used in a report? Or...
By Steve Jones
One of our internal people was looking to test some process in (I assume)...
By James Serra
Announced at Microsoft Ignite last week were some new product features related to the...
When I connect to my SQL Server using SQL Server Management Studio (SSMS) from...
Hi all! I’ve been using MySQLCalculator.com for memory calculations, but I’m looking for alternatives...
Which of these inputs is the smaller input to a hash join?
See possible answers