Script Generates Audit Triggers
This script generates a audit trigger for each table in the database. The trigger then logs when each table is updated.
2011-11-23 (first published: 2008-05-09)
4,801 reads
Scripts
2011-11-22 (first published: 2008-03-19)
5,902 reads
Extract More Than 1000 Active Directory Accounts
This is a simple method to load a SQL database with active directory account information without running into the 1000 record limit. You will need to change the SERVERNAME, PORT, DATABASENAME, USERID, AND PASSWORD values in the connection strings to your own values. You will also need to change the LDAP connection string values ('LDAP://SERVERNAME/ou=OUName,dc=host,dc=domain,dc=tld') […]
2011-11-21 (first published: 2007-08-01)
2,840 reads
2011-11-18 (first published: 2008-01-29)
2,924 reads
Server Up-Time Information
Calculates server uptime in days, hours, and minutes. Also calculates the UTC date (smalldatetime) when the server was started.
2011-11-17 (first published: 2007-08-31)
2,463 reads
Fix orphaned users after restoring database to another server.
Script reassigns database orphan users to the matching SQL Server logins.
2011-11-15 (first published: 2011-10-24)
2,585 reads
sp_MSforeachtable:Add SQL objects to multiple database on a server.
ADD SQL OBJECTS(TABLES, VIEWS, SPS, UDFS ET AL) TO ALL THE DATABASES ON THE SERVER.
2011-11-14 (first published: 2011-09-19)
706 reads
Database Files Physical Location
Displaying the SQL Database names and its associated files in the System drives in which the files are stored / mapped.
2011-11-11 (first published: 2011-09-27)
1,180 reads
Last month Name and Year in a SSRS expression
Show the last month and year in a expression, based on a parameter called asofdate. Must format Date Month Year
2011-11-08 (first published: 2011-10-11)
9,179 reads
Extract values from a string using a delimiter
There are many occasions in programs where you need to manipulate strings of characters that are delimited by a particular character, such as a comma, or a space. This function enables you to extract a substring from the string at a specified occurence of the delimter. declare @Data varchar(255) set @Data = 'A,B,C,D,E' print dbo.field(@data,',',2,2) […]
2011-11-07 (first published: 2007-08-03)
2,637 reads
Blogs
Part 3 of 3: Tuning DiskANN — R, Alpha, L, Beam Width, Recall and Latency
In Part 1, we saw how ‘Vamana’ represents vectors as nodes, connects them with...
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
Forums
Optional Parameter Plan Optimization in SQL Server 2025: Fixing the Kitchen-Sink Search Procedure
Comments posted to this topic are about the item Optional Parameter Plan Optimization in...
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
Question of the Day
ORDER BY alias
There is a table tmp_tab:
CREATE TABLE tmp_tab ( id int, val int );
INSERT INTO tmp_tab VALUES (1, 1), (2, NULL), (3, 3), (4, 4), (5, 5);You want to order the rows ids by the following expression:
ISNULL(val, id) + 1Which of the following queries produces the expected ordering and why? (Select all correct) See possible answers