Instead of changing it to single user mode, what about changing it to restricted user mode. Then only sa or dbo will be an issue and if you've set up...

For licensing details, go to Microsoft, always.

As to performance, in my experience, they're really about the same. There aren't any really insanely radical differences within the query engine between the...

Since that's all going to be part of a single transaction, you're very likely going to see all sorts of blocking, not just at the row level, but possibly at...

Powershell is a great tool for doing that. I think Kendal Van Dyke may have written a script that's available online. Just do a search for it.

If you're happy with the performance, there's nothing you need to do.

If a query is using a lot of resources, then it could impact, or be impacted by, other queries....

If you need to do something programmatic and you can't use SSIS, I'd suggest looking into PowerShell.

Full backups and log backups are completely decoupled. You shouldn't have to worry about that at all. What you do have to worry about is if you run differential backups....

SQL Server has a tool built into it called SQL Agent. It runs as a separate service. One of it's uses is to schedule things for SQL Server to do....

The key, the whole key, and nothing but the key, so help me Codd.

When you define a key, that's what you have to use.

Now, if the two columns that you're...

Interesting question. I did a couple of simple tests where I did a TOP, without an ORDER BY since you didn't say there was one. The estimated costs were roughly...

What should it be? A unique password for each server across the entire enterprise.

What is it usually? One 'sa' password across the entire enterprise.

What compromise I have I used? Disable...

Jack Corbett (9/11/2013)

---

jasona.work (9/11/2013)

---

I believe the answer to this next question is yes, but I'd like to be sure:

If I create an XE session on SQL2012 (for the...

Step into the light. Extended Events are better in...

If you have maintenance on the servers, that will show up when looking at the index usage stats.

I'm with Jack, set up extended events to track connections to the database....

The first two are pretty much the same and can probably be used interchangebly, depending on the actual complexity of the query involved. The last two are very different. COUNT...