USER PROCESS CHECK (COMPLETE)

The following runable script is a very simple way to track SPID's and PROCESS information (VERY BASIC) in a small target (Local) database.1. Creates a small database 1.1 must set MDF and LDF (File location information) specific to the drive and file folder locations for each server2. Sets All db options3. Creates single table to […]

2005-01-14 (first published: )

204 reads

MSP_Restore

Simple Procedure to rapidly rebuild a copy of Development TEST1 DB...Lovely and fast when Tard Developers have highlevels of access  and you just need them out to restore / refresh a db...KILL KILL KILL !!! Remember to reset / resolve users and permissions after this is run. I use a DTS RUN statment with a […]

2003-12-18

170 reads

Blogs

Renaming Files by Padding Numbers with PowerShell

By

Some time ago I had downloaded all the SQL Saturday XML files. I’ve been...

When do Statistics get updated?

By

Statistics objects are important for allowing the SQL Server Optimizer to make good estimates...

Power BI: Making Date & Time Keys

By

Saving the Day from Delay Part 2 Creating DateKey and TimeKey columns can be...

Read the latest Blogs

Forums

Date format - being overridden?

By NicHopper

Hi all, Got a strange one here that I hope someone can help with....

Best way to understand Querying much better

By pietlinden

What's the best way to get better at T-SQL Querying? Something like Read/do the...

Intermittent "nesting level exceeded" error

By julian.fletcher

We're having a very peculiar problem with the "Maximum stored procedure, function, trigger, or...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers