Viewing 15 posts - 2,026 through 2,040 (of 3,616 total)
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...
February 6, 2009 at 3:31 pm
Why do the Britts always say 'Ten minutes Time'? Are there any other kind of Minutes?"
A minute amount of time might be defined as ten minutes according to the...
January 28, 2009 at 11:56 am
GilaMonster (1/26/2009)
David.Poole (1/26/2009)
I've heard that if an index grows beyond a certain point SQL Server is unable to use it.May I ask where you heard that from?
I heard it from...
January 26, 2009 at 12:48 pm
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,...
January 26, 2009 at 12:42 pm
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...
January 23, 2009 at 12:34 pm
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...
January 22, 2009 at 1:32 pm
Heh.. dang, David... you might even be older than me! 😉
Thanks a bunch. I'll start saving for a mid-life crisis. Oh hang on, interest rates have gone to...
January 21, 2009 at 12:55 pm
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...
January 21, 2009 at 10:49 am
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...
January 20, 2009 at 12:28 pm
The temptation is to never revisit code that is working.
This is my big concern with agile development. "We will deal with it in the next itteration". ...
January 19, 2009 at 11:58 am
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...
January 18, 2009 at 10:37 am
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...
January 11, 2009 at 8:15 am
Steve Jones - Editor (1/8/2009)
How long did it take you to figure it out, David?
Some of it I didn't figure out, other bits I could remember who was likely...
January 9, 2009 at 2:42 pm
Viewing 15 posts - 2,026 through 2,040 (of 3,616 total)