Is it contagious???

A better comparision, then, would be SELECT myColumn FROM myTable to SELECT DISTINCT myColumn FROM myTable.

Be sure to look at the actual execution plans of both of them.

Then you can't compare SELECT * FROM yourTable against SELECT DISTINCT yourColumn FROM yourTable. It's comparing apples to oranges; yea they are both fruits but they aren't the same.

Check out his new thread that Gail found.

Grant Fritchey (2/20/2009)

---

But that example compares one thing you shouldn't do, SELECT *, with another thing that has serious enough costs that it almost needs to be in the shouldn't...

Putts (2/20/2009)

---

GilaMonster (2/20/2009)

Post a reproduction please? It'll be the first case I've ever seen of that.

Adding distinct to a query adds work. It requires that SQL sort or hash the...

GilaMonster (2/20/2009)

---

A government office? That explains everything!

Did anyone notice the one he started this morning?

http://www.sqlservercentral.com/Forums/Topic661280-338-1.aspx

Full outer joins on what appear to be...

Please, some one, come slap me upside the head if I go back here and post anything more.

I'm not going to help perpetuate a farce. Best advice I can give you right now is to go ask your supervisor for training in SQL Server development. ...

Grant Fritchey (2/20/2009)

---

It should give you a chuckle,...

The default instance of SQL Server uses a known port (1433). The port assigned to a names instance is not known, or dynamically assigned. The browser service is...

josephptran2002 (2/20/2009)

---

Hello bvaljalo

First, I apolozige for not knowing your name because I am new to this SQL.

I did change the field name and it still says that dbo.BOCLEARED...

You should be using 2 file connections, 1 for the source and 1 for the destinition. Each would point to the appropriate server (my guess here, as I haven't...

Newbie alert!

Think we should try mounting a rescue mission for bvaljalo?

I would also add a BACKUP LOG after the IF... BREAK if your datbase is using the BULK_LOGGED or FULL recovery models. This will keep your transaction log file...