Viewing 15 posts - 106 through 120 (of 335 total)
in management studio:
- right click on the database name
- select tasks->shrink->database
- mark the option "reorganize files before ...."
- click [ OK ]
Make sure you're doing this outside production hours in...
November 19, 2008 at 9:11 am
If you do a shrink with reorg (the only way to be sure unused space is released), your database will become fragmented. By rebuilding your indexes this fragmentation is (almost)...
November 19, 2008 at 8:44 am
Make sure there's enough memory available for the OS.
Make sure this is a dedicated server, remove all unnecessary programs/services which could eat your memory. Our memory problems were caused by...
November 19, 2008 at 4:56 am
You probably mentioned the "... a significant amout of memory has been paged out ..." errors you'll see in the errorlog.
The solution is simple:
1) make sure the Os has enough...
November 19, 2008 at 4:19 am
a. To check whether same DB link concept is available on MSSQL or not.
b. If yes, how much time it will take to copy tables across instances.
a: Yes the...
November 19, 2008 at 1:47 am
If these databases are critical, hire a consultant. Not getting personal, but it seems you're not really knowing what you're doing. You just can't do a database upgrade by reading...
November 18, 2008 at 4:35 am
Column_nameTypeComputedLengthPrecScaleNullableTrimTrailingBlanksFixedLenNullInSourceCollation
ITEMIDnvarcharno60 no(n/a)(n/a)Latin1_General_CI_AS
CostGroupIdnvarcharno20 no(n/a)(n/a)Latin1_General_CI_AS
LEVEL_intno410 0 no(n/a)(n/a)NULL
QTYnumericno1328 ...
November 13, 2008 at 1:42 am
Thanks for the replies. On t05 is a clustered index on (datareaid, itemid, recid), on T06 is a clustered index on (dataareaid,bomid,pricecalcid,level_,linenum,recid)
My version does a clustered index scan on t05...
November 12, 2008 at 5:57 am
Not exactly knowing what you're doing, here are the steps for adding a new connection to Management Studio:
1) start management studio
2) in frame "object explorer", click "connect"
3) select "database engine"
4)...
November 10, 2008 at 8:30 am
You can prioritize a SQL instance, by enabling the server setting "Priority Boost" (server properties->Processors), but this could lead to other problems (like network problems), because in some cases, SQL...
November 10, 2008 at 2:54 am
If this is possible, I assume your database needs to be in FULL RECOVERY (hey, it's a production database 😛 )
Interesting thought, has anybody experience with this?
November 7, 2008 at 2:29 am
Viewing 15 posts - 106 through 120 (of 335 total)