Heh... well, what's the matter? Didn't they follow the "time to market" and the "splash for the cash" paradigm that everyone seems to preach... instead of writing quality code...

RBarryYoung (12/31/2008)

---

True, but that's not "SQL" so much as it is an implementation artifact of T-SQL and SQL Server. And it's got so many conditions on it that I...

I was just reading yet another series of droll and longwinded articles on temporal data types consisting mostly of useless history and a whole bunch of rhetorical crap not having...

As you know, there is one place where it is... UPDATE in the presence of a CLUSTERED...

Barry, Bob, and sgovoni... you guys have a great new year!

Yep... agreed. And the difference between a pyramid scheme and a legal MLM is a legal MLM actually sells product or tangible services.

Ok... now I'm getting really afraid for you guys... :hehe: you're talking about this like you use cursors and you're listening to the guy who wants to remove the FROM...

BAAA-HAAA! Does (s)he know that you write code that uses a cursor (p_MsForEachDB)...

Chris Harshman (12/31/2008)

---

:Wow: Can't we just all get along??? Personally I think there are things worse than semicolons in SQL, but I'm not going to get into them here....

Grant Fritchey (12/31/2008)

---

I presented this as a database design at a meeting once.

CREATE TABLE [dbo].[AppTable](

[Id] [int] IDENTITY(1,1) NOT NULL,

[RefId] [int] NOT NULL,

[AppValue] [nvarchar](max) NOT NULL,

CONSTRAINT [PK_AppTable] PRIMARY KEY CLUSTERED...

Grant Fritchey (12/31/2008)

---

Yeah, completely true, but however inefficient msforeachdb is as a cursor, when you're running consistency checks against all the databases on a server, does the extra 45ms (or...

Grant Fritchey (12/31/2008)

---

Even though SQL Server 2005/2008 will store excess values past the 8060 limit when dealing with varchar,etc., you will get performance overhead to go and do that extra...

Simplicity personified.

Tom.Thomson (12/31/2008)

---

Just add "FAST_FORWARD" and "STATIC" to the cursor definition and the cursor method will run as fast as your non-cursor method (and for large datasets it will...

Jeff Moden (12/31/2008)

---

ta.bu.shi.da.yu (12/30/2008)

---

If you store more than 8KB of varchars (for instance a varchar(6000) and a varchar(5000) on one table) then you won't get that error. Instead, SQL Server...