Robert Cary

  • Interests: Sleight of hand magic, cycling, bowling, poker

SQLServerCentral Article

Searching Syscomments Accurately

As a SQL Server DBA you should know that your code is stored in syscomments by default. While most DBAs use version control systems, there are times you might want to look through the code on the server for comparison purposes. Robert Cary brings us an article on how you can do this in 2000 and 2005.

4.8 (5)

2008-01-07 (first published: )

8,206 reads

Technical Article

Find Nth Occurrence of Character Function (Set Based)

This function was originally contributed by other visitors. Below is an example of a set based approach to the problem. This script requires a numbers table (see SqlServerCentral article http://www.sqlservercentral.com/columnists/mcoles/2547.asp for more details)Please note that this code is uses SQL2005 featuresEnjoy!Robert Caryhttp://tsqlland.blogspot.com

5 (1)

2006-10-20 (first published: )

540 reads

Blogs

Daily Coping 29 Sep 2022

By

Today’s coping tip is to avoid saying “I should” and make time to do...

How to Calculate Compound Rate in Power BI

By

Recently I had an interesting use case where I had to a compound calculation...

Daily Coping 28 Sep 2022

By

Today’s coping tip is let go of other people’s expectations of you. I think...

Read the latest Blogs

Forums

CHECKDB returns o

By webrunner

Hello experts, I ran sp_Blitz and on a dev server and saw two results...

sp_send_dbmail using HTML with templates and injecting datasets

By aaron.reese

Morning all,  Looking for any advice or thoughts on how to achieve the impossible...

Forms Authentication Setup for SSRS in 2019

By mohan.bndri

As I was looking the authentication set up which come as default when we...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers