I'll move the delete statement and give it a try.

Yeah, I think the quirky update is probably my most efficient solution. Thanks everyone for your answers.

Thank you. I thought of using the "with cte " formula but I'm working with a dataset of over 700 million rows.

Right. I'm hoping to do it in the original select statement without building a temp table or reseting and inserting into a static report table.

If I use that, Lowell, then I only get the total for that row and not the cumulative aggregated total as the rows are retrieved.

Don

Still a work in progress so don't hate on me too much.

declare @Startdate datetime = '2011-01-16'

declare @EndDate datetime = '2011-01-19'

Declare @TotalUpdates int = 0

Declare @WebUpdates int = 0

Declare @TotalUpdateMsg int...

Thank you for the note!

I'll try to be more specific in the future!

Donalith

Nevermind, I figured it out.

Needed to use the IP address or the DNS string rather than the actual server name.

Donalith

*bump*

Does anyone have a SQL Server 2008 Management studio connection to an Amazon cloud database? If so, how did you do it?

It doesn't use any disk space? Is it faster or slower than a regular, disk-using, restore?

Ok, thanks everyone. It was an accidental conditional delete on some 26 rows on a relatively inactive table. It made more sense, I guess, to do a full restore to...

Absolutely. Always makes me curious though since we're often given lots of rope and different types of rope with which to hang ourselves.. lol

Thanks folks.

Don

What I'm actually doing is raising the limit to 500 and then using left() on my insert in T-SQL to have it function correctly. Having done that is what made...

Michael,

Does shrinking the database in small increments have a greater or lesser fragmentation effect on the indexes? Or does it really make no difference?

Don

Absolutely, which is why they hired me. They didn't have a dba when business built and implemented their database design.

Don