relatively simple mode, median, mean

Here's a sample script to help you get some generic mode, median, and mean statistics for something. In my example, I'm getting the number of days something takes to start and stop some task. The idea is that I'd have a fairly short list of jobs, and record would record the job id, and start/stop […]

2006-08-17 (first published: )

919 reads

Change column collations back to database default

This script will create a single-line ALTER TABLE statement for each column in any table to change the collation to match the 'database default'. This is best accomplished in the Query Analyzer -- simply run the script, select all the records, and paste them into a new window to run them.

2005-12-29 (first published: )

721 reads

Large auto-job-creation script for adding backups

This script creates a stored proc that was intended to run from a trigger on the master..sysdatabases for each database creation. Alas. It will create three jobs for each database you apply it to. First, it'll create a job to run a full backup each Sun, at 5am (see below). Those backups will be retained […]

2004-12-16 (first published: )

367 reads

Blogs

Covid Thoughts, So Far

By

I’ve gathered a bunch of notes from conversations and time reflecting, thought I’d write...

How to Think Like a Certification Exam at the PASS Professional Development Virtual Group

By

Thanks for the 90+ who joined today's PASS Professional Development Virtual Group webinar on...

Deploy BACPAC to Azure Managed Instance failing from SSMS?

By

Recently I ran into an error when trying to copy a small database bacpac...

Read the latest Blogs

Forums

Advantages and Disadvantage using Temp Table or Fisical Table

By fransiscuscandra

Please share your thought about advantages and disadvantages for processing using temp table or...

Do people process data from beginning of time when there is data change?

By fransiscuscandra

This might be a beginner developer questions but need some clarifications. What is best...

Why would I want to use Compress and Decompress functions?

By VoldemarG

in what live operational or development situation /requirement would I want to use the...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers