RBarryYoung (12/30/2008)

---

Christian Buettner (12/30/2008)

---

The difference according to my tiny theoretical knowledge is that

a) you separate two or more statements with separators. (A;B;C;)

b) terminators...

Well, you started all this

!:P

No, point taken, this discussion...

RBarryYoung (12/29/2008)

---

Yes, Microsoft, Wikipedia and lots of other places call it a terminator. The problem is that it does not meet the definition of a terminator that most people...

RBarryYoung (12/29/2008)

---

Still waiting for your response to my question:

RBarryYoung (12/28/2008)

---

Christian Buettner (12/28/2008)

---

I might be nitpicking here again, but...

RBarryYoung (12/28/2008)

---

Actually, I doubt that that is the reason, otherwise why would SEND...

Jeff Moden (12/28/2008)

---

Christian Buettner (12/28/2008)

---

Conventions aid us in that they remove decision processes from us. Instead of having do decide for each statement whether a semicolon is necessary, you just...

RBarryYoung (12/28/2008)

---

This is only true if all of the other SQL statements in the same procedure or...

Hi RBarryYoung,

Why do you think it is not a statement terminator?

;

Transact-SQL statement terminator.Although the semicolon is not required for most statements in this version of SQL Server, it will...

Jeffrey Williams (12/28/2008)

---

Christian - the semi-colon is required before a CTE WITH statement. I personally prefer prefixing the WITH instead of relying upon the previous statement ending with a...

Jeff Moden (12/28/2008)

---

Thanks, Chris. Yeah, I know it looks unusual... WITH is the only place where a semi-colon is actually required before something and since I don't use semi-colons...

kendal.vandyke (12/23/2008)

---

Lots of great articles on the intertubez about disk alignment and RAID configurations but I haven't found an answer (or a good way to test, and yes I...

Jeff Moden (12/27/2008)

---

Just for grins, here's the CTE version without TOP...

;WITH

cteTally AS

(

SELECT ROW_NUMBER() OVER (ORDER BY ID)-1 AS N

FROM Master.sys.SysColumns

)

SELECT DATEADD(dd,(t.n)*14,'20090102') AS BiFriday

...

Are you sure? As mentioned before by others, you probably need a calendar table that...

Hi Scott,

As mentioned before, we assume that the documentation is bad.

But your opinon drew me in the other direction:

If the indexed view is indeed an index, then it should not...

I agree with Hugo.

I would rather call it a view-index if we are referring to the index itself.

But blame it on MS and their documentation / naming 😛