Technical Article

Script to find text in stored procedures

This is a simple script that when used by command-line OSQL/ISQL can help you locate a stored procedure.How many times have you been looking for stored procedure code and could not find it?  This is a simple method to locate lost code.When you manage many database servers this can become a common problem.  The scenario […]

5 (2)

2007-09-14

1,935 reads

Blogs

Hyperconverged storage tuning tip for SQL Server

By

We all (should) know that running SQL Server in hyperconverged virtual environments, both on-premises...

Daily Coping 25 Nov 2022

By

Today’s coping tip is to connect with someone from a different generation. This tip...

Snowflake Classic UI vs Snowsight

By

This blog post is not about which User Interface is better, Classic or Snowsight...

Read the latest Blogs

Forums

Null value when checking unused indexes

By Bruin

I'm using this query to check if I have any unused indexes.. One of...

Retrieve Password from CyberArk using powershell

By Alone

Hi, I am new to Powershell script and i have to create a power...

Multiply time by hourly rate

By pedroccamara

Hello all, I have this table with time for each row. It shows hh:mm....

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers