Who is your audience for the presentation?

What is the expected outcome from the presentation? For example, are you supposed to be justifying time spent, presenting a case for training so...

Glad I could be of some help. Can you post what you did? I might learn something from that.

Some things to look for short of a profiler trace can be found using sp_who and sp_who2 which will show active processes and blocking, sp_lock which will show locks held,...

',' is not found in the string so charindex()-1 is returning -1 which is an invalid length.

I don't know for sure, but I think you would need SQL Enterprise Edition and then do a "virtual cluster". I'm not sure how much you would gain from...

I doubt it was profiler only, but it certainly does add to the load. Have you checked for blocking\locking particularly in tempdb.

Here's another link, http://www.sqlservercentral.com/articles/Test+Data/61572/

I think you want sysfiles.

sys.backup_devices

Don't know how to or if you can do it. The question really is "Why do you need to do it?" There is a probably a set based...

Not sure what exactly you are are looking for, and based on lack of response, I'm not the only one, but based on my understanding you should be able to...

I considered mentioning UNION ALL as well, but I assumed...

Michael,

I don't know why you are getting the error, unless you changed the index name? Here is a feeble attempt to "duplicate" your code in a minimal manner that...

Michael,

I don't know why SQL Server treats them differently, but changing my code to use a specifically named primary key constraint does cause the error, but using the Create Unique...

Check to see if the Databases have the autoclose option is on.

Select DATABASEPROPERTYEX('model', 'IsAutoClose')