Viewing 15 posts - 5,491 through 5,505 (of 7,505 total)
- as you have read, you must take very good care when designing and creating partitions and indexes.
- be sure indexes are alligned !
- indeed, reorg. 1T rows isn't going...
November 5, 2007 at 12:23 am
- I'd suspect page splits (clustering index) and file autogrowth.
- work with transactions
- avoid the cursors, do a direct insert in stead !
- insert rows sorted according to the clustering...
November 4, 2007 at 7:17 am
did you check Kimberly's very good white paper on partitioning ?
http://msdn2.microsoft.com/en-us/library/ms345146.aspx
it contains very good sample scripts !:smooooth:
November 1, 2007 at 2:05 pm
Just my 2ct.
Split the table !
My guess is the must be more info appart from the relation that you can document in your relation table. e.g. startdate/enddate of the relation...
November 1, 2007 at 2:00 pm
if you are only selecting objects in the current database, you can use object_name(object_id) in your select list
November 1, 2007 at 1:51 pm
0) keep your head cool. Know what you do !
1) disable automatic backup jobs !
2) make a new incremental log backup !
3) if you have the place or another server,...
October 31, 2007 at 1:49 pm
- a (serverlevel) login trigger may server you very well
- a simple change of password may also do the trick if your applications support extrenalised credentials/passwords.
- and if I'm...
October 31, 2007 at 1:38 pm
-ACID (A Atomicity, a TXN is performed in its entirety or not at all) (C Consistency, a correct TXN takes the db from one consistant state to another) (I Isolation,...
October 31, 2007 at 1:34 pm
Indeed :ermm: I should have doublechecked (it) myself :blush:
back to the pile of perfmon/profiler files ...
October 31, 2007 at 8:40 am
have a look at the KB @ http://support.microsoft.com/kb/916287
Maybe the fix list rings a bell.
If you cannot find another reason why it slowed down, maybe it's worth to investigate .....
October 31, 2007 at 7:44 am
I don't know if it is the case, but some things to keep in mind with an in-place upgrade :
http://sqlblog.com/blogs/allen_white/archive/2007/10/08/pay-attention-to-cluster-setup.aspx
October 31, 2007 at 5:11 am
- Maybe I've overread ... but did you apply Cumulative HofFix for sp4(build 2187)-KB916287 ?
It might be that due to increase of load or data, engine issues arrise ....
October 31, 2007 at 3:21 am
- also keep in mind with an in-place upgrade, all your databases (including the system databases) are still at db_level 80 (sql2000) !
- If you want to use the new...
October 30, 2007 at 2:12 pm
it's the physical processors that count, not the number of cores.
So in your case 2 will be the number of processors to license if you want to enjoy your 4...
October 30, 2007 at 2:05 pm
post upgrade steps:
-rebuild all indexes !
-sp_updatestats;
-dbcc updateusage (0) with count_rows;
-dbcc freeproccache
And offcourse then make full backups !
October 30, 2007 at 2:04 pm
Viewing 15 posts - 5,491 through 5,505 (of 7,505 total)