This is a case where using a cursor makes sense. I load a cursor and then build my backup statements with dynamic sql. That way you can specify location, file...

Yeah, NDA's are easy. It's Non-Compete's that I worry about.

It's a legal compliance within what should be your standards anyway... sign it. No big deal.

You just have to be careful about language. I had a company that wanted me...

Yes, it's absolutely possible that you're seeing contention. That much contention though would be a bit concerning. What is running on the systems that could block a shared lock for...

With just straight TSQL you'll have to backup the databases serially. That's how most everyone I know does it. That's how I do it. It is possible to backup in...

In general, I'd recommend against using dynamic SQL. That said, there are some very good situations where you should use it because it solves problems like dynamic search or other...

Depending on the situation, I believe that table locks could perform better, whether or not you should use them is a second discussion.

But in general, your beliefs about how SQL...

sudhakara (6/14/2010)

Thanks for your reply.

Searched on the book but i could not find any chapter related to the data...

I think that you ought to try letting SQL Server manage the locks for you rather than trying to control it using lock hints.

Without more details on what was being...

It's the identifier for a connection. There is no relation to the connection string or to any machine connecting to the server, except for the duration of the connection. You're...

I'll make a point of it, it'll be the first purchase.

Yep, Event Viewer through the Management interface.

2nd vote for SQL Server Internals. Excellent book.

A secondary choice would be Christian Bolton, et al, SQL SErver 2008 Internals and Troubleshooting. It's not as thorough as Kalen's book regarding...

In most places you'll need to bracket key words to use them within structures like that. Can you do it? Yes. Should you do it? I'd say no, but at...

And on top of what Paul says, are there other transactions occurring at the same time? This will further add to the overall size of the log during this operation.