Miscellaneous

Technical Article

Script to Find Locations of Specified Column

  • Script

Use this script to find tables, views, stored procedures that directly reference a column in the SELECT statement or in a join. This script will also return stored procedure and view names that have SELECT * in them when the specified column exists in the table referenced by that SELECT statement.

4 (1)

You rated this post out of 5. Change rating

2002-03-15

1,053 reads

Technical Article

Find Missing Constraints

  • Script

Procedure to help find missing constraints when comparing two databases that are supposed to be the same.  SP has ability to show all constraints per database, and the ability to generate create scripts to make adding the missing constraints easier.

You rated this post out of 5. Change rating

2006-12-26 (first published: )

776 reads

Technical Article

Pivot Data based on Unknown Field Items

  • Script

I was posed a question a few months back on another site about being about to create a Pivot Table (Horizontal version of vertical data) and I saw the question again today. This will allow you to do that, just make changes to the query where the title is the replacement need. It will build […]

1 (1)

You rated this post out of 5. Change rating

2002-03-07

1,323 reads

Blogs

Come See Me at the PASS Data Community Summit

By

I'm speaking on Quantum Computing at the PASS Data Community Summit. It's scheduled for...

SQL Clone at Scale with Striped Backups

By

I had a customer recently reach out to ask if SQL Clone would work...

How to Set Up SQL Server 2025, Ollama and NGINX in Docker Without the Headaches

By

Ollama SQL FastStart kit just works out of the box. It makes it easy...

Read the latest Blogs

Forums

Create an HTML Report on the Status of SQL Server Agent Jobs

By Nisarg Upadhyay

Comments posted to this topic are about the item Create an HTML Report on...

Holistic Approaches to Overcoming Erectile Dysfunction

By marksmith9698

Erectile dysfunction (ED) affects millions of men and arises from a combination of physical,...

Managing unused indexes

By JasonO

While doing some housekeeping activity on several old but large production databases, I come...

Visit the forum

Question of the Day

Striped Backup File Limits

In SQL Server 2022, how many backup files can I have in a striped backup?

See possible answers