george 86905 (5/9/2012)

---

First of all, I love this site, and therefore, by extension, I love Steve Jones, I suppose. You guys have saved me many hours of deadends and the...

Adrian Sims-154382 (5/9/2012)

---

Yesterday I was 'handed' 2 Amazon SQL servers that was set up by someone else ( not a DBA ) , and I hope you have a very...

Markus (5/9/2012)

---

Do you control the backups/restores? Is SQL Server patched automatically if a service pack or security patch comes out? If so, and it causes issues with your...

sku370870 (5/9/2012)

---

You've spend hundreds of hours developing. A lot of your business logic is in your stored procedures and functions. You can't afford SQL Server hosting of your own. You...

mhotek-836094 (5/8/2012)

---

Um...the big deal is....what? I connect remotely to every production SQL Server instance that I've worked with for over 2 decades. I rarely have to manage the...

IceDread (5/9/2012)

---

Steve, you don't get sponsored by companies for posting this or do you?

I do not mean to question your integrity but you seam so positive about it. However that...

Thanks, everyone. She struggled a bit to get going yesterday in the rain, but today she's having fun working in the barn.

Not sure. I thought the deallocations of the blob pages might be stored in the log, but I can't find a definitive reference. How large is the LDF. Could there...

I assume most of you saw it, but for those that didn't, my wife quit her job[/url].

I haven't tried it, but I don't see a restriction on versions. The docs mention any compatibility mode.

The issue with doing this continuously is that if you fail over, you...

Sorry, didn't realize this was SQL 2000. (Doh!)

Query Analyzer has a menu item for this. You select it before you run the query.

Don't be sure your schema and data are...

In sync, are you sure? Have you actually done a sync recently or a restore? It's easy to assume this and be wrong.

To get the execution plan, you can easily...

Let us know what you find, and if you have specific questions, post back.

One thing I'd caution is not to assume anything here, especially with security. Use SETUSER and actually...

Nadrek (5/7/2012)

---

I assume that's at most...

Nadrek (5/7/2012)

---

Seriously: how many people are going to ask for, much less get, a wipe absolutely as soon as they realize the phone's missing? Instead of turning around...