Loop Through every table in a DB
This Script has been build to list all the tables in a database without using a cursor.
2009-01-20 (first published: 2009-01-05)
2,096 reads
Scripts
Truncate Referenced Table
Often during the development phase one is required to truncate a table. often the task of removing foreign key references is necessary to truncate. this sp takes the pain out of it.
2009-01-19 (first published: 2009-01-05)
1,310 reads
2009-01-16 (first published: 2009-01-03)
2,661 reads
Yet Another Deleting Duplicate Records (in-place)
Here is another "deleting duplicate records" script, this time in-place, using a uniqueidentifier column.
2009-01-15 (first published: 2008-12-30)
1,954 reads
Find database file reamaining growth
This script is used for SQL Server 2000 Database file remaining growth. This script is little bit modified to fit SQL Server 2000.
2009-01-14 (first published: 2009-01-03)
1,240 reads
Indepth SPID information
This SP gives you most of the detail you need on a long running query. Simply pass the SPID.
2009-01-09 (first published: 2008-12-31)
2,303 reads
Complete Blocking Report
A complete blocking report which gives the complete information about what queries are runninng and it will be worth capturing the details before we decide to kill the processes.
2009-01-08 (first published: 2008-12-26)
2,219 reads
2009-01-07 (first published: 2008-12-26)
2,137 reads
Object Search for Sql Server 2005
This script will search databases, tables, columns, stored procedures for text.
2009-01-05 (first published: 2008-12-21)
1,292 reads
Getting unique or primary key columns for a given table
Following script will list out all the columns which have unique/primary key constraints for a given table.
2009-01-02 (first published: 2008-12-10)
1,278 reads
Blogs
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Forums
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Execute as failure
Security has long been a problem for me. Every time I think I understand...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers