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

You rated this post out of 5. Change rating

2006-08-17 (first published: )

1,068 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.

You rated this post out of 5. Change rating

2005-12-29 (first published: )

2,137 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 […]

You rated this post out of 5. Change rating

2004-12-16 (first published: )

373 reads

Blogs

PowerShell (and T-SQL) and Elastic Jobs

By

I’ve covered how to create Elastic Jobs in the portal (this one is important...

A New Word: Redesis

By

redesis – n. a feeling of queasiness while offering someone advice, knowing they might...

Friday Flyway Tips: Autopilot in 10 minutes

By

The Solutions Engineers at Redgate recently released an Introduction to Redgate Flyway Autopilot course...

Read the latest Blogs

Forums

How to Obtain Call History of a Stored Procedure/UDF

By YSLGuru

I know in the past this wasn't possible but maybe that's changed as SQL...

No End to Programmers

By Steve Jones - SSC Editor

Comments posted to this topic are about the item No End to Programmers

Solution to a problem without using a CURSOR

By krishnagceb

Hi there to all SQL gurus So, here is the scenario. I have a...

Visit the forum

Question of the Day

Counting Bits II

What is the result of this query in SQL Server 2022+?

select bit_count('7')

See possible answers