That thread likely got deleted for some reason. We do that at times.

Wow, never played that long. We might have gone 8 or 10 hours some days, but definitely not all night.

Maybe I'm not as much of a geek as I thought...

Not only is thread going, I can't keep up.

D&D player here, long time ago, using paper and dice 🙂

No AARP yet, and I should have a couple years when...

SQL won't easily give you the totals at the bottom of columns. Your front end would do that.

It is important to test and be sure. You might have great techniques in your toolbox, but they won't always apply.

One of the weird things about SQL is your "rules"...

How big is the db?

A blanket, weekly schedule can work, but it can use more resources than needed. There are lots of scripts on this site that calculate fragmentation and...

That is indeed, scary

Thanks, grass....

That always gets me a chuckle. I think you might need a dual rotor chopper for that mission!

It can fragment, and you'd need to rebuild the clustered index to fix this. In EE you can do this online.

Or I do!!!!! :w00t:

Very interesting.

SQL does mark the physical records in a heap, AFAIK, with something to be sure they are unique. I have heard before that the optimizer likes clustered indexes, so...

this help?

http://msdn.microsoft.com/en-us/library/ms179316(SQL.90).aspx

http://msdn.microsoft.com/en-us/library/aa337560(SQL.90).aspx

Out of curiosity, where did that syntax come from (original post)? another platform or SQL version?

Not really. The backup runs as the service account, so it needs rights to get across the network.

Note that network backups are not recommended. If there's any network hiccup, the...

Answers changed, points awarded back.

Sorry