Viewing 15 posts - 3,181 through 3,195 (of 3,348 total)
Jeff Moden (5/8/2008)
May 8, 2008 at 2:09 am
Jeff Moden (5/8/2008)
May 8, 2008 at 2:04 am
Eric Wilson (5/8/2008)
May 8, 2008 at 1:54 am
Jeff Moden (5/7/2008)
I really had some hesitation in writing the article because I thought some of the "old dogs" would get after me for writing about something they already knew.
Hi...
May 8, 2008 at 1:46 am
Jeff Moden (5/7/2008)
[font="Courier New"]WHILE....[/font]... and that blows me away. :hehe:
They also used a WHILE loop to create some of their test data...
Hi Jeff,
Though I understand the sentiment from a...
May 8, 2008 at 1:32 am
buktseat (5/7/2008)
May 7, 2008 at 9:30 am
Shamshad Ali (5/7/2008)
May 7, 2008 at 2:54 am
Shamshad Ali (5/7/2008)
My quewtion is related to replacing loop, I am very interested on this. coz i really want to improve performance and I can't find a way to...
May 7, 2008 at 1:44 am
john.arnott (4/10/2008)
Can someone who knows tell me why Datepart() would be preferrable? I like the distinct functions for readability.
Hi John,
YEAR(...) is synonym for DATEPART(year, ...); similar for DAY and...
April 11, 2008 at 1:14 am
imrandn (4/10/2008)
I was confussed with Index key for indexes as your index key also take space in the row and effects of total size of the row (I think...
April 11, 2008 at 1:08 am
Hi all,
Supporting frmo eval to any other edition is supported: http://msdn2.microsoft.com/en-us/library/ms143393.aspx
However, it only works BEFORE the evaluation period expires. After that, you'll have to uninstall the eval edition before instaling...
April 10, 2008 at 2:45 am
Daniel Schmitz (4/10/2008)
Try this in Management Studio:(snip)
8309 - 8000 (cColWith8000Bytes) = 309
Hi Daniel,
That is the data length, not the amount of bytes actually used to store the data.
April 10, 2008 at 2:14 am
imrandn (4/9/2008)
Thats make sence but what about the Primery Key constrain?
Hi imrandn,
That will cause the table's data pages to be organized as a B-tree, with the PK value used in...
April 10, 2008 at 2:13 am
Dr. Diana Dee (4/9/2008)
Hugo is almost correct.
Hi Diana,
That is true. But not for the reason you mention. My mistake was forgetting the two bytes to store the number of variable...
April 10, 2008 at 2:09 am
Stephanie Giovannini (4/9/2008)
April 9, 2008 at 9:55 am
Viewing 15 posts - 3,181 through 3,195 (of 3,348 total)