I think I got the 3000th post. A celebration party was set up on my side of the world.... 🙂 Now this time I am giving the chance to someone...

If you hold the nose underwater, wont it get water into its lung ?

You really blew away that saying... It was a good saying not any more... lol

You cannot restore a single table from a Back up. Your option would be to

1. Restore your Back up into another Server and export data from that table to...

That is my point, You, Gail, Lynn,Steve and many others have been saying that this is not be done. These are the consequences. But the same person who gave the...

I was not talking about you at all Lynn.. 🙂 But I am talking about people who will give that solution as the first solution before anyone can even react,,...

I find it strange that every time there is a problem with Transaction log file size, everyone chips in with truncate of transaction log? These answers comes from people who...

I have answered them, but that never gets me anywhere near the top...:-)

Take a look at RIS (Remote installation Service) Maybe that will help.

I have seen these dead locks when we had a lousy server. At that time what we did was change the clean up job schedule. This reduced it drastically. Changing...

I have seen deadlock happening between the clean up job (distribution clean Up) and replication. That can be solved by using different schedule for the clean up job to run....

Lynn Pettis (5/27/2009)

If there is...

SAN, Killing the SPID or the process is just a temporary solution. This could happen again and again. The best would be to tackle the problem and find out the...

maybe the SP was using a different execution plan? Did you check the execution plan for the SP versus the Ad Hoc Query?

Since this is a reporting server, I do not think there would be much data updated. So the begin tran and commit tran would not be an issue. You said...

Gail, that was what my teacher used to do. Are you sure you have never been to India and taughtDB2?? 😀 Coz that teacher was the most smartest of all...