The ZEN Master (Jeff Moden) will soon end all doubt 🙂

No pressure 🙂

Charles Kincaid (12/9/2013)

---

So let's take an example of a SELECT that does not make any use of indexes.

RBAR fetches more rows from the table. False. It has to...

Sets are nothing magical, not on the math side and not on processing side, thus let this not turn into a religious "set vs no_set" war.

The main point to keep...

patrickmcginnis59 10839 (12/9/2013)

---

peter-757102 (12/9/2013)

When you process row by row you throw out of the door optimization aspects that can be applied to the process as a whole. Things that are...

patrickmcginnis59 10839 (12/9/2013)

---

Jeff Moden (12/9/2013)

---

This is how RBAR comes to be in...

darshan (12/6/2013)

---

Hi,

Consider the following scenario:

1. Application x has a few transaction tables as very huge tables say tables t1, t2, t3, etc.

2. Application is only in maintenance mode and no...

This can also be a simple issue of out of date statistics.

SQL servers build in auto update statistics (if its on in your database) does not always do the job...

There are two more less-known problems with partitioned views that you sometimes have to work around:

1. On inserts you need to specify even null-able columns (just like with instead -f...

You can create multiple filtered statistics yourself that do not overlap in key range, this way you can get multiple blocks of 200 entry statistics, even on a single table....

Window functions are a great feature and very helpful in solving otherwise hard SQL problems.

Reading a good book on the subject is worth a processionals time and money.

As for this...

Gary Varga (11/28/2013)

---

ChrisM@Work (11/28/2013)

---

...Perhaps this is why contractor rates haven't risen in the UK in twenty years. Too many of us have left the client with a huge pile of...

Call me crazy, but under certain conditions it does make sense to have an additional non-clustered index with the PK in it:

* You have a where filter on the index...

The problem with such a question is that many do not know how huge/gigantic/enormous their gap in SQL knowledge is and how profoundly it can affect their productivity. Over the...

There are some videos on YouTube that explain why you should never say anything to the police! Not even with a lawyer present and i think it is just as...

At I wrote a while back in another editorial thread, we gather way too much data. And most of it is without pre-defined purpose, low structured and is never actually...