For the most part, when it comes to parallelism, your MAXDOP is not the issue. Instead, the issue is almost always around the Cost Threshold for Parallelism. The default value...

You need to capture the execution plan when the query is performing well and when the query is performing badly. Compare the two plans. There differences should indicate why you're...

craig-962225 (1/21/2016)

---

As this has been a problem since the beginning of time, one would have hoped MS would have come up with a solution to create a backup into a...

Lynn Pettis (1/20/2016)

---

Grant Fritchey (1/20/2016)

---

Sitting in a meeting at Redgate talking about plans for SQL Server Central. THE THREAD has come up as a topic. We are currently a 65mb...

Sitting in a meeting at Redgate talking about plans for SQL Server Central. THE THREAD has come up as a topic. We are currently a 65mb thread. It evidently looks...

COPY_ONLY will only affect differential backups, not log backups. Log backups can be associated with any full backup, even ones that have been taken using COPY_ONLY. It's only when you...

I am prejudiced, but Redgate SQL Backup is a great piece of software (I work for them).

You might also want to look at Minion Backup.

this is a complex topic and there are lots of ways to get it done. I have long been an advocate for using source control for the databases so that...

Jeff Moden (1/19/2016)

---

I've been outlawed from paint ball forever... I threatened to...

I sure don't know if this will work, but one idea might be to put the database into STANDBY. You can at least query it then to determine the LSN.

If...

Koen Verbeeck (1/19/2016)

---

Grant Fritchey (1/19/2016)

---

BL0B_EATER (1/19/2016)

---

Oh sorry forgot to mention they also asked me who Paul Randal is / what a MVP is? ( Only because I put down my...

BL0B_EATER (1/19/2016)

---

Oh sorry forgot to mention they also asked me who Paul Randal is / what a MVP is? ( Only because I put down my mentoring / training relationship...

But very welcome all the same!

If you can't find the version and type you need from here[/url], it doesn't exist.

I'd probably go with the extended events session. I'm at least sure you can capture the information there as opposed to the DMVs.