Viewing 15 posts - 35,896 through 35,910 (of 49,558 total)
bob 54859 (11/12/2009)
November 12, 2009 at 8:36 am
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...
November 12, 2009 at 8:29 am
chk2009 (11/10/2009)
Can we take tail tlog backup even when db is offline/damaged/correpted
Providing the log is available, yes. If the log is damaged/missing then no. If it's just the mdf/ndf files...
November 12, 2009 at 8:08 am
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.
November 12, 2009 at 8:07 am
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?
November 12, 2009 at 7:44 am
SP_updatestats takes no locks. It always runs on the entire database. If you want to update just a table, use UPDATE STATISTICS
November 12, 2009 at 7:32 am
John Colby (11/12/2009)
I had been (up until reading this article) creating a clustered index that was also a cover index, i.e. the index had every single field.
The clustered index...
November 12, 2009 at 7:30 am
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...
November 12, 2009 at 5:29 am
Bhaskar Basak (11/12/2009)
The table has almost 10 mn records and for today only 100K has added so as per the default threshhold the behaviour...
November 12, 2009 at 5:24 am
INNOCENT GUMBO (11/12/2009)
November 12, 2009 at 3:32 am
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...
November 12, 2009 at 3:32 am
Sy-1148362 (11/12/2009)
SSC is an ocean and people may or may not look at my issue.
Yes, that's true, however forum etiquette (here and virtually everywhere else) is to pick the...
November 12, 2009 at 3:25 am
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
November 12, 2009 at 2:50 am
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...
November 12, 2009 at 2:41 am
Are you shrinking the DB? Maintenance plan or auto_shrink? That'll fragment anything.
November 12, 2009 at 2:33 am
Viewing 15 posts - 35,896 through 35,910 (of 49,558 total)