I've seen this type of set up in two situations, both of which are attempts to maintain perormance during the working day.

1/ High IO disks

 - endevouring to improve performance by...

Hi Its 2.45 pm here, I get results from klh1 and nothing from klh2.  The trick is that each predicate must be true, therefore we can limit by time of...

Thanks Ben,

I've already used the sp_searchtext in anger.

Karl

It looks like this could help me but ... I don't have and can't find sp_SearchText.  Can someone post the difinition of it please

Regards

Karl

We're happy with SQL Server on Netapp.  It uses RAID, which I usually avoid with a DB but we're seeing good results.

Karl

I'm running a couple of ERPs, an EDMS (with up to 80 concurrent users on the busiest ERP and the EDMS) and a dozen or so other DBs on a...

The instances each have a seperate security environment - in all practical terms they are really no different from having three instances on three different boxes.  I have two instances...

In my opnion

1/ (almost) any situation where you find extensive use of NULLS to allow data to placed in a multi-column table is a clear sign that normalisation is...

Putting the square brackets around any object name (instance, database, owner and table/view/stred proc/etc) will always work in SQL Server.  This of course is why scripting out from Enterprise Mangler...

As an example of the issues being discussed here, my predecessor named a server SQL-Prod.  Most applications will run fine but a couple have failed as the '-' (minus symbol)...

Hi

Another point to consider is that the use of square bracket is MSSQL specific whereas the use of double quotes is quite standard.  I have an idea (but may not...

Hi

Great article - thanks.

Is there anything similar for a table?  When administering Oracle I would check both tables and indexes for fragmentation and want to do the same on SQL...