Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Statistics - 2 Expand / Collapse
Author
Message
Posted Thursday, September 22, 2011 8:37 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 7:17 PM
Points: 5,332, Visits: 25,261
Comments posted to this topic are about the item Statistics - 2

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read

Before posting a performance problem please read
Post #1179831
Posted Thursday, September 22, 2011 10:02 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 4:14 PM
Points: 17,726, Visits: 15,590
Thanks for the question Ron.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1179847
Posted Thursday, September 22, 2011 10:26 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, August 28, 2013 7:06 AM
Points: 1,216, Visits: 308
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
Post #1179850
Posted Thursday, September 22, 2011 10:40 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 4:14 PM
Points: 17,726, Visits: 15,590
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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1179854
Posted Thursday, September 22, 2011 10:49 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, August 28, 2013 7:06 AM
Points: 1,216, Visits: 308
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.
Post #1179855
Posted Thursday, September 22, 2011 10:58 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 4:14 PM
Points: 17,726, Visits: 15,590
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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1179858
Posted Friday, September 23, 2011 4:46 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 9:09 AM
Points: 3,088, Visits: 3,329
Good question again Ron - thanks

-------------------------------
Posting Data Etiquette - Jeff Moden
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
Post #1179945
Posted Friday, September 23, 2011 5:52 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, September 24, 2014 6:27 AM
Points: 1,258, Visits: 13,555
very good question, thanks!!!


rfr.ferrari
DBA - SQL Server 2008
MCITP | MCTS

remember is live or suffer twice!
Post #1179982
Posted Friday, September 23, 2011 6:13 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 1:05 PM
Points: 3,984, Visits: 5,237
Thanks for the question, Ron
This is a very good point for those of us involved with optimising SQL Server db's


____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1179996
Posted Friday, September 23, 2011 8:56 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Sunday, April 27, 2014 7:45 PM
Points: 1,589, Visits: 253
Good question. I got it right for the wrong reason, but I learned something so that's OK.

http://brittcluff.blogspot.com/
Post #1180182
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse