I was reading this last night. It seems relevant.

http://waitbutwhy.com/2015/12/the-tail-end.html

What if the sql service on the server that's running the agent job stops? 😀

You should create a windows account, to use as a proxy, then on the job...

The error is pretty descriptive.

https://support.microsoft.com/en-us/kb/2443457%5B/url%5D

Here are some published results.

http://www.sqlskills.com/blogs/paul/benchmarking-do-multiple-data-files-make-a-difference/[/url]

http://www.sqlskills.com/blogs/paul/benchmarking-multiple-data-files-on-ssds-plus-the-latest-fusion-io-driver/[/url]

But, don't create a problem trying to solve one you may not have. Do you own benchmarks in your own environment and make...

There may be some performance advantages, there are plenty of blogs that talk about it, you may never notice a difference in your environment. There are too many variables...

What does your disk architecture look like?

What do the query load patterns look like for your server?

Would piecemeal recovery be beneficial to you?

Do you have your emergency...

You could do the same with using robocopy which gives nice readouts...

Depends on your environment. One easy way that works most places is Iperf.

https://github.com/esnet/iperf

Grant Fritchey (11/23/2015)

---

I'm pretty much with Gail. Just because it says it's using 98% of memory doesn't mean there's anything approaching a problem.

If you do know that the batch is...

How much data...

What interests you? It's extremely tough to master something you hate or have little interest in. I suggest going to a sql saturday, and at the very least...

Well, the thing about shrinking, even if it worked really well (which it doesn't), is that it will end up growing to the same size again. Only now you...

So on the autogrowth stuff.

You can check for events really easy through the gui. There are a million other ways to do this but this is pretty...

Compression is an excellent feature, but enterprise only.

If you:

don't have/can't get enterprise

can't change any code

can't add any storage

can't archive or delete old data

Your options are limited. ...

You know what the Onion is right?

-I was too late