Here is an article that should help.

http://jasonbrimhall.info/2011/03/21/dedupe-data-cte/

Is it the row or the column that is of concern?

Thanks - this is helpful and makes sense.

You're...

I have wondered the same thing

Congrats to Gail and Grant on the new book coming out in November.

http://www.apress.com/9781430247708

Here's another one coming out in August (by a couple of other threadizens).

http://www.amazon.com/Server-2012-T-SQL-Recipes-Problem-Solution/dp/1430242000

ICU

pwalter83 (7/17/2012)

---

SQLRNNR (7/10/2012)

---

You can have 1 connection manager and have a variable to overwrite the server expression for that connection manager. But only 1 at a time.

A better description...

Good question.

I had no errors whatsoever with the database name of this.that

see below example

Create database [this.that];

GO

Use [this.that];

GO

Create table [this.that] (someid int);

GO

with E1(N) AS (

...

I'm with Gail on shutting down SQL services for the defrag. If the volumes are fragmented, then defrag them.

incorporate

thanks for the question.

Koen Verbeeck (7/16/2012)

---

SQLRNNR (7/13/2012)

---

Koen Verbeeck (7/12/2012)

---

You have to make sure SQLNCLI10 is used, as SQLNCLI11 doesn't support connections to SQL Server 2000. Which provider did you choose in the Linked...

mtassin (7/13/2012)

---

Got the MCITP today. Honestly, I found it easier than the MCTS. Probably because it required a little bit more reasoning, and less rote memorization. I...