Historically, I've seen two major divisions:

1. Production support - these folks start caring about things from the database level up... they are concerned with performance, backups, hardware, jobs, etc. The...

Check out this link.

Paul White NZ (9/16/2010)

---

The final part of my optimizer series is up today. As expected, the page views have been lower than normal, but it has been good to...

Alvin Ramard (9/15/2010)

---

CirquedeSQLeil (9/15/2010)

---

WayneS (9/15/2010)

---

Darn it! Finally get a chance to look at it, and what I...

CirquedeSQLeil (9/15/2010)

---

Alvin Ramard (9/15/2010)

---

CirquedeSQLeil (9/15/2010)

---

Jeff Moden (9/15/2010)

---

CirquedeSQLeil (9/15/2010)

---

Alvin Ramard (9/15/2010)

---

Jeff Moden (9/15/2010)

---

Tom.Thomson (9/15/2010)

---

CirquedeSQLeil (9/14/2010)

---

Jeff Moden (9/14/2010)

---

Oh lordy... I wonder...

CirquedeSQLeil (9/15/2010)

---

WayneS (9/15/2010)

---

Darn it! Finally get a chance to look at it, and what I see is...

I think that this link will tell you pretty much everything you need to know to create indexes.

Even the column names are identical. Seems like homework to me also.

You might want to change this:

IF @MONTH < 4 SET @QUARTER = 1

IF @MONTH > 3 AND @MONTH < 7 SET @QUARTER = 2

IF @MONTH > 6 AND @MONTH <...

Ahh, that would also...

Darn it! Finally get a chance to look at it, and what I see is

This video...

Gail (or someone else) should be around shortly, and will be able to provide much better answers to help you get out of this than I ever could. While waiting,...

Craig Farrell (9/15/2010)

---

Hey Wayne, does substring still work if the data for the VARCHAR(MAX) is no longer stored in row, and goes out to a separate LOB page?

I...

You...

No problem. We all have them because it's just so much easier on us...