January 25, 2008 at 12:06 pm
In the exam book for 70-441, Designing Database Solutions, the author wrote the following:
(page 168, 1st paragraph) - Stored Proc parameters
For example, say you are considering whether to use the integer data type, which accepts values up to 32,000 characters long, or the tinyint data type, which accepts values up to 128 characters long. If you know that the parameter value should never be more than 128 characters long, select the tinyint data type.
My response is "WHAT THE HECK?". Tinyint only accepts values from 0 - 255. That's three characters long to me, not 128 characters. Or am I missing something?
Thoughts?
January 25, 2008 at 12:50 pm
I don't think you can call those statements anything except wrong.
January 25, 2008 at 1:18 pm
Cool, 128 character three place numbers. I use those all the time.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 25, 2008 at 1:30 pm
So the verdict is - remove all instances of "characters long"?
Reads a lot better when those are gone....
Edit: nevermind - it's friday afternoon. Coffee infusion seems to shed light that the statement is hopelessly mired in junk. I'd tend to second the "trash the whole statement"?
Scary - what the heck were they trying to say?
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
January 25, 2008 at 1:55 pm
Which book is that? Author?
I had a book for (I think 441) that was so packed with errors it was worse than useless. Can't remember the title right now. It's tossed at the back of the cupboard at work. Will check next week
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 25, 2008 at 3:32 pm
It's the Microsoft Self-Paced Training Kit for 70-441. I don't have it on me at the moment (it's at work), but the cover is blue and it has a light switch as the picture.
Is this the one you think is worthless? Please let me know if so. I'd hate to study off a bad book.
January 26, 2008 at 11:38 am
Don't think so. Will check next week.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply