Nelson,

As Allen already told you, whenever possible you should avoid forcing the indexes.

Never the less to be able to help you for such kind of request you should give us...

For the queries just slowing down you have to check if your indexes need to be reindexed. Also check the statistics.

Is your database size growing?

How much free disk space, free...

It seems there is no connection between the Window menu and the drop down list in the object browes panel.

The only possibility I see actually is to change the query...

Just if you are rebuilding the clustered index.

Normally if you are rebuilding a "normal" heap index it doesn't touches the table itself.

All the pointer infos are stored within the...

pbb001,

There is just one thing I cannot understand.

You tell us :

quote:

---

The problem lies with the cheque_amount column but this column isn't...

Jeff,

No deadlock if you are in single user mode (as dbcc dbrepair and sp_fixindex oblige you to do anyway).

I hope in the Yukon version they will think about this.

Bye

Gabor

In addition to that all the identity columns will be reset.

If you have the rights to perform a truncate table as Brian wrote you should prefer using it instead of...

Is this happening only in EM or also in QA?

If it is only happening in Em check your path settings.

C:\Program Files\Microsoft SQL Server\MSSQL\Binn should be in you path.

And in addition everything depends on you application.

If you have a lot of range queries where the range is quite large the you will see a kind of performance degradation...

I like to leave 256 MB for the OS on a machine dedicated to SQL Server. Especially if you OS is W2K or W2K3.

Otherwise you could come to swapping.

Of course...

But to do what Ray suggested you must be sure you column is nullable. If not you have to make it nullable by using the ALTER TABLE command. See BOL

Bye

Gabor

...

Just a tought but if you are migrating from a another DBMS are you shure you have all the indexes correctly set. (Or better said: do you have indexes?)

Otherwise if...

pshotts,

I don't know for the utc date.

We have a third party helpdesk application which stores the dates as UTC dates.

Now I have to query the past data and I just...

Here are my 2 cents:

Or database ai more or less the same size as yours. We are running SAP on.

Those are the steps what I do when I have a...

Unfortunatly the function based aproach will be much slower because your query will have to call a function for each and every rows.

And the function itself makes a query to...