Hi,

I asked about equality search. First example in post.

With dates i don't see a problem.

Hi,

Interesting article, but i have a question.

In equality search method we will have scan and not search or you imply having index on varbinary(8000)?

Or am i missing something?

 

Hi,

Interesting article, though i have a question.

Equality search method you described will be scan and not search. Or you imply there is an index on varbinary(8000) ? Or am i...

Hi,

I guess i do not understand here somethings.

You said there is a limitation for using batch mode : need to be rowstore  and then you tell that one of best...

Hi,

Or you can just make this measure always available with latest value and no expencive actions by just updating customer table every time a customer doing a purchase.

Simple and value...

Good article.

I use cross apply quiete a lot in DWH.

When need to build template for the report and then populate it with actual data.

Building dimensions with cross apply and...

Nice article!

I usually try to avoid cases when query predicaments look like this:

WHERE (ColumnX = @variableX OR @variableX IS NULL)

AND (ColumnY = @variableY OR @variableY IS NULL)

AND (ColumnZ =...

TheSQLGuru (5/27/2016)

---

David.Poole (5/27/2016)

---

Some time ago I saw an article where the author had noticed a problem with a query where the principle condition was WHERE OrderDate BETWEEN @StartDate AND @EndDate.

The...

Jeff Moden (5/15/2016)

---

etheral1980 (5/14/2016)

---

Good to know there would be built in function to split string now. And i have various ways to use them.

But right now i use function which...

Good to know there would be built in function to split string now. And i have various ways to use them.

But right now i use function which can work with...

GilaMonster (11/24/2010)

---

gosh (11/24/2010)

---

I expected proof that there was a performance difference between the order of columns in a composite index or a performance difference in the order of columns in...

When you wrote low selectivity maybe you meant high selectivity? It is when optimizer can decide to scan the index/table, because result set is large in % terms ?

andy_111 (2/1/2016)

---

Daniel Matthee (1/31/2016)

---

I have not tested but just by looking at the code will it not delete both the records???

There is nothing to indicate that you just want to...

Or use dynamic sql to build this query 🙂

No need to be afraid of them.