Is replication failing? If so, even if you have log backups, that would cause the log to fill. Do you have log backups? That wasn't mentioned. In addition to reading...

Jeff Moden (2/18/2016)

---

No need to pile on (in fact, please don't) but the post below reminds me of the interviews that I've conducted over the last decade. The problem...

It's what Gail said. Those are local variables. They're not parameters. Local variables are not sniffed the way parameters are except in the case of a statement level recompile. The...

Try doing a refresh? Maybe you have an old version of SSMS (just because you patch the server, doesn't patch your client software)?

You should be able to see database objects.

I think Jo got it right at the start. If you're exporting and importing, as opposed to using backup and restore, then you're looking at differences in the statistics based...

Same as anything else, use the dynamic management views and system views. They're documented here at MSDN.

Those are probably the built-in sessions. System_health is running on all 2008 and better systems. If you have availability groups on the server, you'll also get a session for those....

SQL-DBA-01 (2/16/2016)

---

Thanks Gila.

Wanted to add that, DTA sometimes recommends to create custom stats based on the workload data. Even in many cases, DBA/Dev create custom stats for the query optimizer...

Hugo Kornelis (2/15/2016)

---

Grant Fritchey (2/15/2016)

---

Hugo Kornelis (2/15/2016)

---

jasona.work (2/15/2016)

---

So, a question for everyone:

How do you feel if someone comes back and tells you that they tested a solution you provided before...

Hugo Kornelis (2/15/2016)

---

jasona.work (2/15/2016)

---

So, a question for everyone:

How do you feel if someone comes back and tells you that they tested a solution you provided before they told their bosses...

jasona.work (2/15/2016)

---

So, a question for everyone:

How do you feel if someone comes back and tells you that they tested a solution you provided before they told their bosses it was...

We did have a piece of software that did that. It was discontinued.

However, you could try using SQL Compare [/url]and SQL Data Compare[/url]. They can be run against a backup...

Assuming that list is also your priority order, I'd change it.

First and foremost, get the backups set up. Most importantly here, establish, with the help of the business, what your...

jasona.work (2/11/2016)

---

Ed Wagner (2/11/2016)

---

jasona.work (2/11/2016)

---

No, that's one of my domain controllers.

It's an older box.

😎

(Now I want to...

Yes, there's not built-in file expiration. You can set the size of your files and limit the number of rollover files, but you can't have them automatically remove themselves. You...