Sending Job Failed Information Through E-Mail Using T-SQL
Sending Job Failed Information Through E-Mail Using T-SQL.
2012-03-06 (first published: 2012-02-13)
2,321 reads
Scripts
Generate consecutive numbers
TSQL code that generates numbers (tally table) from 1 to N without using any tables
2012-03-01 (first published: 2012-02-21)
1,807 reads
Week Starts On Saturday?
A function that emulates SET DATEFIRST 6 within a function for finding relevant date information.
2012-02-29 (first published: 2012-02-15)
524 reads
Currently Running Process - 2005
This script will show the currently running queries in the system. It will give the entire script which is involved in the background.
2012-02-28 (first published: 2012-02-01)
1,411 reads
TSQL that lists all numbers from 1..100
This query shows how to write a T-SQL statement that lists all numbers between 1 and 100 ordered, without use of any DATABASE table with only ONE select statement.
2012-02-20 (first published: 2011-12-31)
2,267 reads
PowerShell SCript to export almost everything from a list of servers
Create a c:\servers.txt list of servers. No spaces or it wont work. Then copy the code into a ps1 file and edit the directroyfilename to show where you want the files to end up.
2012-02-17 (first published: 2012-01-23)
1,868 reads
Find storage including mount points Sql and windows utility
Find drive, freespace, usedspace and percent free for all drives and mounted volumes.
2012-02-16 (first published: 2011-12-15)
815 reads
Integer left and right shift
3 functions that implement the left (<<), right (>>) and unsigned right (>>>) shift operators, commonly found in C-style languages.
2012-02-15 (first published: 2011-12-30)
8,118 reads
Find gaps in primary keys across multiple databases
Output table of gaps in a primary key across multiple databases on same, remote and/or linked servers.
2012-02-13 (first published: 2011-08-12)
946 reads
2012-02-13 (first published: 2011-12-30)
1,710 reads
Blogs
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Forums
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers