My organization contractually divides DBA support into two initial groups: System DBAs and Application DBAs. The rough delineation is at the user database.

Setup, backups, maintenance, and logins are in the...

The data connections still point to the old server name and I haven't found an easy way to overcome this for maintenance plans.

If there is separation of duties where...

Where we often have issues is with AD accounts and the groups the service accounts belong in. They run under restrictive GPOs and we can't create accounts from the DBA...

Alfredo Giotti (4/26/2011)

---

There is heavy insert and update activity being performed against the temporary table, also with an active explicit transaction. however, the background process being blocked is causing the...

Poking around in BOL for schema locks:

Schema modification (Sch-M) locks are used when a table data definition language (DDL) operation (such as adding a column or dropping a table) is...

@Craig Farrell has given a plausible explanation.

What is the default dB for the app account? It may not have permissions in Master... maybe change its default to the...

To calculate the duration you may find this a little better than the method you are currently using:

CONVERT(CHAR(8), backup_finish_date - backup_start_date, 8) AS [Duration]

Not every one is capable of coding CLR modules and that's a lot of unnecessary...

Based on this article from the CSS SQL Server Engineers team I think you are on the wrong path.

Compact is not defragment. It goes back to the Paul Randall explanation...

Here we have 16 GB RAM and Memory\Available Mbytes is always 2200 MB (~14% of 16 GB). Ideally we should have 20 to 25 % (3.2 GB to 4 GB)...

You can set up a PerfMon log to populate a SQL table.

Type PerfMon at a command prompt and go into help. After that, if you need more info, Google/Bing on...

Bob,

What was the usage on tempdb and memory while running the various tests? That may have impacted performance.

When the optimizer picks an execution plan it doesn't necessarily take tempdb into...

Excellent.

Clear. Concise. To the point.

Great examples and presentation. All you needed to add was the infamous developer quote: "It worked faster in test."

Thanks for sharing!

I Enjoy your daily musings. This one, as do many, rung true.

The bureaucratic culture does not easily allow for a "let's all pull together" environment when so many of those...