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

As many as you want.

I know there might be a max stored procedure byte count (or batch size), but apart from that, as many as you want.

How many do...

I'd experiment with the counts. I've had systems run better with 1000 than 10,000, but it's varied. Test a little, maybe for few batches and get timings.

How are you compiling as a script? Perhaps there's something in the script that gets left out. For example, a GO might terminate a batch, and let the rest of...

Please tell me it isn't a friend at a government agency or other place where security should be taken a bit more seriously.

I think serious-ness departed this thread long ago.

A long, long time ago, in a post far, far away....

Just venting, just venting, my friends. A good way to relieve some stress.

A broken URL has no answers today 🙁

However here's one I got in email:

For the record, the main reason to remove SPs that are surplus to requirements is to ensure...

Cynical indeed, though advanced education in CS doesn't necessarily mean that you know how to do anything in production.

However, I agree that this person, while possibly having trouble understanding, is...

How are you viewing this? Some apps might limit it there. TEXT should bring back the full value unless you are CASTing it somehow.