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,315 reads
Scripts
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,445 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,356 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,824 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,142 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,088 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,184 reads
2015-03-25 (first published: 2014-02-25)
8,476 reads
Calendar Table by Interval Minutes
Populate a calendar table with user set interval start and end datetime values.
2015-03-24 (first published: 2014-02-21)
2,490 reads
Database Mirroring Setup Procedure generator
A script that generates all the commands for installing a new database mirroring between two servers
2015-03-20 (first published: 2015-03-17)
962 reads
Blogs
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
How to Move the SSMS Status Bar to the Top and Color-Code SQL Server Connections
By Hemantgiri
I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But...
Forums
Split Large Queries in Athena with a Simple Modulo Trick
Comments posted to this topic are about the item Split Large Queries in Athena...
Finding Trailing Spaces
Comments posted to this topic are about the item Finding Trailing Spaces
Question of the Day
Finding Trailing Spaces
I have some data in a SQL Server 2025 database. It looks like this for the dbo.Customer table:
CustomerID CustomerName PreferredName 1 Steve Steve 2 Andy Andy 3 Brian Brian 4 Allan Allan 5 Devin Devin 6 Steve Steve 7 Sally SallyI want to detect which names have a single trailing space. The CustomerName is a varchar() and the PreferredName is a CHAR(). Does this query detect the problem rows?
SELECT
CustomerID,
CustomerName,
PreferredName
FROM Customer
WHERE CustomerName <> RTRIM(CustomerName)
OR PreferredName <> RTRIM(PreferredName); See possible answers