Do they give the same query plan?

Very nicely done Drew!

The Guru's Tuning Big 3:

sp_whoisactive

differential file IO stall analysis

differential wait stats analysis

I note that sp_whoisactive can do a differential run itself with a parameter setting. One or more of those...

Stephanie Giovannini (10/5/2016)

---

Memory optimized tables are fairly new to me, and apparently to the third party who has written these procedures. While investigating this issue, I saw the retry logic...

The range-based nature of SERIALIAZABLE is likely getting you here, especially given that you have concurrent INSERT/DELETE/UPDATE activity. If those nonclustered indexes are RANGE based they could well be involved....

My sick and tired (literally, on both of those 🙁 ) brain is telling me that there is a very efficient single-pass solution here using SUM(CASE...). But sadly I don't...

use this to see how big and how full your tlog files are:

DBCC SQLPERF(LOGSPACE)

Shrinking a tlog file that is full of stuff is extra silly. It could be partially full due to a variety of reasons and artifacts about how logging and flushing...

And you, sir, would be one of those...

drew.allen (10/4/2016)

---

TheSQLGuru (10/3/2016)

---

This sure does seem a LOT simpler, and easier for a newbie (and this old brain too!) to understand:

SELECT t2.name, COUNT(*)

FROM dbo.#stat t1

--get the G...

Try a network monitor to capture packets and shred contents to look for text that is of interest.

I'm not quite sure what you mean about not being able to see...

watto84 (10/3/2016)

---

Problem solved on the large data set, i worked out I just needed to apply a clustered index to my table 🙂 Sorry.....Newbie 🙂

Thanks for your help though, easy...

szejiekoh (10/3/2016)

---

TheSQLGuru (10/3/2016)

---

szejiekoh (10/3/2016)

---

Hi all,

I understand that mirroring is no longer recommended but the setup exists in my current environment

I am trying to understand the portion on log truncation between...

This sure does seem a LOT simpler, and easier for a newbie (and this old brain too!) to understand:

SELECT t2.name, COUNT(*)

FROM dbo.#stat t1

--get the G events for...

szejiekoh (10/3/2016)

---

Hi all,

I understand that mirroring is no longer recommended but the setup exists in my current environment

I am trying to understand the portion on log truncation between alwayson availability...