Data extrapolation on the fly
Sometimes we need to generate the data based on a given date, to an end date (data extrapolation).
This is a easy way to do that without any temporary storage.
2008-11-14 (first published: 2008-09-25)
938 reads
Scripts
Display SQL services information
This Script is used to display the SQL and windows services information
by using the Windows Management Instrumentation Command-line (WMIC),
2008-11-11 (first published: 2008-09-20)
1,409 reads
Yet Another Pad Utility
A useful user defined function for padding values from the left or right with any token, number, or character.
2008-11-07 (first published: 2008-09-13)
801 reads
2008-11-06 (first published: 2008-09-12)
1,103 reads
Get Record count of all tables of current database
This script will return record count of all user tables from the current database
2008-11-05
1,101 reads
Add Primary key
This Store procedure is used to add primary key to all tables in a database, if table does not contain it.
2008-11-04
1,000 reads
2008-11-04
1,976 reads
Delimited String Parsing Functions - TwoCol set
Feed it two delimited strings of horizontal data and it returns it back as a vertical table with the two column data in the same synchronized position order.
2008-11-03 (first published: 2008-08-05)
2,259 reads
SP to find the database usage
This SP helps you to find the data file/s and log usage for a given DB
2008-11-01
1,343 reads
Compare SQL code of 2 objects.
Compare SQL code of sp, functions, or triggers. Can run across DB and/or servers. Generates report similar to windif. See details in comments
2008-10-31 (first published: 2008-09-05)
1,157 reads
Blogs
Fighting Procrastination?
By Brian Kelley
Here is another short video (~ 15 minutes). This is by the author of...
A Fun Prize at the PASS Data Community Summit
By Steve Jones
I had a briefing for the 2026 PASS Data Community Summit, which is just...
How to Measure AI Value: A 6-Branch AI Maturity Model for Use Cases and Agents
Your AI is busy. But do you know what it's worth? Most companies can...
Forums
Azure SQL Hyperscale Unveiled
Comments posted to this topic are about the item Azure SQL Hyperscale Unveiled
What is the worst part about existing monitoring solutions?
Hi. What is the most difficult aspect of using monitoring software like idera, redgate,...
MiniMax m3 and SQL Server
Comments posted to this topic are about the item MiniMax m3 and SQL Server
Question of the Day
SQL Server Vector Support I
What are vectors in SQL Server 2025, as related to the new AI features?
See possible answers