Patty Dunbar


Full, diff and tlog backups based on recovery mode

    This a script which creates stored procedures that can be executed adhoc or set as sql agent jobs to check the recovery status and generate full, differential or transaction log backupf for each database if the database recovery status is set to full.  We have terabytes of data and set all production databases […]

2003-06-06

911 reads

Script to obtain datadictionary from a SQL2000 db

This script creates a stored procedure that, when executed, queries the system tables of any SQL2000 database to return a complete, ordered datadictionary. *Warning**This script only works on tables which have the description property filled out as my main purpose was to query the extended property description feature new to SQL2000. If you have not […]

2001-08-27

3,104 reads

Blogs

What is a model database?

By

Do you ever take a look at SSMS in the System Databases section? People...

Daily Coping 26 Jan 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Rowcount estimates when there are no Statistics

By

When you don't have statistics, what does SQL use to calculate the estimated number...

Read the latest Blogs

Forums

Python Dictionary to DataFrame

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Python Dictionary to DataFrame

SQL Server interview questions for experienced developers

By Additional Articles

Comments posted to this topic are about the item SQL Server interview questions for...

SQL 2016 - Need help reorganizing the output

By DiabloSlayer

Hello Gurus, Looking for some help to manipulate output data. Here is my SQL...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers