September 22, 2011 at 8:37 pm
Comments posted to this topic are about the item Statistics - 2
September 22, 2011 at 10:02 pm
Thanks for the question Ron.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 22, 2011 at 10:26 pm
This time I tried logically and thought that after Truncate command the distribution statistics must be deleted. But I got wrong. Anyways learnt something from this.
But still I think you should have added the versions of SQL Servers as In SQL 7.0 it's not a True case.
Regards,
Sudhir
September 22, 2011 at 10:40 pm
Sudhir Dwivedi (9/22/2011)
But still I think you should have added the versions of SQL Servers as In SQL 7.0 it's not a True case.
Maybe so, but given that SQL 7 is many years out of support and that you can't download it from MSDN - it would be a stretch for the question to be based on it.
It is one of those cases where it is safe to bet that the question is about the current release or within the past 2 releases.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 22, 2011 at 10:49 pm
Jason:
It is one of those cases where it is safe to bet that the question is about the current release or within the past 2 releases.
Yes, I do agree with you... But You know, I answered based on guess. But it's ok. I learnt something from here.
Thanks Ron and Thanks Jason.
September 22, 2011 at 10:58 pm
Sudhir Dwivedi (9/22/2011)
Jason:
It is one of those cases where it is safe to bet that the question is about the current release or within the past 2 releases.
Yes, I do agree with you... But You know, I answered based on guess. But it's ok. I learnt something from here.
Thanks Ron and Thanks Jason.
And that is one key component of the QOTD. It's good to see people learning from them.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 23, 2011 at 4:46 am
Good question again Ron - thanks
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
September 23, 2011 at 5:52 am
very good question, thanks!!!
September 23, 2011 at 6:13 am
This was removed by the editor as SPAM
September 23, 2011 at 8:56 am
Good question. I got it right for the wrong reason, but I learned something so that's OK.
http://brittcluff.blogspot.com/
September 23, 2011 at 10:10 am
good question.
September 23, 2011 at 10:52 am
It took me almost 15 minutes to figure this one out... and I learned something. Much thanks!
September 23, 2011 at 4:29 pm
Thanks for the question!
---------------------------------------------------------------------
Use Full Links:
KB Article from Microsoft on how to ask a question on a Forum
September 23, 2011 at 7:37 pm
Amazing question. Thank you.
Now I must confess that I got it right completely by luck but with a trail of thought that TRUNCATE TABLE is minimally logged and doesn't affect individual rows.
Is that what the article from Kimberly Tripp explained?
Best regards,
Best regards,
Andre Guerreiro Neto
Database Analyst
http://www.softplan.com.br
MCITPx1/MCTSx2/MCSE/MCSA
September 26, 2011 at 2:12 am
Good question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 15 posts - 1 through 15 (of 15 total)
You must be logged in to reply to this topic. Login to reply