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)

You rated this post out of 5. Change rating

2008-01-07 (first published: )

8,405 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)

You rated this post out of 5. Change rating

2006-10-20 (first published: )

548 reads

Blogs

Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework

By

I’m excited to announce the release of a new open-source project that fully automates...

Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework

By

I’m excited to announce the release of a new open-source project that fully automates...

Advice I Like: Praise

By

Don’t reserve your kindest praise for a person until their eulogy. Tell them while...

Read the latest Blogs

Forums

Is there a way to have dynamic table headers?

By water490

Hi everyone I have a SP which compares two tables and outputs mismatching entries:...

Learning a New Language

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Learning a New Language

is there a way to "detect" schema like changes on a server?

By stan

Hi, we have a few people who like to experiment on our prod sql...

Visit the forum

Question of the Day

Copying Production Schema

If I use DBCC CLONEDATABASE, can I remove some of the information from the copy?

See possible answers