• Interests: Scuba Diving, Guitar, Reading

Improved Move indexes to new file group

This is an improved and expanded version of the previously posted script that moves indexes to a new file group. This version will:1. Create new filegrup and files for indexes2. Script out and recreate indexes on new drive3. NEW* output report to text file4. NEW* Will run with enclosed wrapper for ALL DATABASES ON THE […]

4.33 (3)

2006-03-22 (first published: )

1,993 reads

Replication PreScreen for proper Primary Keys

THIS TABLE WILL HODL YOUR TABLENAME AND UP TO THREE KEY COLUMNS FOR CREATING YOUR PRIMARY KEYSTHE OTHER COLUMNS ARE USED IN PROCESSING THE KEY'S AND GENERATING THE ALTER TABLE ASTATEMENTS TOCREATE THE PRIMARY KEYS FOR YOUR DB. THIS TOOL IS HANDY FOR PREPPING FOR A REPLICATION STRATEGY TO HELP YOU QUICKLY INDENTIFY IF YOU […]

2005-08-03 (first published: )

360 reads

LOG SHIPPING FROM SCRATCH

We were experiencing significant issues with Cross Domain Log Shipping, even after getting help from Microsoft. The main reason was that in SQL Server 2000 you cannot access the Log Shipping Wizard from a scripting interface. This set of stored Procedures is all you need to setup a good log shipping framework in your organization […]

2005-08-01 (first published: )

2,988 reads

Blogs

Daily Coping 4 Mar 2021

By

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

Which configuration changes in SQL Server require a restart?

By

SQL Server is a complex beast, with many configuration options that can range from...

Daily Coping 3 Mar 2021

By

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

Read the latest Blogs

Forums

Installing missed items in SQL Server

By itmasterw 60042

Hi, Someone, prior to me, installed SQL Server 2019. and missed a few things...

Redesign of old Table

By bobski

Hi, I am working on an old database table which stores emails, including From,...

Deploy SSIS Package Error: "The selected folder does not contain package..."

By MattieG72

Hi All It seems TFS is not behaving itself! When I deploy a package...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers