Viewing 15 posts - 4,501 through 4,515 (of 8,416 total)
Tom.Thomson (3/31/2010)[hrOK, fair enough - but actually this time I was teasing Peter about his comment that you dislike T-SQL, not getting at Ron.
Oh right, cool!
April 1, 2010 at 3:15 am
Hugo Kornelis (4/1/2010)
No, that won't happen. This is because of how a heap scan treats forwarding pointers.
D'oh! Of course, of course, of course ...thanks!
Yes, we can. Didn't I already...
April 1, 2010 at 3:11 am
Hugo Kornelis (3/31/2010)
...I submitted a bug report... a case I constructed, based on this discussion, where COALESCE(..., 1) may erroneously return NULL (which should of course never happen).
Voted, repro'd, and...
April 1, 2010 at 3:06 am
Hugo Kornelis (3/31/2010)
I'm sorry that I keep arguing, but I just can't let this rest...
Hey, no worries...I do not see this as arguing - it is a fascinating debate! ...
April 1, 2010 at 2:09 am
Another thing I should mention: the current clustered index is not a great choice for the clustered index.
The key is not outrageously wide (at 15 bytes), but inserts are likely...
April 1, 2010 at 12:43 am
Thanks for the index definitions - though in this case, they did not help. Never mind.
If your query plan shows a single seek instead of two, it is likely...
April 1, 2010 at 12:31 am
CirquedeSQLeil (3/31/2010)
Adam Machanic summarizes his testing here.
In the comments, Adam notes that there seems to be no difference in SQL Server 2008...
March 31, 2010 at 1:17 pm
Lynn Pettis (3/31/2010)
Or Certifiable
Humph! :laugh:
<--------
March 31, 2010 at 1:05 pm
pankaj.baluni (3/31/2010)
Hi,can you please put your reply question by question saying this needs to be scripted and this needs to be reconfigured...etc.. thanks...
Heh. I have to admire your cheek....
March 31, 2010 at 1:03 pm
Lynn Pettis (3/31/2010)
March 31, 2010 at 1:01 pm
Hey Lynn,
My average has improved to 98.67 posts per day.
Night all 🙂
March 31, 2010 at 12:58 pm
Lynn Pettis (3/31/2010)
March 31, 2010 at 12:56 pm
Lynn Pettis (3/31/2010)
Okay, I understand that, but why couldn't encryption/compression work together during the backup/restore process, and that is what my little diagram above was depicting.
They can! Just use...
March 31, 2010 at 12:47 pm
Hugo Kornelis (3/31/2010)
I've got to correct you AND myself now.
Did you read the comments in Alex's blog entry (including mine) or the previous article?
My point there, as here, is that...
March 31, 2010 at 12:39 pm
Lynn Pettis (3/31/2010)
March 31, 2010 at 12:28 pm
Viewing 15 posts - 4,501 through 4,515 (of 8,416 total)