Speaking as a PASS volunteer who will (hopefully) get comped on admission, I'd be willing to both pay a fee AND forego prizes in favor of those who registered through...

Are the columns individually overridden? If so and you're planning on storing a sparsely populated table, I sure hope you don't have do searches on the data. Without the filtered...

It sounds like you may be on the right track. Just remember that Profiler is only going to show you what happened, not what could happen.

You could use Profiler to capture the actual execution time.

There's no way to know in advance how long a query will take. You can look at an execution plan for the estimated cost, but because of I/O contention, CPU,...

Welcome to the forums. Keep your hands and feet inside the vehicle at all times.

Performance wise, you have to reference two tables right now. Plus the fact that you can...

Yeah, OSQL will work fine. It's still back to what I said. Open a new connection, either by spawning a thread or using another executable, one you built or one...

I'm not adverse to using it, but I've only seen string parsing or complex math solutions that were clearly more viable with the CLR than with TSQL code. Get me...

I still think it all comes down to a business verification. I can't tell you how many times I've gotten the word to restore the backup for a certain date....

You should have Profiler. You can capture that.

You can also run Perfmon to capture the counters over time. Output them to a file and then you can use those with...

There's always the documentation:

http://msdn2.microsoft.com/en-us/library/ms130214.aspx

It's called SQL Server Agent and it runs as a seperate service on all server installs (it's not in Express or Compact).

Do these transactions include lots of data changes? You might be getting recompiles on your procedures. You'll need to follow Gail's advice and get the wait stats.

And you will need to show execution plans so that bottlenecks can be identified.

The wizard should work. You can also select all your procedures in the Object Explorer Detail window by first clicking on the Procedures folder in the Object Explorer window. In...