Viewing 15 posts - 3,016 through 3,030 (of 3,348 total)
Steve Jones - Editor (7/6/2009)
I shall look over the explanation and change it.
Hi Steve,
I see that you now have made a small change to the explanation, but I still do...
July 6, 2009 at 12:24 pm
Kelsey Thornton (7/6/2009)
good question.Why is it "always a better practice to be checking for equality in conditions rather than inequality"?
It's not.
The question is good, but the explanation is utter nonsense.
July 6, 2009 at 7:06 am
Tao Klerks (7/6/2009)
July 6, 2009 at 3:40 am
Hi Ed,
Your calculation is correct. And you'll find the exact same calculation in the topics on estimating the size of clustered indexes and heaps (except that in those, ALL columns...
July 2, 2009 at 5:33 am
Hi Ed,
I checked the BOL article you mention, but I failed to see any mention of varying length columns taking up more space. Maybe you can quote the relevant paragraph(s)?...
July 2, 2009 at 4:45 am
EdVassie (7/2/2009)
Another important thing to remember is that varchar uses more space in an index than does a char column.
This is not correct. Space usage of char and varchar in...
July 2, 2009 at 4:16 am
Some people are wondering why clustered indexes are treated different from non-clustered indexes and indexes on views.
Remember that nonclustered indexes on tables are redundant data. They can be reconstructed anytime...
June 24, 2009 at 1:31 am
Thanks for the kind words. It was a pleasure to help, and a fun challlenge to figure out! 🙂
I like the suggestion to make this into a QotD, and I'll...
June 18, 2009 at 6:38 am
AAARRGGHHH!! I did it again! Clicked "Post" after crafting a length reply without first copying it to a safe place, and got a site error. I *so* hate this interface!!
Here...
June 18, 2009 at 2:22 am
(censored)! I hate it when that happens. I spent a long time crafting a lengthy reply, then I get an error message when posting and I can't get my text...
June 17, 2009 at 4:20 pm
Paul White (6/17/2009)
It might pay those bemoaning the quality of the question to submit a better one...?😎
Heh heh! Good point, Paul!
Since I already did submit a few questions some time...
June 17, 2009 at 7:02 am
David Burrows (6/17/2009)
But those advocating nchar are also making an assumption :blink:Anyone using nchar on an assumption deserves Pork Chops thrown at them in my view :w00t:
Hi David,
If forced to...
June 17, 2009 at 6:03 am
Hi Ol'SureHand,
This is an intriguing problem indeed. And I can't say from just this description what the cause can be. So I ask you to follow some trouble-shooting steps.
First, in...
June 16, 2009 at 8:17 am
Ol'SureHand (6/16/2009)
Hugo Kornelis (6/16/2009)
Ol'SureHand (6/15/2009)
.. why varchar(35) seems to occupy more dataspace than char(35) when the actual data stored in both cases is only 6 bytes ...
If you post...
June 16, 2009 at 8:04 am
Ol'SureHand (6/15/2009)
Two things:- from your explanation, the min. storage space of a varchar is 2 bytes (not 3 as some seem to believe)
Minimum storage for any varchar, nvarchar or varbinary...
June 16, 2009 at 1:03 am
Viewing 15 posts - 3,016 through 3,030 (of 3,348 total)