Viewing 15 posts - 2,086 through 2,100 (of 3,669 total)
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
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...
January 7, 2009 at 12:22 pm
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...
January 5, 2009 at 10:58 am
I can think of a few occassions where my knowledge of a particular industry has helped me in a different position.
You can be a good DBA with no industry specific...
January 2, 2009 at 12:29 pm
Sounds like you want a 3 table design.
1. A "Tests" table holding your header information
2. A "Measuring Points" table holding that items that could be applied to each test.
3....
November 30, 2008 at 8:08 am
doobya (10/22/2008)
Some very nice techniques and ideas in the articleBut I have never rolled back a change to a production database in 10 years.
I rarely have to roll back a...
October 22, 2008 at 12:45 pm
The average annual salary in the UK is around 24K. Some of the bankers in the city get bonuses that mean Mr average would have to work for 100...
October 19, 2008 at 8:05 am
In my environment we have a whole raft of health check reports and alerts
Databases that will need to grow. We...
October 10, 2008 at 1:55 am
Viewing 15 posts - 2,086 through 2,100 (of 3,669 total)