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)
942 reads
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)
942 reads
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,411 reads
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)
812 reads
2008-11-06 (first published: 2008-09-12)
1,120 reads
This script will return record count of all user tables from the current database
2008-11-05
1,105 reads
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,004 reads
2008-11-04
1,978 reads
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,265 reads
This SP helps you to find the data file/s and log usage for a given DB
2008-11-01
1,346 reads
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,167 reads
By Steve Jones
I wrote about Flyway Desktop Object History in a previous tip. This feature has...
By Arun Sirpal
AgentDBA (the database agent I have been building) has more than 1000 automated tests,...
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
Comments posted to this topic are about the item Server-level Roles
Comments posted to this topic are about the item Pay for Performance
Comments posted to this topic are about the item Tracking Inserted, Updated, and Deleted...
In SQL Server 2025, can I alter a fixed server role?
See possible answers