I can assure you that SQL Server can handle this type of calculation. Please post an example so we can see what you are up against.

Kind regards,

Lee

Also check to see what you are trying to delete - if you put .BAK in the window, it won't delete. Needs 'BAK' only, assuming that your backup is using...

Might be a cool time to try something built in the SQL CLR to see if you can get any perf gains.

Agreed. You need to give specifics on where the data resides; help us understand the origination of the data, and then we can offer assistance in fetching from the source...

Your post is very confusing. First off, never, ever, bake your personal workstation into an enterprise system/solution. You'll be headed for disaster. Is there a way you can restate the...

How about horizontal partitioning, distributed partitioned views, federation servers? Recommend none of them necessarily, but if you must split apart...

Ben-gan had a great series on this in the last few SQLmags that maybe you should check out.

How can replication "mitigate" (...to become less harsh or hostile) your restores? You should probably pose your question in the form of a problem and then field answers that best...

There is a PERFMON counter "Device Throughput Bytes/sec" that you might be able to use to back into the restore time, but otherwise I haven't heard of anything.

Extremely tough question to answer for anyone no the board, but right off the bat one thing I know I'd do is split it up so I can run several...

So, any of these working for you? I said 100...but if not, you now have 97 left to receive. 😉

If you have forgotten it, you might have to simply reset it. One workaround (I haven't tried this) is to try and transfer the old one. In sp_helprevlogin, comment out...

It's probably a service pack. I remember both specifying the file type and the sp for ...maintenance plans for initial SQL 2005 release were terrible and didn't work at all....

xp_cmdshell for any version for a user is not recommended. I'd look to some other solution. Having said that, yeah, agree with Steve - more info please?

For next time just remember to double-click on the error in the results pane; most of the time it will get you into the "general vicinity" of the error. ...