Viewing 15 posts - 226 through 240 (of 471 total)
Stuart Davies (6/29/2011)
Until my QOTD gets posted, answered and questions raised about it - I'll keep quiet
... that is a good plan.
June 29, 2011 at 10:04 am
Carlton Leach (6/28/2011)
Have you been drinking Steve? :hehe:
Carlton, I think I will reuse your post, thanks.
June 28, 2011 at 8:16 am
Yes, a good question that made me think too hard for a Monday. Thanks!
June 27, 2011 at 8:43 am
Interesting question. I did not know you could do this, thanks.
June 16, 2011 at 8:00 am
Iulian -207023 (6/15/2011)
Nice question thank you.Besides the explanation on the msdn link referring to SQL 2000: http://msdn.microsoft.com/en-us/library/aa173918%28v=sql.80%29.aspx
there is also one msn article referring to SQL 2008 R2: http://msdn.microsoft.com/en-us/library/ms174203.aspx
Regards,
Iulian
Yes,...
June 15, 2011 at 8:11 am
With your memory settings/differences, the first thing I would check is your ErrorLog to make sure that your working set memory is not being paged out.
June 10, 2011 at 8:48 am
I suspect that what happens with a Select Count(*) is that it causes the table’s rowcount metadata to be updated by the SQL engine. The second time you run...
June 6, 2011 at 1:27 pm
Have you tried doing this: truncate the table, drop both the clustered index and non-clustered index, load the table then recreate the clustered index first and then the non-clustered index?...
June 2, 2011 at 12:57 pm
Difficult question. Thanks everyone for the explanations.
May 25, 2011 at 8:07 am
Now if the answer was "No, unless 8.3 naming is enabled in NTFS" you might have gotten me to bite.
Nice question.
May 20, 2011 at 8:19 am
Luke C (4/29/2011)
I purchased this book a couple of months ago. It has several useful techniques that could go along with this topic. Refactoring Databases: Evolutionary Database Design
Thanks...
April 29, 2011 at 10:15 am
Viewing 15 posts - 226 through 240 (of 471 total)