I have no idea.  And since SPIDs and object_IDs can vary per database, I'm not sure you'll be able to get an answer for that.

But running profiler during the deadlock...

I think the author's point was that maintenance used to be simple.  Then Microsoft re-wrote the whole thing and made it ten times more difficult in an effort to improve...

Personally, I think the cost of being civil to your contractor / perspective employer after an interview is far, far less than the cost of not getting the job /...

Bob - ROTFLOL.

Steve, here's a non-economic misson critical server for you.  The little boxes they use in every tower at every national airport.  It's not about money when you lose...

Actually, I just discovered that if you run the DBCC command with NoReseed after the original ReSeed command (if there are values in the table), it will reset on the...

Opps.  I guess I didn't make myself clear.

What I meant to say was that each source can have it's different column count (use the max # of columns you think...

Dinesh,

What you need is a separate data source for each individual sheet.  If the max # is fixed, then you're fine.  Just create a source for each possible one and...

Actually, in my original post, I did provide a better way to do it.  And if a variable doesn't work for you, there's always a WHILE LOOP or a UNION...

RSI?  Haven't heard that acronym before. 

I hate to say it, but I can see why companies are so resistant to buying ergonomic furniture.  First, it's more expensive than the...

@Thwap!  @=)

My predecessor was 6 feet plus some inches tall.  The desk and chair were sized for him and I couldn't wrestle the desk loose and reset it by myself. ...

Virani,

Rather than opening up a backup window from right-clicking the database and choosing "Backup", you should either use the Database maintenance Plan to create and schedule automatic backups or create...

Actually, your code is just sample code.  It doesn't include a description of what you're doing with the code.  And there is no real life example included with it, which...

<GROAN!>  Steve, you're killing us!

@=)

Other perks, ability to work from home while waiting for the Maytag repair man / cable guy / etc.

Oh, absolutely.  And you might want to check the properties of the log too, to make sure that it isn't set to unlimited growth.  An out of control Translog can...

Without testing, I honestly couldn't answer you on that.  And truly, I don't think there is a ratio of database to transaction log out there that is a standard. 

Transaction...