L' Eomot Inversé (12/17/2012)

---

Hugo Kornelis (12/17/2012)

---

(That being said - there is indeed no guarantee. SQL Server could come up with an execution plan that projects the SELECT list first, then...

john.arnott (12/15/2012)

---

SanDroid, your explanation has me puzzled. The first quote says that one cannot use an expression containing a float expression in the key column of an indexed view....

It was almost a year ago, but from the looks of things I just wanted to show composable...

GSquared (12/10/2012)

---

Steve Jones - SSC Editor (12/10/2012)

---

SQL Kiwi (12/9/2012)

---

Hi Steve,

I did not receive a notification for this post (or perhaps I didn't see it) so apologies for the late reply....

Steve Jones - SSC Editor (11/9/2012)

---

SQL Kiwi (11/6/2012)

---

Steve Jones - SSC Editor (11/1/2012)

---

Interesting discussion. Freedman does mention inserts and deletes, but he never wrote on the subject. Perhaps he was...

We should all switch to Oracle immediately!

LOL

I see. Well, the original code would certainly work, but perhaps consider:

SET @index = 1;

MERGE

dbo.JobRefAllocation WITH (HOLDLOCK) AS JRA

USING

(SELECT...

Kevin O'Donovan (12/4/2012)

---

Is that more complicated than it needs to be for my scenario? I can guarantee that the transaction volume will never increase to the point performance will be...

http://sqlblog.com/blogs/paul_white/archive/2010/10/19/sequence-tables.aspx

scogeb (12/3/2012)

---

Ninja's_RGR'us (8/7/2011)

---

I know this is an old thread but since it seems to be found often on google, I find it important to tell anybody reading this that our...

chisholmd (12/3/2012)

---

Hi all, I have a formula that works fine in Excel but not in SQL. Hopefully someone knows of some gotcha that I am not in this situation.

When...

-- Default for user options is 0

-- See http://msdn.microsoft.com/en-us/library/ms189631.aspx

-- Flag values are at http://msdn.microsoft.com/en-us/library/ms176031.aspx

-- e.g. QUOTED_IDENTIFER is 256

SELECT

...

SQL Server Management Studio is...

The default is OFF (see...

Robert-378556 (12/3/2012)

---

SQL Kiwi (12/3/2012)

---

It seems you wrote a test script that did not cover the full range of possibilities. Include CHAR(198) and CHAR(230)...