The only way to reduce the logging is to do a bulk insert/bcp and having the bulk logged recovery option set.

I now it is not handy but this is the...

I've heard about a company offering something like that:

http://www.polyserve.com/windows/sql_overview.html

I don't know if it's worth to consider it, at least it looks nice on the marketing paper.

If somebody has...

We have used the HIS to access our OS390 based DB2 database.

This was the only possibility we've found.

It's working fine, but only with DB2 as HIS (formal SNA Server)...

The first thing to check in this case is the VB config.

Check if you have the same issue when you execute your proc within QA.

Also check the response (and execution...

Are you trying to mail out of a table using the @query parameter?

Could you post your xp_sendmail command line and also the the size of the table(s) you are selecting...

Or you just generate the creation script of your database.

Then drop the DB and recreate it by applying the creation script.

This is the cleanest (and also the fastest) way to...

No Yogiberr.

It is not an older stíle, it is just and another syntax.

If you check the BOL you can see that EITHER you assign values OR you assign select results...

you cannot see the memory and the cpu usage per database.

it's only per server (or per instance)

check the master..sysperfinfo table to see if there is something useful for you.

Or there...

I've experienced as well SOMETIMES (and this is the problem, that it's not always) a paralell running query is slower the a query running on a single processor (ie. using...

It seems to be be quite complicated how you are storing your data.

Never the less here are some ideas which could help you to speed up a bit your query?

1:)

...

I don't know if this is exactly what you need but here is s guess:

select cast((select cast(count*) as float) from table1 where YourCondition1) /

...

The fillfactor is only taken into account when the index is created or recreated. After it is not maintained.

If you are shure you will never upgrade or change the the...

The DBREINDEX is in fact a DROP INDEX followed by a CREATE INDEX.

The INDEXDEFRAG is unable to optimize the indexes spanning over several files. In fact it is defregmenting one...

Ahsen,

You SHOULD use the clustered indexes.

Each table should have a clustered index.

without a clustered index (among others) you cannot defragment your tables which hurts the performance, especially where large ranges...

If you really want to partition your table consider the following:

• Do you have an indexed column where the data is more or less evently distributed (like a datatime column....