Sheesh! Once again, I am chastened by the "Everything you think you know is wrong!" fairy. I started off writing big CTE expressions, and they crashed under their...

Actually, Indexed Views ARE available in the Standard edition of SQL Server. You just have to manage them yourself, using explicit query hints.

From http://msdn.microsoft.com/en-us/library/ms187864.aspx:

"Indexed views can be created in...

Ok, guys. Here's the progression ...

- Google: nope

- MSDN Help on Ranking functions: nope

- Experts Exchange: nope

- Start to write some God-awful RBAR code: hear mental admonishment from Jeff

-...

David Harder (6/25/2009)

---

I missed this also because I read the question. It says "What is the equivalent of 'text' data type in MS Access?"

Although the majority are getting it "correct"...

More of an avoidance than a hard-and-fast rule. As an ordering method, not a problem. As a...

skjoldtc (2/17/2009)

The takeaway is that SQL Server rounds time and don't use BETWEEN with a date range. But, this seems such a strange way to do this. What is the...

I am surprised! Not that I got the question wrong, but that you knew that Stockings was my cat! :w00t:

I have two stories that might be applicable.

1. In my (much) earlier days, I worked with a bunch of engineers. Their writing was atrocious, but they were hired for...

I learned something new today!!! I am so ingrained with VBA that I missed the T-SQL version of ISNULL. But why use ISNULL when there is a perfectly...

craigpessano (4/4/2008)

---

Wikipedia (http://en.wikipedia.org/wiki/Yottabyte) would have you believe that all four answers are correct, using base 2 or 10.

The quoted reference in the answer (http://en.linuxreviews.org/Yottabyte) would have you believe that only...

David McKinney (3/14/2008)

---

Hi,

Hmmm.......

Is it strictly necessary to use the OVER/Partition clause in the CTE? Isn't it solely to restart the row numbering? Or what am I missing?

I think there may be a problem. I answered what I thought was the correct answer, (FROM clause), and I was told I was wrong. The correct answer...

"Always"? I NEVER use superlatives! They give me a headache!

The "milliions of members" gets addressed by the...

Yes, they are both dealing with command line, but here was my simple reasoning.

:r runs within the context of the SQL environment. You gave it user/password and database.

:!! shells out...