Keith Tate (12/11/2013)

---

I would look at this part of your where clauseand (spt.IsNextOfKin=1)or /* using OR as not ALL employees meet the three conditions */

([set].IsNextOfKin=1)or

(sat.IsNextOfKin=1)

If you want one of those...

Which, or how many, of the 297000 returns that Google brings back would you...

srikanth5868, please start a new thread for your question.

Good on SQLServerCentral.com for stepping up publicly on this. The book give-away is just icing. Here is a very complex example I show in my SQL Server 2012...

select distinct top 100

i.invoice_id, i.buyer_code, i.submit_time, i.request_id

from

dbo.invoice i inner join dbo.invoice_adj ia on i.invoice_id = ia.invoice_id and ia.amount !=0

where

(i.detail_amount != 0 or i.tax_amount!=0)

and not exists (select 1

from dbo.invoice_detail...

Compare the amount of data in the tables involved. Perhaps someone did some inserts or deletes that changed estimated row counts.

Verify that the queries are EXACTLY the same, and...

Sure, but being a...

Disk letters mean...

SQL!$@w$0ME (11/28/2013)

---

Hi All,

We are planning to migrate to SQL Server 2012 from 2005. We are in the initial process of building a 2012 DEV environment in Windows 2012. Please assist...

I gave a very good talk on MERGE that you can download here: http://sqlsaturday.com/217/schedule.aspx

Note you can View All Events and open the schedule page for every SQL Saturday that...

I am sorry Luka, but I still have no idea what you need here. Your data doesn't match the graphic you gave (which covers 2010-03-26 06:00 through 2010-03-27 06:00),...

Until you have some data value skew, in which case the probability of getting screwed increases...

Please provide a sample table with sample data and expected outputs. We can't help easily based on verbal descriptions.

I concur. Run Profiler with RPC...

1) IIRC, it is mandatory to update all statistics with FULLSCAN when upgrading from SQL 2005. You could be getting a horribly bad plan on the delete.

2) use sp_whoisactive...