There is no direct downgrade from 2008 Enterprise Edition to Standard Edition, so you would have to do one of the following:

Setup a new server running Standard Edition, and migrate...

How about "cleaning" all address into another table with a pointer back to the original "unclean" address.

You can than compare the clean addresses to identify duplicates.

A little dynamic SQL with a string of 100 digits as input:

declare @val varchar(100) =

'20876543914578560430730723092317208765439145785604'+

'3073072309231720876543914578560430730723092317208'

declare @cmd varchar(300)

set @cmd = 'select [Sum] = '+

reverse(substring(reverse(replace(replace(replace(

replace(replace(replace(replace(replace(replace(replace(

convert(varchar(300),@val),'9','9+'),'8','8+'),'7','7+'),'6','6+')

,'5','5+'),'4','4+'),'3','3+'),'2','2+'),'1','1+'),'0','0+')),2,300))

print '@val = '+@val

print '@cmd = '+@cmd

exec (@cmd)

Results:

@val...

mark 4643 (8/3/2012)

---

Do you know if you can install SSRS 2012 on same server as 2008 SQL (otherwise need to buy another license) and along side SSRS 2008 (I think...

Before you completely dismiss SSRS, you should make sure that you look at the latest version of it, SQL Server 2012.

Even if your data source is a SQL 2000, 2005,...

In place of this:

or the earningsdate <> the timekey from dt3

or the CycleMonth <> the timekey from dt2

or AEarned1 <> staging column 1

or AEarned2 <> staging...

Have you looked at the formatting? Something is very wrong.

Why is there a...

Anytime you do a join between a local table and a remote table you have a likely performance problem.

The best way to deal with this depends on many things, like...

Lynn Pettis (7/31/2012)

---

Let me take this a bit further. Where I am working now, people in the office will "telecommute" to local meetings. Since we do have geographically...

SQLRNNR (7/30/2012)

---

Michael Valentine Jones (7/30/2012)

---

I'm really not sure exactly what you want to discuss.

There are plenty of people that create denormalized databases and claim they did it for speed, and...

I'm really not sure exactly what you want to discuss.

There are plenty of people that create denormalized databases and claim they did it for speed, and not just in e-Commerce...

SQLRNNR (7/30/2012)

---

Michael Valentine Jones (7/30/2012)

---

maw74656 (7/30/2012)

---

Are you suggesting there is no point where too many comments can slow it down, or that the point is so large its impractical to...

Did you enable the mail profile under the SQL Server Agent Alert System properties?

maw74656 (7/30/2012)

---

Are you suggesting there is no point where too many comments can slow it down, or that the point is so large its impractical to consider? What if...

GSquared (7/26/2012)

---

Steve Jones - SSC Editor (7/26/2012)

---

derek.colley (7/26/2012)

---

Sorry Abel but this is god-awful advice. I recently...