Both the test server and the production server is on the same version? Check if you can set the query timeout to some higher value.

BTW, looking forward to next...

Having everything going through the same IO controller is not the best way to go into it. If you could, you should try to give different IO path for Data,...

Cant we please leave the pants alone?

The Thread is not going to like all the pants.

The only method that comes to my mind is a Server side trace that watches for the objectID. But that can also be manipulated by a SysAdmin.

The only way I know of to get the Audit information into DB is to import it manually into a DB.

Dealing with a third party is a tricky business. They might have a clause stating that if you do any change on the DB, they will not support the product....

Merge I do not think will work with LinkedServer. Thats what I know

You could always try using the Upsert method. That is Update first and check if @@rowcount is zero. If it is 0 then do the insert. This will help if...

It wont throw any error on any log if it is in any pending state. The advice provided by MSDN is to make sure that the Distribution agent and log...

Jeff Moden (10/18/2011)

---

bitbucket-25253 (10/17/2011)

---

Jeff for a guy who is 2 days older than dirt, from a guy who is 3 days older than dirt

Thanks for all you have done to...

Take a look at SQLStress. That can do quite a bit of stuff.

SQLIOSim from Microsoft is also good as Geoff mentioned.

Jack Corbett (10/17/2011)

---

SQLRNNR (10/17/2011)

---

Evil Kraig F (10/17/2011)

---

Thanks for the link to that Gail, everyone in the office was wondering if I was dying slowly as I'm trying not to laugh...

Back to work after the summit. It was a pleasure to meet everyone there. I had a blast. Once again Jeff, Johan and me did some sight seeing together on...

I am at the Presentation of Steve jones for the sql pass. MS supported event and guess what laptop Steve is using? An Apple.. 😀

Redgate is sending a DBA to space. And somebody just tweeted asking if it was Grant "The Mon***" who was going to space. 🙂