edwardwill (4/22/2015)

---

I copied and pasted the code into SQL Server 2014 and got this:

Msg 156, Level 15, State 1, Line 21

Incorrect syntax near the keyword 'OR'.

Msg 156, Level 15, State...

Good question!

I do not like "Filtered indexes", they are too much limited. I prefer indexed view.

karthik babu (4/20/2015)

---

Nice Question.. Index remains same irrespective of altering the table by adding a constraint and then by adding an unique clustered index.. I believe the index should have...

Hugo Kornelis (4/15/2015)

---

But note that supplying an offset only produces the expected results if you can be sure that there is exactly one row per month in the sales table....

Try to answer this one:

Table Array[/url]

A GLOBAL temporary table has 128 characters as the limit.

+1

Ahi, ahi, ahi, ahi, ahi, ahi!!!!!!!!!!

:w00t:

Rune Bivrin (4/7/2015)

---

I was very torn between "3" and "Not supported". Based on the following in the cited documentation, I kind of felt both were correct:

The FIRSTROW attribute is not...

Thx, very interesting.

Rune Bivrin (3/26/2015)

---

Which is...

sipas (3/24/2015)

---

Speak for yourself - plenty of people get confused about multiple foreign keys and cascade deletes. They're all extremely easy when you know the...

Extremely easy!

Why 2 points?

🙂

Simpaticissimo!

:-D:-D:-D:-D:-D

patricklambin (3/17/2015)

---

Good question but an easy one.

I have appreciated because it is an example of "bad code" ( too difficult to understand ) that I have met too many times...

I tried just a little. The answer is as usual "depends".

If you query...