A stored procedure for restoring a database up to the latest log backup from a file folder. Compatible with the backups made by standard SQL maintenance plan.
2011-06-10 (first published: 2011-05-27)
1,543 reads
When creating a backup that will be restored to a development database, you may need to mask PII information. This script will help you with that.
2011-06-09 (first published: 2011-05-25)
1,421 reads
Generacion de numero de registros y espacio usado en disco todas las tablas de la base de datos
2011-06-08 (first published: 2008-06-24)
524 reads
Easily remove duplicate records without temp tables by using a CTE.
2011-06-07 (first published: 2008-03-19)
6,922 reads
2011-06-03 (first published: 2008-08-18)
1,078 reads
2011-06-02 (first published: 2008-04-24)
9,196 reads
2011-06-01 (first published: 2007-09-02)
10,459 reads
Script generator to restore to a new DB. Designed on Ola Hallengren's backup solution.
2011-05-31 (first published: 2011-05-20)
945 reads
2011-05-30 (first published: 2011-05-23)
2,405 reads
This procedure works like the sp_spaceused procedure but this one shows statistics for all tables in the selected database or for all databases (excluding tempdb and model).
2011-05-25 (first published: 2008-03-05)
10,118 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