GonnaCatchIT (3/23/2016)

---

Hi Team,

My SP is timing out , timeout is set to 30 seconds. SP has below query to fetch the youngest id

SELECT TOP(1) ID

FROM Table1 TB1...

-- These are estimated plans. Row-goal queries often display big differences between estimated and actual row counts - can you post the actual plans please?

-- the "good" plan shows an...

Alan.B (3/23/2016)

---

ChrisM@Work (3/23/2016)

---

How many of you contractors have been so taken with a gig that you've signed up as a permie? I just did. I never expected that.

The idea of...

Ed Wagner (3/23/2016)

---

ChrisM@Work (3/23/2016)

---

Eirikur Eiriksson (3/23/2016)

---

ChrisM@Work (3/23/2016)

---

How many of you contractors have been so taken with a gig that you've signed up as a permie? I just did. I never...

Eirikur Eiriksson (3/23/2016)

---

ChrisM@Work (3/23/2016)

---

How many of you contractors have been so taken with a gig that you've signed up as a permie? I just did. I never expected that.

The idea...

jasona.work (3/23/2016)

---

ChrisM@Work (3/23/2016)

---

How many of you contractors have been so taken with a gig that you've signed up as a permie? I just did. I never expected that.

The idea of...

How many of you contractors have been so taken with a gig that you've signed up as a permie? I just did. I never expected that.

The idea of presenting fills...

chandan_jha18 (3/22/2016)

---

Lowell\Chris- As per Lowell's advice I created smaller procedures and attaching the new plan. however, as Jeff pointed out those hash and merge join fat pipes appearing again. Not...

SELECT *

FROM @Data

WHERE (DateStart = @DateStart AND DateEnd = @DateEnd)

OR (DateStart >= @DateStart AND DateEnd <= @DateEnd)

Phil Parkin (3/22/2016)

---

Koen Verbeeck (3/22/2016)

---

Grant Fritchey (3/22/2016)

---

Koen Verbeeck (3/22/2016)

---

Grant Fritchey (3/22/2016)

---

Koen Verbeeck (3/22/2016)

---

In case you're wondering, I'm fine. I didn't have to be in Brussels today, so I avoided all...

BL0B_EATER (3/22/2016)

---

ChrisM@Work (3/22/2016)

---

Brandie Tarvin (3/22/2016)

---

BL0B_EATER (3/22/2016)

---

Does anyone else have an issue during submitting an article when you paste in some TSQL into the SQL snippet block and save it then...

Brandie Tarvin (3/22/2016)

---

BL0B_EATER (3/22/2016)

---

Does anyone else have an issue during submitting an article when you paste in some TSQL into the SQL snippet block and save it then go back...

In case a "squishy" fingers the...

moeessack123 (3/22/2016)

---

Hi All

I was tasked with writing a report for my director

The report would be goods received vs goods sold for the month from a specific supplier

The problem i'm...

Luis Cazares (3/18/2016)

---

OK, this is driving me nuts. I have a query that runs slowly once a day (2 minutes) and then runs fast every time (2-3 seconds).

It's a report...