Technical Article

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: )

1,008 reads

Technical Article

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: )

1,516 reads

Technical Article

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: )

369 reads

Blogs

Daily Coping 31 Jan 2023

By

Today’s coping tip is to take a small step towards and important goal. One...

Tales From The Field Weekly Wrap Up for the Week of 01-23-2022

By

 Hello Dear Reader!  It's been a while since I had time to sit down...

CONCAT_WS Function Truncates Text

By

I was writing some dynamic SQL that generates some SQL statements to load my...

Read the latest Blogs

Forums

SSIS Sort Alphanumeric?

By John524

Hello, I'm pretty new to SSIS, but I have an Excel source that I...

How to get number of unique months from table

By pelusch

Hi guys, I want some help with a code to count the number of...

Track Insert/Update/Delete Operations in Sql Server DB Table

By RCRock

Hi Team, I have a requirement to track any insert/update/Delete operations happened against Database...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers