Sean Gorman


Technical Article

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 […]

You rated this post out of 5. Change rating

2007-10-18 (first published: )

1,386 reads

Technical Article

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 […]

You rated this post out of 5. Change rating

2007-10-16 (first published: )

534 reads

Technical Article

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)

You rated this post out of 5. Change rating

2007-04-23 (first published: )

1,711 reads

Technical Article

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)

You rated this post out of 5. Change rating

2007-04-09 (first published: )

1,740 reads

Technical Article

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 […]

You rated this post out of 5. Change rating

2007-04-06 (first published: )

1,613 reads

Blogs

A First Look at Redgate’s Subsetter

By

I have been a proponent of subsetting databases in dev/test for a long time....

Azure SQL MI License free?

By

A common setup when leveraging the cloud is to use the cloud for Disaster...

Foreign Keys in SQL Data Generator

By

A customer recently asked about using FKs in SQL Data Generator, and I decided...

Read the latest Blogs

Forums

Using AI for Security

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Using AI for Security

Writing to Clones

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Writing to Clones

Live webinar: How to excel at managing multiple database platforms

By Press Release

Comments posted to this topic are about the item Live webinar: How to excel...

Visit the forum

Question of the Day

Writing to Clones

I run this code on SQL Server 2019:

DBCC CLONEDATABASE(imdb, imdb_dev)
I then change to the cloned database, imdb_dev, and run some queries. I then run this code while testing:
INSERT dbo.Title (TitleID, Title, DateReleased) VALUES (3234, 'Maestro', '2023')
GO
What happens?

See possible answers