Can you post the query and both plans with estimations? As Grant said, on of the first things you have to check in such cases is new Cardinality Estimator. It...

The best resource for window function is the Itzik's book Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions

Here is a great article series (3 articles) written by Fabiano...

If you define the column with the DATETIME data type you save (as the name says) date and time component of a date together so you can have any number...

Hi,

First I would suggest you to use appropriate data types for attributes. If you use DATETIME datatype for the attribut Rent_Review_Date you don't need anymore two attributes for review_date which...

If this column should have NULL in all rows you can create a new nullable column with the name XmlColumn2 and then swap the names between XmlColumn and XmlColumn2 columns...

Just on the first look I noticed that you have

MONTH(CreatedOn) =MONTH(GETUTCDATE())

which will return all rows created in March in any year, not only in 2015 as you wanted (according to...

As far I understood the plan you get with table variable is the most efficient one. Usually you get the best plan when you use literals in queries, without variables...

Hi Louis,

Try to replace the orginial WHERE clause (without local variables) with the following code:

WHERE (QU.QuotationDate > @From OR COALESCE(QUIC.Next_Follow_Up, 0) > 0 )

AND QU.QuotationDate...

If we define duplicate rows as rows where the following attributes are equal: attendace_date, staff_id, working_year, [hours] and that the original row within them is the row with the smallest...

WITH cte AS

(

SELECT

Id,[Status],manager,Team,Comments,[Proj number],[Date],

ROW_NUMBER() OVER(PARTITION BY [Status],manager,Team,Comments,[Date] ORDER BY Id ASC) rn

FROM YourTable

)

SELECT Id,[Status],manager,Team,Comments,[Proj number],[Date]

FROM cte

WHERE rn = 1

ORDER BY [Date] ASC

Thank you BWFC for the correction!

A great thing in this forum is whenever you...

DECLARE @s-2 AS VARCHAR(100)='123756zxfggr123456';

SELECT REVERSE(

SUBSTRING(REVERSE(@s),PATINDEX('%[0-9]%',

REVERSE(@s)),PATINDEX('%[^0-9]%',

SUBSTRING(REVERSE(@s),(PATINDEX('%[0-9]%', REVERSE(@s))),LEN(@s)))-1));

To solve this problem you can use an excellent article (actually series of articles) by Itzik Ben Gan about gaps and islands. Since you are using SQL 2000 you could...

+1

Only if you are sure...

It is true that Key Lookup can be avoided by converting your index to covering index. But, you should be careful! If you include too much columns you will actually...