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: )

429 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

Power Platform Quick Tips – Episode 01: Fixing Power BI Column Sorting

By

Check out this new series that I’ve started on Power Platform Quick Tips. This...

The curious case of CHAR(0)

By

Over the years I’ve seen quite a few strange things with SQL Server. This...

Transaction log Information gathering

By

Here are the different ways to know the tlog file related information sys.dm_db_log_stats –...

Read the latest Blogs

Forums

how can i see the last 100 select statements that were run by any user

By VoldemarG

how can i see the last 100 select statements that were run by any...

Dynamically execute SSIS package.

By ugh3012

I am trying to figure out how to dynamically execute SSIS package based on...

Metric CPU show 100% , but Query Performance Insight show only 60% same period

By ebooklub

Hi, I am investigation DTU spike for period specific period of time In my...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers