Sean Gorman

MOM 2005 Datawarehousing Catchup

I wrote this script because our MOM Datawarehousing got so damn behind.Every time the windows Scheduled task tried to run to warehouse the dataout of OnePoint, it would puke because the SQL log would fill up. Thisallows you to start so many days out and it will increment it down by the number of days […]

2007-10-18 (first published: )

1,382 reads

MOM SCDWgroom Enhancement

It might not be useful now, but if you ever wanted to downsize the amount of data that you keep in your datawarehouse, good luck.  This will help you do that.  This job is set to shrink it down to 120 days, but you can adjust it as you like.  Runs again in 5 day […]

2007-10-16 (first published: )

529 reads

Script to generate replication procs for article

This script is basically a front-end for the sp_"scriptproc" stored procedures that ship with MSSQL.  This will allow you to create ALL of your procs (INS, UPD and DEL) on the fly using the article name instead of having to first search for the article ID.  It also uses sp_scriptdynamicupdproc where appropriate.  This facilitates quick […]

5 (1)

2007-04-23 (first published: )

1,633 reads

Script to aid in Indexing Strategy

When AUTOSTATS is used in a database, we can sometimes use these automatically generated statistics to find columns where SQL Server has built statistics on non-indexed columns that may benefit from an index. This script finds these columns and displays the selectivity of them. This script can be useful in troubleshooting poorly performing databases by […]

5 (1)

2007-04-09 (first published: )

1,730 reads

Maintenance Plan Cleanup Proc

If you use 2 different maintenance plans (one for full-recovery databases and one for simple-mode databases) this proc can help keep the databases in the right plan. You can schedule this as a job and if anyone changes the recovery mode of a database or adds/removes a database, this proc will ensure that the changes […]

2007-04-06 (first published: )

1,610 reads

Blogs

Understanding Azure Geo-Redundant Storage

By

While at PASS Summit 2019, I gave a session on designing Azure Disaster Recovery...

Prompt in ADS

By

Ever since VS Code and Azure Data Studio came out, people have been asking...

When Too Much is Not a Good Thing

By

Explore how to avoid unwanted results that oft occur due to lack of attention...

Read the latest Blogs

Forums

Xquery help please (XML into SQL table)

By Mr. Holio

Hi everyone, any help with the below would be appreciated - see sample data...

Restart cumulative totals to 0 at the change of subsets in a sql table.

By Jocar26

I have a dataset that I want to track the number of cars, trucks,...

Azure DB newbie trying to locate existing Azure DBs

By tarr94

Hello, I've been tasked with trying to learn more about existing Azure DBs that...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers