Technical Article

Function to Split a Delimited String into a Table

This function splits a delimited string (up to 4000 characters long) into a single column table. The delimiter can be specified at the time of execution. If not specified, the delimiter defaults to a comma. The default length of each value is 100, but that can easily be changed.An example for usage:DECLARE @string NVARCHAR(4000)DECLARE @instruments […]

3.17 (6)

You rated this post out of 5. Change rating

2007-05-25 (first published: )

5,634 reads

Technical Article

Drop a Column and its Constraints and Indexes

Drops the specified column from the specified table as well as any constraints and indexes that depend on the column. By default the script will just find the corresponding column, constraints, and indexes.Comes in handy for patching databases.

3.5 (2)

You rated this post out of 5. Change rating

2007-01-24 (first published: )

2,438 reads

Technical Article

Backup any/all Databases (Native AND LiteSpeed friendly)

This script can run backups for any/all databases using both SQL native and Quest's SQL LiteSpeed product. It includes options for Complete (Full), Differential, and Transaction Log backups (File and File Group backups will be coming soon). It will also clean up old backups and the msdb tables accordingly.See script for a full parameter list.NOTE: […]

5 (3)

You rated this post out of 5. Change rating

2006-10-25 (first published: )

5,168 reads

Technical Article

Function to return the SQL Build Number

This function returns the SQL Build Number as a nvarchar(20) string. i.e. '8.00.760' @@Version is great, but super long, and the formatting of the string has changed over the years. This helps me find out what build of SQL I'm working on in a quick and efficient manner. The script includes the drop statement as […]

5 (1)

You rated this post out of 5. Change rating

2006-08-09 (first published: )

1,013 reads

Technical Article

Function to return the SQL Version Number

This function returns the SQL Build Number as an int. i.e. 7, 8, or 9. @@Version is great, but super long, and the formatting of the string has changed over the years. This helps me find out what version of SQL I'm working on in a quick and efficient manner. The script includes the drop […]

You rated this post out of 5. Change rating

2006-08-08 (first published: )

1,229 reads

Technical Article

Stored Procedure to get Job History (with Steps)

This procedure returns the job history for any jobs run on a given day. The parameter should be entered in mm/dd/yyyy format surrounded by single quotes. I use it to produce a report of any jobs that failed on any given day.It should be created on the MSDB database.Example: EXEC usp_job_history '10/02/2004' This is my […]

You rated this post out of 5. Change rating

2004-10-04

2,156 reads

Blogs

Extending a SQL Server Failover Cluster Across Regions in  Google Cloud Platform (GCP)

By

I was the principal author of this SIOS whitepaper, which describes how to build...

Heading to 2024 PASS Summit

By

I am able to head back to Seattle for the PASS Summit this year....

Tell me the positives of your solution

By

I still have a tendency to talk about all the cons of a proposed...

Read the latest Blogs

Forums

The Cloud Security Problem

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Cloud Security Problem

Virtualizing AWS data by using Fabric Shortcuts: Data Engineering with Fabric

By John Miner

Comments posted to this topic are about the item Virtualizing AWS data by using...

Timescale Brings PostgreSQL into the GenAI Era with pgai Vectorizer

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Timescale Brings PostgreSQL into the...

Visit the forum

Question of the Day

The LAGging NULL

I have this data in a SQL Server 2022 table:

player         yearid team HR
Alex Rodriguez 2012   NYY  18
Alex Rodriguez 2013   NYY  7
Alex Rodriguez 2014   NYY  NULL
Alex Rodriguez 2015   NYY  12
Alex Rodriguez 2016   NYY  9
If I run this code, what are the results returned in the hrgrowth column?
SELECT
  player
, yearid
, hr
, hr - LAG (hr, 1, 0) IGNORE NULLS OVER (ORDER BY yearid) AS hrgrowth
FROM dbo.playerstats;

See possible answers