Serious question:

Should scalar subqueries not be...

I won't use COALESCE, because it's broken:

SELECT COALESCE((SELECT CASE WHEN RAND() <= 0.5 THEN 999 END), 999);

SELECT ISNULL((SELECT CASE WHEN RAND() <= 0.5 THEN 999 END), 999);

The final 999 value...

Gianluca Sartori (12/17/2010)

---

Just be sure to turn off "Auto List Members" and "Auto Parameter Info" if you're working on a database with lots of objects or you will have SSMS...

Gianluca Sartori (12/17/2010)

---

Has anyone tried SQLComplete intellisense[/url]? I'm trying it and it doesn't look bad at all. Since I work on 2005 servers it comes very handy. Moreover it's completely...

Malcolm Daughtree (12/16/2010)

---

Yep! Left that one.... I actually went back to the beginning of this thread and if one was inclined to make a career of 'SQL comedy' or Programmer...

Yup, and as...

That's the point. The index...

I just typed this successfully in 2008 SSMS with Intellisense on (which it always is):

SELECT rn = ROW_NUMBER()...

I hadn't noticed that 2005 objected...the fix is simple though, just remove the pointless (data) column reference:

INSERT dbo.Example...

Craig Farrell (12/16/2010)

---

I'm trying to force an IAM defrag that will cause this. I've forced some fragging, but I'm still getting logical read orders. Get back to you....

The point of the...

Tom.Thomson (12/16/2010)

---

Paul White NZ (12/15/2010)

---

Perhaps it would be nice if SQL Server printed a warning message in the second case. My understanding is that this is technically impossible to...

CREATE TABLE dbo.Example

(

row_id INTEGER IDENTITY NOT NULL PRIMARY KEY CLUSTERED,

data AS CONVERT(VARCHAR(11), row_id) PERSISTED...

Perhaps so. Sadly it wasn't practical so we have to live with it.

And i would say also that if...

evald (12/15/2010)

---

...I'm just trying to say that if the order clause is not working in some cases for some reason than its useless and confusing give the possiblity to the...