Hi

DId you post this before?? swear i have read it..

Anyhow, server 2 (log shipped db) will always be in standby mode, this is read only and the triggers will never...

Hi there

100k rows is nothing, I indexed my 4 mill row table without too much trouble, mind you indexes do take a while to build and there are some support...

Hi there

Lets see, multiple database servers all working simultaneously on the same database files, now thats my idea of scaling out. SQL Server has no offerings down this space...

Hi there

A good idea, any search on google will return hundreds of documents to assist you. Also include searches on other DBMS technologies as the rules dont change too...

Hi there

This is a tricky one indeed, I would try profiling the db and see if you can trace out the steps being taken, also, did you notice any correlation...

Hi there

To be honest, federated DB's are a complete waste of time and is such a crazy hair brained scheme I wouldnt touch it with a 20ft pole for my...

Hi there Kumar

Great article mate and very informative.

Cheers

Ck

Chris Kempster

http://www.chriskempster.com

Author of "SQL Server 2k for the Oracle DBA"

Hi there

Did you check for any table statistic differences? and the age of them? also, how are you testing? if using query-analyser I gather all is identicle in approach....

Hi

Please search this site first or try google groups, there are lots of posting re this

Cheers

Ck

Chris Kempster

http://www.chriskempster.com

Author of "SQL Server 2k for the Oracle DBA"

Hi there

This is a tricky one, do you run long transactions? or numerous extensions to data files? here is a small example, this code increases my tempdb from 50Mb to...

Hi there

Well is a good point actually and (i suppose) really depends on your requirement for the standby DB.

In our case I wanted to avoid having 3 databases,...

Hi all

Just a quick comment re the log shipping, we have been testing our large COM+ app against the log shipped db, after a restore of logs, the COM+ components...

Excellent 🙂 couldnt be better.. thanks guys.

Cheers

Ck

Chris Kempster

http://www.chriskempster.com

Author of "SQL Server 2k for the Oracle DBA"

Hi there

Are you rebuilding all the time?? are you doing incrementals?? (timestamp col on table?). The build is slow, CPU intensive and I havent found a method to speed...

Hi there

I think you will be supprised at the speed benefits from fulltext, the figures differ of course based on your current search patterns and indexes in place. If...