Some of the stored procs that my company uses to detect problems with application performance are actually the main cause of the performance problems.

The data management views are quite good...

ISO5218 has the following definitions for Gender

0 = Not Known

1 = Male

2 = Female

9 = Not applicable

If you have the freedom to choose the encoding then start with the ISO...

I work for a calculated risk taker who is VERY good at calcuating.

I think it depends on what the boss was before he was a boss.

I've found accountants uniformly awful...

Bert (2/13/2009)

---

David.Poole (2/12/2009)

---

I regard God as an external manifestation of the human desire to aspire to be better than we are.

As long as there is a worthwhile target that is...

As far as BI and global warning is concerned I would say that it tells us that there is a lot of money to be made out of climate change.

There...

I regard God as an external manifestation of the human desire to aspire to be better than we are.

As long as there is a worthwhile target that is within our...

I know someone who described an auditing system as a blame culture with proof.

I am fortunate to work within a very strong team who I trust implicitly. I know...

This time last year I wrote about how to share templates within a team of DBAs http://www.sqlservercentral.com/articles/System+Development+Life+Cycle/62933/

I use templates in conjuncton with the SQL Prompt and the combination of the...

A minute amount of time might be defined as ten minutes according to the...

I heard it from...

I work for a company that sources its data from many hundred different data providers and supplies it to many different data consumers.

We could be arrogant and say "Ignorant prole,...

I'm just wondering what situation exists where you have 1 billion records with a tiny proportion having a bit field set to 1 AND that field being important enough to...

I have my red-light questions that fire off warning bells for me.

Any DBA who does not know what a temporary table or table variable is.

Any DBA who can't see why...

Thanks a bunch. I'll start saving for a mid-life crisis. Oh hang on, interest rates have gone to...

I wasn't sure about the benefits of MOVE TO until I did a drop constraint and then inspected the table.

The data had shifted onto the desired filegroup so I would...