Thanks Jeff I have tried both an inner and a left. The left seems to speed it up a bit.

sorry I am not 100% sure I follow. Why would the method that I had not work? If you do the Len and char index line it does return...

So using your first two lines which are the same as mine I am getting a Invalid length parameter passed to the right function.

See attached image this might make a bit more sense. So as you can see it can switch back and forth. So right now on the working table the...

I think we found it last night. When we were running backupexec to tape we were also pushing our critical DB's offsite with another product. This was disabled but the...

please forgive my newbieness

whats that and how do we figure out if it is running?

Thanks I used one of the Dyamic views that I found and it shows 6.5 gigs so we are good. Way to go task manager.

Thanks for all the help

oh so its the lock pages that skews those results.

what is an accurate way to get how much memory sql is actually using so i can show my boss the...

Sorry that's the memory usage showing for the Sqlserver.exe in Task manager. Since its 64bit its a bit more accurate then the 32bit os. I also checked in process monitor...

Just using task manager to see the PF size.

our sql server was using upwards of 3.8 gigs now its down to 200 megs so that should be slightly concerning...

I am still looking for some more help on this if anyone has some more ideas.

So just to go over it again we have Server 2008R2 running a 32bit version...

we are not able to add/subtract or anything. Got to work with what we got so this was the best way we could do it.

It takes about 5 seconds...

That was it I didn't have it on the first section.

I don't know of any other way to preform what I need to do other then those options.

I need the...

Still get the same error

Msg 421, Level 16, State 1, Line 1

The ntext data type cannot be selected as DISTINCT because it is not comparable.

Thanks sean

its a third party Database so I cant change it there.

How do I got about changing it in the query?

Thanks