E-book is always a good option if you can download it for free.

Hard copy helps me to read further as on my laptop or ipad, I start playing games after...

First it will validate check constraint on the row.

If you are inserting/updating row by row then in case of violation, it will raise exception on the row and will...

Gail is about to touch 'SSC-Forever'

Steve giving tough fight to Jeff.

#3 (Divide and Conquer) has an advantage that will likely grow depending on the number of rows in your table (the more rows, the more the initial INSERT capturing the...

Thanks Dwain.C

Kindly ignore my earlier post, I missed it completely. Actually, Other four solutions are giving accurate results

My results goes as below:

1.hunchback

WITH C1 AS (SELECT Shift FROM test12 WHERE...

Thanks hunchback, Sean Lange and dwain.c for help.

I'm going with CROSS APPLY as it has least logical reads and lesser cost then other two.

Thanks Again.

Thanks for your explanation.

So, should I conclude that I do not have to rely on Execution Plan for optimization of my query. Instead, I should check it only for any...

I never purchased any books to start with SQL Server. Instead I started with simple and small projects, where I had to write small insert/update/delete queries. After few years I...

Grant,

What I have learn is, we have a "estimated plan" and a "actual plan". When we execute a query, SQL gives us the actual plan of what it had...

If you are concerned only about output then use any of these solutions (MAX or OFFSET...FETCH).

If you are also looking for performance (and your table has proper...

I have SQL 2008 and SQL 2012 on same machine, and both are working fine.

Chris,

I split the OR condition of query in two parts and combined results of both queries with UNION ALL. New query is 50% faster. I have attached new plan for...

Mr. Neeraj,

As you can see it is not closed, we will appreciate if you can come up with some solution. We assure you that this...

Hi Chris,

Thanks again for your help.

I could not see any performance difference with/without function. I have pasted the function for you. Meanwhile I'm looking into third point you suggested.

CREATE FUNCTION...

I have attached both execution plans and statistics.

With Index :

(3 row(s) affected)

Table 'Worktable'. Scan count 0, logical reads 0, physical reads 0, read-ahead reads 0, lob logical reads 0, lob...