External sync wait. 

What is the latency and bandwidth capability between A and B? The last time it worked was it set up EXACTLY like it is now? Did...

I'm not sure if there is a way to see how long a query was blocking other's (as opposed to being blocked, which is tracked), at least historically.

My go-to tool...

Eric M Russell (1/10/2017)

---

ScottPletcher (1/10/2017)

---

I specialize in tuning, particularly index tuning, and I tend strongly toward the larger, shared index rather than separate indexes. Be aware that if the...

1) I'm with Scott that one "larger" index with a number of INCLUDEd columns can be a win from a number of perspectives over a bunch of small ones. There...

1) Unless you have very little active data in that large database, 8GB on the server and 4GB for SQL Server is WAY too low.

2) checkdb can cause a...

GilaMonster (1/10/2017)

---

Rechana Rajan (1/10/2017)

---

My doubt is when we create a Non clustered index the clustering key is already a part of it and then why adding PK column as included...

mishrakanchan86 (1/9/2017)

---

Hi ALl

I have a view which looks something like below.

Select

* from T1 with(NoLock)

Inner Hash Join T2 With (NoLck) on T1.PID = T2.PID

Inner Hash Join...

halifaxdal (1/9/2017)

---

This is expected

2) Can you please capture the actual query plan and...

1) Spooling back 3M+ rows to a calling program (SSMS I suppose?) is going to be SLOW.

2) Can you please capture the actual query plan and post that up?

3) We...

Indianrock (1/5/2017)

---

I'm the guy waiting for development to figure out how to add option(recompile) to some of the ORM-generated queries 🙂 I have been creating...

1) Tune the hell out of your FTS subsystem.

2) See if OPTION (RECOMPILE) can improve things here - or dynamic SQL (guarding against SQL Injection, obviously).

3) Given that you are...

1) You missed telling us a critical piece of information: how long as the server been up? You provide aggregate information so if the server has been up for a...

Phil, why would you put a clustered index on the temp table?

DarthBurrito (1/5/2017)

---

I have the task to convert our company reports from query embedded reports to stored procedures.

Some of the reports require multi-select parameters. I'm currently using a function to functions...