Adam - if you do a find and replace prior to posting that, and replace the brackets with their HTML equivalents - it won't get stripped.

Meaning - replace

> with...

David -

Great Stuff! Nice primer on Agile. You touched the highs AND lows of the approach.

Your final points are critical, and just became ten times more relevant...

Vika - Jeff's point about temporary tables versus table variables is that they're really not all that different. Most of the things your colleague was trying to scare you...

Matt Marston (2/13/2008)

---

-- This will only call the function once

SELECT * FROM sysobjects WHERE [id] <= dbo.fnDateAdd(object_id('dbo.fnDateAdd'))

-- This will call the function for every row in sysobjects.

SELECT * FROM...

Conor had a lot of interesting stuff in the few blog posts he has made - like rules of thumb when queries will recompile, why Top 100 PERCENT is evil,...

Is the point of the notification to force refreshes of the data? That's usually what this is for (meaning - notify that the contents of your cache is no...

Christopher -

First off - nice CTE solution. However - the order by inside of the ROW_NUMBER() only guarantees the order in which the numbers are assigned, and not...

Marios Philippopoulos (2/13/2008)

---

It has always struck me that the one professional group most resistant to CLR integration within SQL Server tends to be the one that stands to gain most...

Like Adam said - there are a lot of things that can be done. It would be helpful to have some further specifics at to what you need to...

Mike C (2/13/2008)

---

Matt Miller (2/13/2008)

---

Stop - you're starting to sound like our "friend" Cimode's position from the infamous epic flame/religious war experience, NULL versus Null?[/url]

for what it's worth -...

Well - as I mentioned earlier - I'm now confused.

There's conflicting info as to how developer edition is to be licensed. From the "How to buy FAQ", it says:

Q....

No - you are correct in that there are definite differences in licensing. Dev Edition is per user (no server component whatsoever). So you'd need to license/buy Dev....

Christian Buettner (2/13/2008)

---

Hm, I thought I had tried the SCHEMABINDING before already but that really works now.

I have also tried to use a non-deterministic function within a function - that...

With the caveat that Developer Edition = Enterprise Edition (meaning the only difference between the two is that I'm not "allowed" licensing-wise to use it in production) - I would...

Christian Buettner (2/13/2008)

---

Hm, I am having a blackout:

Why is this function not deterministic?!?

CREATE FUNCTION dbo.fnDateAdd()

RETURNS int

AS

BEGIN

RETURN 0

END

GO

Do I need to have any special session settings enabled?

SELECT objectpropertyex(object_id('dbo.fnDateAdd'), N'IsDeterministic')...