Automate Data Purity Investigation
Sometimes running DBCC CHECKDB WITH DATA_PURITY returns thousands of affected columns. This script automates the identification of those columns.
2015-04-13 (first published: 2013-07-04)
2,424 reads
Scripts
Find Stored Procedures and Functions That Reference Certain Tables
Find any code objects that interact with a given table/view, or call another given code object.
2015-04-10 (first published: 2013-07-05)
4,634 reads
Parse XML to table
A stored procedure that will parse (shred) the contents of any well-formed XML document into a SQL table.
2015-04-08 (first published: 2013-07-09)
5,225 reads
Fastest way to find DB object dependencies
One of the fastest ways to find out objects dependencies in SQL Server.
2015-04-07 (first published: 2013-07-29)
3,304 reads
Search a string in a text with number of occurrences
IF you have a long string and if you want to search a specific input string, and number of timeS the string has occurred then it's helps
2015-04-06 (first published: 2015-03-29)
1,436 reads
Check Existence of Server and find Instance Type
Execute the function and pass only the SQL Server Name to check if the SQL Instance is available and if yes, what is the Instance Type.
2015-04-02 (first published: 2015-03-26)
1,327 reads
Check if SQL Server is running
This script will check if the SQL Server you are connected to is actually running.
2015-04-01 (first published: 2015-03-27)
1,809 reads
Check running SQL Services
Check all the running SQL services in different servers.
You can use the details before you start implementing SQL Patch to the servers i.e. if you want to explicitly stop the SQL Services.
2015-03-31 (first published: 2015-03-26)
2,127 reads
List Table Foreign Keys, Primary key and indexes
This procedure let you list [optional] by table:
-Foreign keys
-Primary key
-Indexes
2015-03-27 (first published: 2014-02-06)
4,056 reads
SP Send Query Result as HTML table using DBMail
Create a stored procedure that will send the result of a query as an html table from the database mail.
2015-03-26 (first published: 2014-02-14)
5,153 reads
Blogs
Take Time to Gain Perspective
By Brian Kelley
Probably the best piece of advice I ever received is to take time to...
The Fringe Festival
By Steve Jones
I was lucky enough to take a vacation a decade ago in Edinburgh with...
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
Forums
Learn From History
Comments posted to this topic are about the item Learn From History
Alamat Kantor BCA KCU Cianjur Telp:08218154374
Hub Via Wa:628218154374 Alamat Jl. HOS Cokro Aminoto No.56-58, Muka, Kec. Cianjur, Kabupaten Cianjur,...
Alamat Kantor BCA KCU Depok Telp:08218154374
Hub Via Wa:628218154374 Alamat Jl. Margonda Raya No.182, Kemiri Muka, Kecamatan Beji, Kota Depok,...
Question of the Day
The SQL Server MCP Server
How do I get an MCP server for my SQL Server 2025 database from Microsoft?
See possible answers