I am using the one u provided:

IF OBJECT_ID(N'tempdb..#T') IS NOT NULL

DROP TABLE #T ;

IF OBJECT_ID(N'tempdb..#T2') IS NOT...

I am using the one u provided:

IF OBJECT_ID(N'tempdb..#T') IS NOT NULL

DROP TABLE #T ;

IF OBJECT_ID(N'tempdb..#T2') IS NOT...

GSquared (3/9/2011)

---

Something like this will do a full dedupe. It won't leave deliberate dupes intact. The only way I can think of to do that would be a...

GSquared (3/9/2011)

---

Something like this will do a full dedupe. It won't leave deliberate dupes intact. The only way I can think of to do that would be a...

GSquared (3/9/2011)

---

And what do you want to do if the word has a legitimate repeat in it? Aardvark, apple, peer, assimilate, better, coordinate, dunnage, tonne, etc., all have repeating...

GSquared (3/9/2011)

---

And what do you want to do if the word has a legitimate repeat in it? Aardvark, apple, peer, assimilate, better, coordinate, dunnage, tonne, etc., all have repeating...

hemangmehtaa (1/13/2011)

---

Hi,

We have 2 databases db1 and db2, they may or may not be on the same server.

Now db2 has got a particular table called foo. when db2 enters a...

SKYBVI (1/5/2011)

---

Hi,

I was able to successfully restore the database on secondary side and also set up log shipping.

But there was a variance.

As far as I know, log...

SKYBVI (1/5/2011)

---

Hi,

I was able to successfully restore the database on secondary side and also set up log shipping.

But there was a variance.

As far as I know, log...

jamesnjamesn (11/29/2010)

---

Slow query performance after upgrading from SQL2000

We are having query performance issues with our data warehouse server after upgrading from SQL2000 to SQL2008R2.

Our problem is that *some* queries which...

jamesnjamesn (11/29/2010)

---

Slow query performance after upgrading from SQL2000

We are having query performance issues with our data warehouse server after upgrading from SQL2000 to SQL2008R2.

Our problem is that *some* queries which...

How about using Linked server (if it is...

How about using Linked server (if it is...

Can you describe what did you do to fix the problem ?

Cheers !

Kevin Wieand (9/27/2010)

---

Can anyone help me with this?

I have a table with an ID, last name, and first name which are all varchar. There are other columns in the...