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

799 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

Custom deployment parameters in Azure Data Factory - Forget Me Not

By

(2020-Sep-26) Last week one of my Azure Data Factory (ADF) deployment pipelines failed with an...

VMworld 2020 – Top 10 Database Sessions (Part 2)

By

Whether you are a SQL Server Database Administrator, Infrastructure Architect, or any other member...

Daily Coping 25 Sep 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

multipoint to line geometry

By lpro

Hi, Attached, I exported a CSV file from a multipoint record from sql server ...

Using SSIS packages build in VS2010 when migrating SQL server from 2008 to 2016

By blom0344

With eof of Windows2008R2, lots of our customers are planning new server setups, usually...

SQLServer Agent not sending dbmail on job completion

By maxo85

Hi Everyone! I have a problem with a SQL Server 2017 with dbmail. I...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers