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,239 reads
Fastest way to split delimited string in SQL Server
Getting rid of R-BAR to split a delimited string. This method is popular for it's simplicity, speed and zero reads.
2015-03-17 (first published: 2013-07-29)
4,762 reads
Simplest way to search any string in db objects
Easiest way to search for a string in any object within the database.
2013-08-08 (first published: 2013-07-29)
2,281 reads
Blogs
I Want PASS to Survive
By Steve Jones
I want PASS to survive. I can say that unequivocally, because this organization has...
Daily Coping 29 Sep 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
sp_RestoreScript 1.7 Released
sp_RestoreScript 1.7 has been released. For information and documentation please visit https://sqlundercover.com/2017/06/29/undercover-toolbox-sp_restorescript-a-painless-way-to-generate-sql-server-database-restore-scripts/ Changes in...
Forums
Calculation on Row number using Row_Number() OVER
Hi all Looking for some help with the below and massively appreciate any help...
tsql works but store procedure with variable doesnt work
Hello, i just have a simple select statement, and i get the max value...
slack community dbatools
Good morning all , Who has an idea please how I can join the...
Ask SSC