dplaut 49149 (3/29/2016)

---

The comment prefacing the code is "This is a function..." Yes, we can see that it is a function.

Why should I use your function vs. some other method...

dplaut 49149 (3/29/2016)

---

When you post something like this please preface it with some text about why I should use this. If I don't know why then why should I bother...

Here's a simple model utilising an index to seek on Invalid, Status, UserID in that order. There's one predicate for each of the Status values, and no residual predicate -...

sql-lover (3/24/2016)

---

ChrisM@Work (3/24/2016)

---

Can you post the actual (not estimated) execution plan as a .sqlplan attachment please? It will answer a lot of questions.

Rule #1 when dealing with a deadlocking query...

Ed Wagner (3/24/2016)

---

ChrisM@Work (3/24/2016)

---

Alan.B (3/24/2016)

---

I was curious and looked at the thread.

ChrisM@home (10/22/2012)

---

yuvipoy (10/22/2012)

---

Ok, thanks. Can you give an example of how the data from this output table would...

Grant Fritchey (3/24/2016)

---

Steve Jones - SSC Editor (3/24/2016)

---

WayneS (3/24/2016)

---

Yes it does... even those that speak frequently. I know of a fellow threadizen...

sql-lover (3/24/2016)

---

ChrisM@Work (3/24/2016)

---

sql-lover (3/24/2016)

---

ChrisM@Work (3/24/2016)

---

Can you post the actual (not estimated) execution plan as a .sqlplan attachment please? It will answer a lot of questions.

Rule #1 when dealing with a...

Alan.B (3/24/2016)

---

I was curious and looked at the thread.

ChrisM@home (10/22/2012)

---

yuvipoy (10/22/2012)

---

ChrisM...

sql-lover (3/24/2016)

---

ChrisM@Work (3/24/2016)

---

Can you post the actual (not estimated) execution plan as a .sqlplan attachment please? It will answer a lot of questions.

Rule #1 when dealing with a deadlocking query...

Brandie Tarvin (3/24/2016)

---

ChrisM@Work (3/24/2016)

---

Sean Lange (3/24/2016)

---

--I posted in another thread by accident a couple of days ago--

Thank you Mr. Moden. Another interview cut short with the simple "Name one way...

Your requirement looks...

Sean Lange (3/24/2016)

---

--I posted in another thread by accident a couple of days ago--

Thank you Mr. Moden. Another interview cut short with the simple "Name one way to get the...

Can you post the actual (not estimated) execution plan as a .sqlplan attachment please? It will answer a lot of questions.

Rule #1 when dealing with a deadlocking query - reduce...

Beatrix Kiddo (3/24/2016)

---

ChrisM@Work (3/24/2016)

Google shows Slalom right next to Vinopolis, Borough Market and the Market Porter Bar. That's about 20 minutes walk from here (Picadilly). It's a fantastic little corner...

rodjkidd (3/24/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...