That is because of...

Don't be scared to use aliases and add some white space to make your queries more legible. As posted your query resembles a wall of text and would be extremely...

Definitely an interesting question. Of course I would start with a clustered index so we aren't dealing with heaps. I realize the topic being discussed is different though. 😀

Steve Jones - SSC Editor (1/4/2017)

---

Testing and bug fixes for the forum upgrade is going well.

Right now we have a final test release set for Tues, Jan 10 and the...

Jeff Moden (12/31/2016)

---

Man, I hope they get the new system they're working on in place soon. The SPAM has been brutal and I know I'm not the only monitor...

wenger.noah (12/22/2016)

---

I think I understand your response. Using your table names for reference, the logic of your query expresses that we will not see all rows from t1; we...

wenger.noah (12/22/2016)

---

Hello,

I have a query:

SELECT "data" FROM t1... JOIN t2... JOIN t3... LEFT JOIN t4... JOIN t5... LEFT JOIN t6... JOIN t7(derived table)...

It is my understanding that when LEFT JOINing...

The documentation on this is appallingly awful. Nowhere does it actually state what the input limit is, it only mentions that it used to be limited to 8,000 characters. To...

Hi and welcome so SSC. For starters here is that query with some formatting so it is easier to read. You can add format boxes like this by using the...

Slight detour here. first I notice you name your procedure with the sp_ prefix. This is a bad idea. I would prefer no prefix at all but if you insist...

Pretty sure you want NULL and not the string 'NULL'. Not quite seeing what the issue is you are having here though. It is probably right in front me I...

Eric M Russell (12/20/2016)

---

Erland Sommarskog maintains an article describing various techniques and considerations for implementing this type of generic search procedure where the entities, predicates, and parameters are broadly defined....

Can you provide some sample data for us to use and what the desired output would be for that sample data? Just showing us the results of your query and...

Nice job posting ddl and sample data in addition to the code you have. 😀 You have several performance issues going on here. First is the scalar function, they are...

Luis Cazares (12/15/2016)

---

Sean Lange (12/15/2016)

---

george.p (12/15/2016)

---

Sean Lange (12/15/2016)

---

george.p (12/15/2016)

---

I missed the title so I assumed it meant Scalar functions 🙁

You're one of those people that puts all of the details...