Hey,

do you have any ideas on that or do you need further information?

Best regards!

Hi,

thanks for your response, but the problem is that I can't change the way our 3rd party application is building the statements or change the statement itself. My question...

OK, I played a bit around with it and created a filtered index like this (the other index is exactly the same, but it is not filtered):

CREATE NONCLUSTERED INDEX [NCFI_Test]...

Hey,

thanks for your fast response! I already used an extended event to collect long running queries. If it has something to do with latch contention, isn't it right that the...

Thank you very much, it works like a charm! That helped me a lot and I learned something new - as always when I open a topic in this forum....

Ok, so here is the DDL and some sample data:

CREATE TABLE [Sales].[SalesOrderHeader](

[SalesOrderID] [int],

[OrderDate] [datetime] NOT NULL,

[CustomerID] [int] NOT NULL,

[TotalDue] [Numeric](10,2),

CONSTRAINT [PK_SalesOrderHeader_SalesOrderID] PRIMARY KEY CLUSTERED

(

[SalesOrderID] ASC

)WITH (PAD_INDEX =...

dwain.c (2/6/2014)

---

vip.blade (2/6/2014)

---

Wow, thats amazing, thanks alot! I never thought of using a CASE-Statement in a SUM() function. That helped me very much!

Is there also a way to use the...

Wow, thats amazing, thanks alot! I never thought of using a CASE-Statement in a SUM() function. That helped me very much!

Is there also a way to use the FIRST_VALUE(order_date) window...

Thanks for all your responses, this helped me a lot!

Best regards!

Hi,

thanks for your fast response! It's a function to calculate the Levenshtein-Distance from this article: http://www.sqlservercentral.com/articles/Fuzzy+Match/92822/

As far as I know there is no way to transform it into an...

Thank you very much ChrisM@home, that helped me alot!

Best regards!

Perfect, thank you very much, that helped alot!

Best regards!