Hi there,

One of my coworkers have used them and found them useful.

Couple of sites I can recommend are:

http://www.sqlserver2012tutorial.com

http://www.sqlskills.com/sql-server-training/online-training/

Kashef

Also you may have a situation where the data is broken by geo-location.

You could create a specific sequence per db per location.

Kash

Senior DBA and Trainer

http://www.sqlserver2012tutorial.com

Hi Steve,

Thanks for the updated article.

For me, I have also used this to find the correct version.

SELECT SERVERPROPERTY('productversion')

10.50.1600.1

Kash

Instructor

SQL Server Tutorials

http://www.learningsqlserver2008.com

I would say copy the database to development and test with the following events:

-RPC:Completed

-SP:Completed

This blog discusses the topic well.

http://social.msdn.microsoft.com/Forums/en/sqltools/thread/0c922a7f-f782-4179-a42c-3b7310652463

Also this is mentioned in the sample video from this...

Nice explanation about the joins,

I found this blog post [http://slackerdba.blogspot.com/] that gives good details about the basic joins with good examples.

Hope that helps.

I found some more here, however these are on SQL 2008:

http://www.learningsqlserver2008.com/member.htm

The free ones are on Profiler, Installation, Data Compression and Performance Tuning.