2008-11-20 (first published: 2008-10-06)
983 reads
Scripts
random randomise randomize data query
this is a MUCH simpler method of random randomize randomise rand data from a table
2008-11-19
296 reads
Queries, Plans, and Indexes
Find indexes associated with queries and vice versa. Helps figure out what procedures are using indexes.
2008-11-18 (first published: 2008-07-31)
1,718 reads
Backup And Restore Remain Time
Script to found out how much time before Restore or Backup Process remain
2008-11-17 (first published: 2008-09-30)
1,066 reads
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)
915 reads
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,387 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)
789 reads
2008-11-06 (first published: 2008-09-12)
1,047 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,086 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
988 reads
Blogs
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
Monday Monitor Tips: Configuring Access to the MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers