Not to mention the table scans this probably causes:

...

AND (u.FirstName LIKE '%' + 'asdf' + '%' OR

u.LastName...

Jacob Wilkins (5/7/2015)

---

@Lynn: Agreed, I would LOVE to dive into that option. Unfortunately the OP specified that they can't touch the third party app's SPs. Perhaps pushing back on that...

Or, rewrite the query looking at ways to eliminate the multiple nested sub-queries.

Looking at it, there has to be a way to rewrite the query so it is more optimal,...

I came up with this as a simple example of what you are trying to accomplish:

with Months as (select MonthAbbr, MonthNumber from (values ('JAN',1),('FEB',2),('MAR',3),('APR',4),('MAY',5),('JUN',6),('JUL',7),('AUG',8),('SEP',9),('OCT',10),('NOV',11),('DEC',12))dt(MonthAbbr, MonthNumber))

, TestData as (select TestDescription from...

I am...

Making the...

yusufm 48726 (5/7/2015)

---

where do you think I should post it? I posted in the newbie and they told me not to post it there. I check SQL Server 2012-T SQL...

New Born DBA (5/7/2015)

---

Well I hope you are OK. 😀

It isn't a system field, the column c1is a user...

Catch the comment in this post: http://www.sqlservercentral.com/Forums/FindPost1683559.aspx

New Born DBA (5/7/2015)

---

New Born DBA (5/6/2015)

---

My suggestion, if most of your SELECT queries read on column C6, is to change the primary key from a CLUSTERED index to a...

Jeff Moden (5/6/2015)

---

Lynn Pettis (5/6/2015)

---

ramana3327 (5/6/2015)

---

We are using Sql 20082 Standard edition. Data drive has enough free space but that table stores the errors that we don't required to store...

You should license SQL Server to the underlying physical hardware. You would then be...

CREATE TABLE statement.

DDL is a TLA for Data Definition Language.

It would still help if you could provide the DDL (CREATE TABLE statement) for the table(s) involved in the query, some sample data (INSERT INTO statements) for each of the...

Developer Edition is the Enterprise Edition with restricted licensing.