Jag,

Keep in mind, that the optimiser won't use any indexes on

1) Select * from Employee where EmpCode like '%P%

If you want the optimiser to choose any of your indexes...

I wouldn't recommend to set the compatibility mode to 7.0.

Sooner or later you (or your app vendor) have to migrate your app to the actual SQL Server version (2K, Yukon...)....

Hi,

We have SAP on SQLServer too.

I have to disagree with Antares (first time. I apologize) but our experiences in that size of database shows...

Menno,

Your solution will only work when you insert nwe records.

To be able to it with updates you have to implement a (befor) trigger on update if you want to upgrade...

The syntax of the whole query is wrong.

No join operators and no "AND" kaywords are allowed in the SELECT clause.

In addition there is no table in the FROM clause which...

I'm using xp_smtp_sendmail and it works fine for me.

Try this out http://sqldev.net/xp/xpsmtp.htm

AS BCP has not been evoluated for long time, I've experienced a much faster data load with custom written ODBC based C file then BCP.

So if you really want to...

• Do you have /3GB in your boot.ini enabled?
• What is your actual memory settings (max server memory, min server memory)?
• What is the memory requirement (target server memory, Total server memory counters)?
• What...

My problem to backup to disk is the size of our databases.

My biggest databases are over 300GB so if I would need to backup everything on disk before putting the...

Brandon,

Thanks for reply.

My concern with the DAS is that it's not usable for a cluster. Anyhow I have to use an external disk subsystem and attach my two nodes to...

This is a too generic question to be answered here.

Never the less here are some advices:

• Good database design
• good query design
• apropriate HW settingsin term of CPU, RAM, disk, network

Once everyting in...

stacenic,

By using an index on a computed column you will materialize that column and it wont be calculated on the fly.

So an additional 20 bytes will be stored within your...

Shawn,

Thanks for the links.

As an answer to your question: No I'm not using merge replication. In fact the host database is Oracle. So there will be (in fact it's already...

In this case get it pragmatically.

• Check if your statistics are up to date (update statistics)
• check the fragmentation status (dbcc showcontig, then dbcc dbreindex if neccessairy)
• issue a single query like
  
  select...

georged,

Be careful! Clustered Index Scan meens in fact table scan!

Try it out by removing the clustered index and creating a nonclustered on instead. You can see the difference.

Also check why...