SQL Slayer

As we all know, and some of us hate, triggers are not the best thing for performance. Enter SQL 2005+ with the Output clause.

Here is the scenario. You have a table that is transactional. You only care about the most recent record for your system, but need to have historical data available for reporting and/or [...]

So this was an interesting one, never seen such a thing before.

I wrote a quick audit procedure to basically monitor connections to every instance in my environment by simply querying sysperfinfo. Well, for the most part the data is spot on. Except for two instances. The cntr_value in sysprocesses for counter_name = ‘user connections’ is [...]