bob 54859 (11/12/2009)

---

So, the dev in our shop that is against this claimed that when he did this a select query was 10x slower and SQL chose the wrong index....

Here you go. You can use this as a subquery for your aggregations or insert the results into another table.

SELECT tmp9999.*

FROM tmp9999 INNER JOIN

(SELECT MAX(PrimKey) AS MaxKey, ClientNumber, ClientAcctNumber

FROM...

Providing the log is available, yes. If the log is damaged/missing then no. If it's just the mdf/ndf files...

This looks like homework. Is it?

Give it a try yourself, if you get stuck, show us what you've done and where you're stuck and we can help.

I'm guessing that SQL restarted. That indicates that SQL is still recovering the DB. Check the error log, what does it say about that DB?

SP_updatestats takes no locks. It always runs on the entire database. If you want to update just a table, use UPDATE STATISTICS

The clustered index...

Please post the code used to create the DB and the exact error message that you get.

Either write the create DB statement yourself or use the 'script' button on the...

Bhaskar Basak (11/12/2009)

---

thanks a lot for the info.

The table has almost 10 mn records and for today only 100K has added so as per the default threshhold the behaviour...

INNOCENT GUMBO (11/12/2009)

---

I am not quite sure about many Clustered Indexes here. Since the concept tells us that they are part of the table and determine the Ordering of data,then...

Expected behaviour. Stats are only updated after a certain threshold of rows change. On larger tables that's 20%. If you find that you need to manually update stats then either...

Yes, that's true, however forum etiquette (here and virtually everywhere else) is to pick the...

Please don't cross post. It just wastes peoples time and fragments replies.

No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic817651-150-1.aspx

From books online:

cntr_value

Current value of the counter.

Note:

For per-second counters, this value is cumulative. The rate value must be calculated by sampling the value at discrete...

Are you shrinking the DB? Maintenance plan or auto_shrink? That'll fragment anything.