Viewing 15 posts - 10,636 through 10,650 (of 49,566 total)
It's an allocation unit ID, not an object ID. Query sys.partitions.
December 16, 2013 at 3:00 pm
Sagar Akhare (12/16/2013)
Please check index fragmentation, if the fragmentation % is more than 60% need to rebuild the indexes.It will improve your performance.
Maybe, but probably not, and if it...
December 16, 2013 at 4:49 am
To be honest, the most accurate is to tune by hand, look at problematic queries, create indexes to support them. DTA's OK if you don't know how enough about indexes...
December 16, 2013 at 3:40 am
Maybe start by reading up on indexes
http://www.sqlservercentral.com/articles/Indexing/68439/
December 14, 2013 at 7:49 am
aaron.reese (12/11/2013)
Not sure what it will do to the cached execution plans though if the statistics for the different schemas are skewed 🙂
Different execution plans for different users, because...
December 14, 2013 at 6:09 am
Tens of millions of rows a day is low activity. If you were talking millions of rows a second, then I'd understand looking for specialised, non-relational solutions.
If you're having performance...
December 14, 2013 at 5:47 am
tmlink99 (12/13/2013)
Grant said to just rely on the integrity of the publication. Is that it?
Yes. What I said here is exactly what I would do if the situation ever...
December 14, 2013 at 3:04 am
The exams for the SQL 2008 exams are already unavailable. If you want a cert, it'll have to be 2012.
December 13, 2013 at 3:18 am
Not the cached plans and not a screenshot please.
To see if it's a stats problem, we need the actual execution plans with runtime info (capture using profiler or use SSMS...
December 13, 2013 at 3:14 am
This will probably fail, but try ALTER DATABASE ... SET EMERGENCY. If it works you can run a CheckDB in that state (not with repair)
But any checksum failure is an...
December 12, 2013 at 7:21 am
Only in the 'black box' sense.
December 12, 2013 at 6:59 am
If you're getting an error that a log record can't be redone, then that DB probably won't be coming online, except maybe in SUSPECT state. Try recovering the DB without...
December 12, 2013 at 6:58 am
Depends how big the blocks that the dedupe looks at, but yes, probably they will have changed. This is not a good reason to not rebuild indexes
December 12, 2013 at 5:19 am
Viewing 15 posts - 10,636 through 10,650 (of 49,566 total)