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

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

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

366 reads

Blogs

Power Platform Quick Tips – Episode 02: Dynamic Power Apps Form Headers

By

Welcome back to my Power Platform Quick Tips series! In this second episode we...

Simple-Talk Article…Understanding Azure Storage Options

By

Simple- Talk is technical journal and community hub from Redgate. This week I have the pleasure of...

T-SQL Tuesday #120 – Recap

By

The wrap up post for T-SQL Tuesday #120. 9 bloggers contributed this month. The post...

Read the latest Blogs

Forums

Numeric and Decimal

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Numeric and Decimal, which is...

Best Law Practice Management Application - Law Software

By adjonline

ADJ Online Web edition covering all cases, justice, judgements, Allahabad daily judgement, Lucknow high court...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers