I guess if I am learning about a new database that I have been given to support and am searching like this in a development environment, I can see how...

I love that such a basic refresher can generate such good discussion.

I would like to see the same thing happen in a related area. The article could perhaps be called...

We built the same thing here but only for automated email alerts. We call it NagBot.

😉

Thanks, bitbucket (Ron). I guess I had assumed that they would be really good at all the standard management things (backups, watching logs and alerts, keeping the trains running) ...

I know when I worked with Oracle, a truncate would perform an implicit commit on any trancaction the truncate statement was riding on.

That may come as a BIG suprise when...

MAV query is a very useful techique. I am sure it is something I am doing wrong (or is there a database setting I am missing) but I only get...

I like the idea of using the OUTPUT clause but I have this bad feeling about the example. Perhaps there are requirements that justified doing things this way (insert all...

Thanks for the reply.

What we ended up doing was along the same lines as your suggestion. We could not use replication even on the one table (the problem I...

Simon's post about using the OUTPUT clause on the update becomes available for us to use in SQL 2005 databases. It is an awesome feature (Oracle has had it for...

I think ever since SP4 this message appears any time the captured sql is using a password-related system sp. It is a security feature (although hiding what is going on...

You said "heinous"

:hehe:

I am not an official DBA but a database developer that wears the DBA hat a lot in what I do. In my production support role, I needed help in...

Ouch. It was the "Developers' fault", eh. Damn corporate projects and their corporate developers that don't talk to the DBA's.

I find it amazing that anyone thinks this is amazing --even...

Maybe "The Art of Theoretical Performance Issue Handling" would be a good title. 😉

Data volume is not the only thing that can change over time (or from DEV environment to...

YIKES (not yelling).

Two pages so far on leading commas, UPPER or lower case, the horror and amateurishness of lower cased key words...at least I do not have French-flavored SQL (in...