Cool. Thanks for the help everyone. Much appreciated.

Ross

Do you have an example of this? That is really cool!

Thanks,

Ross

Yeah I have been thinking about that.

I do not think this code would end up on any of the actual servers. I was thinking on my local machine only....

"An obvious issue here that needs to be addressed would be how to check (and respond to) %ERRORLEVEL% after each osql call"

I am hoping this is where the OutputTable will...

Well we go our issue taken care of. It was not pretty. Here is the lowdown. Essentially we overloaded replication with an update that affected 7 million rows, along with...

The update did work. The problem now is that we have so many transactions that the log reader agents are timing out trying to read them. We have been on...

This is great advice.

I would be curious to know however how many environments allow people to create objects with other than DBO as the owner. In both environments where I...

What really convinced me of the speed issue was to open Profiler and watch was is going on. Get the Manager to your desk run a query 100 times that...

On the whole every table should have a clustered index. You will want to use somewhat basic index design in deciding which fields to use for the clustered index. Here is...

The only issue I have with this approach is it makes one assumption. Each user in the organization has a network sign on. Where I currently work (today is my...

Well done. Very informative.

Ross

The first section of code does not have the commit transaction. The second one does.

Excellent article! My problem is I am the lone developer and DBA so if there is...

At work a coworker has these:

http://www.testout.com/

They seem pretty good. He noticed that items were not covered in the detail that tests go into sometimes, though.

Maybe a good starting...

Excellent article. If it is a group of people I really like the whiteboard approach for the very reason you stated it gets people involved. The more ideas you have...

I have to agree on this one the answer should be 8gb. From BOL

"To enable Windows 2000 Advanced Server or Windows 2000 Datacenter Server to support more than 4 GB...