Miscellaneous

Script to find text in stored procedures

  • Script

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,799 reads

Combine multiple rows into single output

  • Script

We can use this function to combine multiple rows into single one. Generally to create comma separated list for each unique item. So this can create comma separated product list for any given category. The same can be used to make a list of items in a given order.ThanksMohit Nayyarhttp://mohitnayyar.blogspot.com/

5 (3)

2007-09-14

3,599 reads

LSTR() and RSTR(): Enhanced LEFT() and RIGHT()

  • Script

Quite often I need to cut off the first (or last) few characters of a string. To do just that I created two functions LSTR() and RSTR().Syntax: LSTR( @stringtocut, @length )Note: @stringtocut is trimmed in the functionWhen @length is equal or larger than zero, this function performs the same as LEFT( LTRIM(RTRIM(@stringtocut)), @length ).When @length […]

1.67 (3)

2007-09-13

821 reads

finding the blocks in sql server

  • Script

Hai buddies,The following procedure can be used to find whether there are any blocks in the sql server.The procedure if run in Master database , can be used like any other system stored procedure from any database.The output of the proc will contain the followingSPID OF RUNNING APPLICATIONAPPLICATION NAMEEXECUTING DATABLOCKED (Y/N)BLOCKING SPIDBLOCKING APPLICATIONEXECUTING DATA (BLOCKING […]

3.67 (3)

2007-09-09

3,525 reads

Blogs

Data Lake Architecture using Delta Lake, Databricks and ADLS Gen2 Part 3

By

This is the third post in a series about modern Data Lake Architecture where...

Event Notifications Example

By

Event notifications are kinda like a trigger in the sense that they respond to...

Did you know we have another SQL Server book coming out?

By

SQL Server 2017 Administration Inside Out was the first technical book I contributed to,...

Read the latest Blogs

Forums

Instant support and customer service of Outlook

By microsofthelp1

Need assistant help and support of Outlook? Okay, dial our Outlook customer service number...

Job Notifications

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Job Notifications

Data Science, BI, and Reports

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Data Science, BI, and Reports

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers