davoscollective (12/9/2012)

---

Jeff Moden (12/7/2012)

---

Then, there are terms like "OCD" and, as someone pointed out on this thread, OCDs make good DBAs. So why then is it still labeled as...

DavidL (12/7/2012)

---

Come, come, GSquared. Don't...

DavidL (12/5/2012)

---

GSquared (12/5/2012)

---

I once saw a comic (newpaper comics page type thing), titled "Before Astrology was a Science". Had a horoscope on it that went like this:

Taurus: You will...

samalex (12/5/2012)

---

I always have a Cleanup section at the end of my procedures to remove temp tables and the like, even if they will be disposed of automatically after the...

Is there anything at all in your second table that indicates which customer the data is tied to? Also, anything that indicates sequence?

Honestly, the data looks poorly designed. ...

Lexa (12/5/2012)

---

If you have a proc that is frequently called and it has...

Make sure that defragmentation will actually buy you something before you move ahead on complex plans to get it done.

Defragmentation of indexes is really only important if you do range-selects...

It doesn't hurt anything.

I don't bother, personally, but there's no disadvantage to it that I know of.

I once saw a comic (newpaper comics page type thing), titled "Before Astrology was a Science". Had a horoscope on it that went like this:

Taurus: You will interpret vague...

That's not T-SQL syntax. Not ANSI SQL syntax either. Not sure what it is.

The part that SQL Server is objecting to is the list of columns (I assume...

Are you looking for interesting/clever, or effective?

Honestly, all of the answers given so far are just different ways to tell the optimizer to do (essentially) the same thing. Of...

If you're happy with DropBox, use that. SkyDrive is just another option for it.

Main reason I use SkyDrive is because I've been using it (and hotmail) since before most...

You should be looking for all the things you'd look for in any review of an execution plan:

Out of date/Missing stats

Table/Index scans (not always a bad thing, but worth noting)

Join...

Views aren't something you execute. Do you mean when you query data from one?

With that same structure, try this:

SELECT *

FROM dbo.Parcel AS P

INNER JOIN dbo.ParcelDetail AS PD

ON P.ParcelId = PD.ParcelId

WHERE P.ParcelId BETWEEN 10 AND 20;

You'll still get a Nested Loops Join.

Has nothing to...