Actually I was told a while back to look at it this way. In the early years when Computers were new things were generalized, kind of like early doctors. Now...

SQLKnowItAll (3/28/2012)

---

S_Kumar_S (3/28/2012)

---

Hi

Can you pls guide to some link that shows this difference. Most of the places I know just say that the performance is similar. e.g this one:

Oh another thing I just noticed which puts what I say ahead is this. You logged 09876 for cat in both tables, but if you store it in int the...

There is one thing we know for sure and that is that there will be no match if the data in b is alphanumeric. Try this and see if it...

If they are on the same server you might can use checksum to detect differences in rows.

Here is a simple example

SELECT

*

FROM

(SELECT KeyColumns, CHECKSUM(CheckColumn1, CheckColumn2, ...) Chk FROM DB1.dbo.TableName) X

FULL OUTER...

Honestly the article is good even though I would not use this method for what they are trying to do. But just like a cursor understanding how this works can...

Phil Factors example above...

Phil Factor (3/13/2012)

---

The original code that was presented will work for any language setting. That's important. Scooping out the contents of sys.syslanguages will only work if you do it according...

That is why you would use either the method I used above. Or monthname = DATENAME(mm,DATEADD(mm,0,0)) instead of monthname...

Just because I was in the mood for a little fun but another option is to use the syslanguages table to get the information like you want. There is a...

First off full disclosure, I got this wrong as well as I had just forgotten since I don't prefix with sp_

OK, I think a bit of clarification on the SQL...

izblank (5/31/2011)

---

To Antares686:

The Calendar table is not very big, so you're not saving much space by storing exceptions. Besides, having a full-blown Calendar table gives you much more than...

You know I have done this myself but later came to wonder why people want to store all information for dual logic scenarios when they just need the smaller set....

cherie j sheriff-437357 (1/8/2010)

---

The article stated that men were self promoters while women did their work and waited to be recognized for the work they had done. The article...

Matt Miller (#4) (1/7/2010)

---

Steve Jones - Editor (1/7/2010)

---

You...