Advanced Search Stored Procedure

The script finds occurrences of string(s) in stored procedures, triggers and views. You can use typical boolean logic as described in the script comments. Very useful.  It was found on the companion cd to [Gurus Guide to Transact-SQL] by Henderson.  I left in the original credits.  Excellent procedure.  Some may scoff but I place it […]

2004-07-15 (first published: )

456 reads

CSV Lists of Columns in Different Formats

This script creates comma separated lists of columns in different formats. These lists can be copied and pasted into other T-SQL statements.  The lists are formatted as: a simple list of column names, a list with the column names as declared variables (@ + column name + data type), a list with column names as […]

2002-12-26

194 reads

Blogs

Understanding Disk Performance and IOPS in cloud platform

By

In the past many years, apart from working as DBA, I was working with...

COVID-19, a wake-up call

By

COVID-19 is the only pandemic I’ve seen in my whole life. It gave me...

ASF 030: Benni De Jagere interview

By

Introduction Benni De Jagere is a Senior Data Insights Consultant with a strong focus...

Read the latest Blogs

Forums

Epic Keto

By hgumbdqwpkod

https healthygossips com/epic-keto/  

How to make join to teams display without join all teams ?

By ahmed_elbarbary.2010

problem How to make left join to only teams displayed  dynamically depend on fields...

sql server memory buffer cache building up question

By sqlguy80

question for DB Gurus when sql server is restarted, it will be slow at...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

SQLCMD Output

See possible answers