In this case, all you need to do is reindex the clustered index - this will force the nonclustered indexes to be reindexed, since they depend on that.

Just remember that using a function on a field in the left-hand side of an expression will mean that you can't utilize an index to do a seek....

ColdCoffee (8/3/2010)

ColdCoffee (8/3/2010)

WayneS (8/3/2010)

ColdCoffee (8/2/2010)

Also i remember a thread...

Matthew,

Realize that a function like this is going to be called for every record in the result set. It would probably be better to add a column to the output...

Do the multiple updates without the cursor.

I think you're close. You might want to consider this...

Create a small table of the month # and starting/ending dates:

IF OBJECT_ID('tempdb..#TestTable') IS NOT NULL DROP TABLE #TestTable;

CREATE TABLE #TestTable (MonthNbr...

bt, this looks promising. I don't really care about the speed - it's a one-off thing.

I just need to identify all the code with dynamic sql.

I'll try it out tomorrow,...

Well, since Steve asked for opinions on one topic, let me broach another topic.

What do you'll think about this[/url]? Is there a valid point? Are the people screaming about it...

Grant Fritchey (8/3/2010)

Ditto. We'll be out at a Scout...

Stefan Krzywicki (8/3/2010)

WayneS (8/3/2010)

There's a quote in this article that sums up my feelings:

"On the one hand, stopping...

There's a quote in this article that sums up my feelings:

"On the one hand, stopping a mosque from...

It's could be data loaded in from an excel spreadsheet. Tabs in excel need to be referenced with a trailing $.

Ian,

The SQL Logs show each time that SQL started - you could parse that. And assuming a normal shutdown, that also is recorded, so you could parse the logs for...

tom 29037 (8/2/2010)