I will also self-promote, but only after I promote a couple of others.

There are three books that I really like that deal with being a DBA, not so much SQL...

I just left a company that did a number of migrations. We had very few issues. Most of the time the problem was in code that was deprecated. Be sure...

I see the trace is outputting to a table, is that right? If so, is it a table on the system that you're doing your testing on? That could be...

Expire date doesn't determine how many days are kept. That's a marker for old style tape backup systems.

How big is this database? Keeping 90 days worth of individual backups could...

It sounds like you have the issue isolated to a particular table. What queries are running against the table. I'd focus there. Most of the time, problems exist either in...

The company I used to work for did that annually. They would only take the backup process offline on a weekend, so all the prep was done and then testing...

I wold get rid of the ROWLOCK hints. By putting the hint in place, you're forcing the optimizer to use row locks on inserts when page locks or even table...

I agree. Don't argue with them (naming convention arguments are such a waste of time). But do ask to document the standard, just so you can better comply with...

If they can at least explain their naming convention, follow it. Have you done it in a way that is clear and at least reasonably accurate? Yes. But that doesn't...

Also, while it might appear to help performance, that NOLOCK hint is potentially problematic.

Brandie Tarvin (2/3/2011)

---

Grant Fritchey (2/3/2011)

---

It's just silly to obscure the language so badly when you're talking tech. All our little abbreviations & code words make it hard enough to understand...

I have to say, it's entertaining as hell. You guys should keep poking him/her (most likely him). I'm so glad that's the exception, not the rule, for youngsters posting in...

I've only used the iPad. But the Toshiba that's due out in the spring looks fantastic. It's a Droid and I'd go...

A query similar to this will show what you need:

SELECT deqp.query_plan

FROM sys.dm_exec_requests AS der

CROSS APPLY sys.dm_exec_query_plan(der.plan_handle) AS deqp

CROSS APPLY sys.dm_exec_sql_text(der.sql_handle) AS dest

WHERE ...

In the WHERE clause, not sure what you...

Something like this:

BEGIN TRANSACTION MyTran1

EXEC dbo.MyProcA

BEGIN TRY

BEGIN TRANSACTION MyTran2

EXEC dbo.MyProcB

COMMIT TRANSACTION MyTran2

END TRY

BEGIN CATCH

ROLLBACK...