Also, as I try to make sense of the multiple joins I am starting see some circular joins occurring as you query the same table multiple times.

To be honest, if...

Just an FYI, your query is so complex that the optimizer timed-out in both the fast query and the slow query while attempting to generate an execution plan. This...

DavidDroog (7/22/2015)

---

Hi Alex

thanks for the reply.

Are you saying SQL cannot handle 3 way joins? Are you also saying that a where clause is more efficient than a a join on...

DavidDroog (7/22/2015)

---

Hi Guys

thanks for the replies.

@Phil - found it. Fast and Slow query plans are now attached, hopefully someone smarter than me can discern something useful from them.

@Jayanth - I...

anjaliagarwal5 (7/22/2015)

---

Hi All,

I need to pass the messages coming from sql server to the asp.net application so I have the following script

CREATE TABLE tbl_sample

(

[ID] INT,

[NAME] VARCHAR(10),

)

GOI am trying...

Here is what would help, sample data for the tables that is representative of the problem domain and the expected results of the query based on the sample data.

Stephanie Giovannini (7/21/2015)

---

Lynn Pettis (7/21/2015)

---

Stephanie Giovannini (7/21/2015)

---

Sean Lange (7/21/2015)

---

If this is a sql job, which I assume it is, just ask them for any built in function to get the...

Stephanie Giovannini (7/21/2015)

---

Sean Lange (7/21/2015)

---

If this is a sql job, which I assume it is, just ask them for any built in function to get the current datetime. If they...

I've been on the other end of the technical phone interview quite a few times. I find it difficult when I am dealing with an interviewer whose first language...

Okay, help us help you. Please post the DDL (CREATE TABLE Statement) for the table(s) involved, sample data for the table(s) (INSERT INTO statements), and expected results based on...

Most likely, no. This question has been asked many times on SSC and on a few of the threads there were some suggested third party software options. I...

Hey Gail,

I think your expertise is needed here.

Do you have any backups prior to your running DBCC CHECKDB (or DBCC CHECKTABLE)? Have you restored the latest backup prior to the error under a different name or...

Careful dropping indexes. The DMVs that report usage reset on restarts of SQL Server. Just because an index is not used recently doesn't mean it isn't used on...

Something like this? (I dropped the leading ; from the CTE as it is not needed.)

WITH TableA([date],[ID])

AS

(

SELECT '2012-09-21','1' UNION ALL

SELECT '2012-09-28','1' UNION ALL

SELECT '2012-10-05','1' UNION ALL

SELECT '2012-10-12','1' UNION ALL

SELECT...