I'm with Lowell. I'm only writing the query if I get the grade.

If you're stuck, try writing the query. Show us what you have tried that doesn't work. I'm sure...

If the log backup is not running (and that's how I read the explanation), then the committed transactions won't be removed from the log and it will continue to grow....

SSMS doesn't "open" anything as a database. SSMS is just the client that lets you look at what is on the SQL Server instance. It's the instance that manages and...

Piling on, don't use the Profiler GUI against production systems. It hurts performance.

If you do go to use extended events (also my advice on a 2012 forum), be sure you...

At a really low level, it's how the storage of the information is maintained. But I'm with Jeff, a better definition of what you're trying to understand, other than just...

It completely depends on what's...

Lynn Pettis (4/15/2016)

---

Sergiy (4/14/2016)

---

nhansen pcc (4/11/2016)

---

Both our internal SAN team, and the vendor have looked...

What the heck is this doing in the JOIN criteria:

0 = 1

and pbu.bu_id is not null

I gave up after that. I'm not paid enough.

Instead of NOLOCK on umpti-gazillion tables, why...

What about the row estimates between the servers. Are they the same? You're getting a different memory grant because the optimizer thinks it's moving different amounts of data (and in...

Brandie Tarvin (4/15/2016)

---

Grant Fritchey (4/15/2016)

---

Backups. What are they good for?[/url]

and, more recently:

How to recover from deleting everything, including the backups

I sincerely hope that this data is not vital to your...

Another vote for distributed replay. That's how I've done this sort of testing.

There are absolutely optimizer differences between 2008 & 2012. The cardinality estimator is not different. That's what those traceflags in 2014 are for. It's not applicable to 2012 where the...

It sounds like the process may be running still. It could be blocked by some other process. Have you checked blocking? Use sys.dm_exec_requests to see what processes are actively running,...

Add the index.

A lot of the recommendations for SharePoint databases are not correct. Do what you know is the right thing, deal with Microsoft support if you have to.

However,...

Backups. What are they good for?[/url]

and, more recently:

How to recover from deleting everything, including the backups

I sincerely hope that this data is not vital to your organization, because it's gone.