Technical Article

Find Text in Database Objects (triggers / stored procedures)

I find myself refacoring an existing database which has some inefficient code, like cursors in stored procedures and triggers ...Wanting to figure out which objects contained this "poor" code, I made myself a little script to list all the objects which contain a search string.Just change the value that @search is set to and run […]

5 (1)

You rated this post out of 5. Change rating

2007-03-01 (first published: )

1,157 reads

Blogs

Reading JSON Data with Python

By

Recently I’ve been looking at archiving some data at SQL Saturday. As a start,...

5 Advanced Online SQL DBA Training Courses to Learn in 2024 and Beyond

By

Buckle up, database wranglers! Nowadays, SQL DBAs hold the keys to a company's most...

Dynamically Unpivot columns in SQL

By

Picture this, your data ingestion team has created a table that has the sales...

Read the latest Blogs

Forums

Crazy Interviews

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Crazy Interviews

The Query Traceflag

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Query Traceflag

Using Machine Learning Pipeline Execution Activity in Azure Data Factory

By Sucharita Das

Comments posted to this topic are about the item Using Machine Learning Pipeline Execution...

Visit the forum