Viewing 15 posts - 121 through 135 (of 213 total)
Excellent question, I learned something new.
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
November 18, 2010 at 1:57 am
I agree, the result is correct but the explanation is wrong. And this is a good example why you should never omit any default statements even it may be tempting...
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
October 4, 2010 at 2:08 am
Nice question, and as everyone else pointed out, the computed columns doesn't need to user more resources. Hugo gave an excellent example on how it could use less resources.
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
August 16, 2010 at 6:12 am
This was really a trick question! I assumed the constraint was correct and it was a bad assumption.
/Håkan Winther
SQL Service AB
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
June 14, 2010 at 7:48 am
My answer to the qustion was "the writer of the question", but i agree that the reader also have a responibility.
I think it was a Good question, and i thank...
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
March 21, 2010 at 9:57 am
Paul White (3/15/2010)
Normalize 'til it hurts...de-normalize* 'til it works!* appropriately
good point! 🙂
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
March 15, 2010 at 6:28 am
Remember that there is no such thing as a free lunch! There are always a cost for everything. Denormalization Will cost you disk, maintenance and sometimes the overhead of updating...
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
March 15, 2010 at 5:01 am
Thanks for your QotD! I answered too quick and didn't think of the difference between Len and DATALENGT().
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
March 15, 2010 at 3:46 am
Thanks for an excellent question.
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
February 17, 2010 at 1:12 am
Oleg Netchaev (2/5/2010)
JosephDMarsh (2/5/2010)
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
February 8, 2010 at 2:08 am
Hugo Kornelis (1/25/2010)
Not a good explanation, though.
"The constriaints prevent some inserts and deletes from occurring." - I did not run the code, but I am pretty sure that all...
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
January 25, 2010 at 2:41 am
Nice question! I learned something from it.
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
January 18, 2010 at 12:42 am
The important point with this question is that you should never take anything for granted and always specify "optional" paramters/statements
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
January 8, 2010 at 7:34 am
Thank you for a great qotd and explanation! Lesson learned.
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
January 7, 2010 at 8:51 am
I got the answer correct, but only because I guessed there was a catch somewhere. I really don't like implicit conversions, especially when I get unexpected results :angry:
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
December 14, 2009 at 7:24 am
Viewing 15 posts - 121 through 135 (of 213 total)