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...

I understand the argument about not developing for 6 million products because getting a product to market, even with diminished functionality, will allow you to grab the high ground.

I disagree...

This is my big concern with agile development. "We will deal with it in the next itteration". ...

I've been playing with SSIS recently and have a love/hate relationship with it.

I've a feeling that some of the facilities do RBAR type operations rather than set based operations.

I know...

Have any of you guys heard of "information mapping"?

I believe it is a trademarked approach. I used to work for a company that produced tehnical manuals and was given...

Some of it I didn't figure out, other bits I could remember who was likely...

In the past 10 days I have been bitten by the "no documentation" ghoul.

If you have too much you can prune it, if you have too little then what do...

I am a fan of Innovasys DocumentX, although Red-Get SQL Documentor or APEX SQL Doc will do just as well.

What's hard about adding a summary, remarks, returns, parameter details and...