I think it has a lot to do with the mindset difference between an app coder and a database developer. I can go on at length but there's a...

UMG Developer (4/1/2011)

---

Craig,

That is a portion of what I suggested, but it really falls short.

For example if the first table contains 7 rows with a value of 1 and the...

An incredibly quick and dirty way:

CREATE TABLE #T1 (ID INT);

CREATE TABLE #T2 (ID INT);

INSERT INTO #T1 VALUES (1)

INSERT INTO #T1 VALUES (2)

INSERT INTO #T1 VALUES (3)

INSERT INTO #T2 VALUES (1)

INSERT...

:blink: So would removing 2/3s of the...

Thirded, very well deserved. Congratulations.

opc.three (3/31/2011)

---

Craig Farrell (3/31/2011)

---

opc.three (3/31/2011)

---

You'll notice that a clustered index was not defined as part the CREATE TABLE statement and I was pointing out that in the absence of a,...

James Stover (3/31/2011)

---

Fortunately the Cloud will save us from failure. Because we know how bullet-proof telecom infrastructure is. It never fails...except when it storms, or during peak solar activity, or...

opc.three (3/31/2011)

---

You'll notice that a clustered index was not defined as part the CREATE TABLE statement and I was pointing out that in the absence of a, [explicitly] defined clustered...

WayneS (3/31/2011)

---

I was asked a question a few minutes ago by a developer. Didn't want to laugh in his face, primarily because he didn't believe this either. But at his...

ptlbiren (3/31/2011)

---

I AM GETTING FOLLOWING BELOW ERROR

Msg 8115, Level 16, State 6, Line 14

Arithmetic overflow error converting varchar to data type numeric.

And also correction in above update statement it is...

CELKO (3/31/2011)

---

Please post real DDL. Learn to use ISO-11179 rules for the data element names, avoid needless dialect and use ISO-8601 temporal formats, codes and so forth. People cannot read...

Grant Fritchey (3/31/2011)

---

Craig Farrell (3/31/2011)

---

Oh, him. ...

Tom Bakerman (3/31/2011)

---

This seems like rehashing old news. I have vague memories from a database class I took in the 80s where we talked about an airlines data center...

Oh, him. Yeah, I gave up...

Roy Ernest (3/31/2011)

---

Topic Change. But Steve, you can delete this post if it is against any rules of the forum. I know that some of the people hanging around here...