wodom (5/4/2011)

---

It turns out there was already an install of SQL 2000 on TestWeb, and I ran its Client Config, and sure enough, that old version has aliases too. So...

Ok, here is a fuller reply - now that I am at a keyboard...

Open a command prompt on the TEST server and type

%WINDIR%\system32\cliconfg.exe

This will open the SQL Server Client...

Sorry for short answer...on phone...http://msdn.microsoft.com/en-us/library/ms190445.aspx

Read the community content on that page to give you a pointer.

wodom (5/3/2011)

---

mister.magoo (5/2/2011)

---

wodom (5/2/2011)

---

Hmm, interesting but there seems to be a piece missing. If I understand you correctly, there would then be two ProductionDBs advertised on the network (one real,...

wodom (5/2/2011)

---

Hmm, interesting but there seems to be a piece missing. If I understand you correctly, there would then be two ProductionDBs advertised on the network (one real, one alias)...

You can configure an alias on the test server using SQL Server Configuration Manager - see screenshot.

Hi, I would recommend using STUFF(myvarchar,LEN(myvarchar),1,'') instead of REVERSE/SUBSTRING - it's a bit quicker.

Sample timing for 1 million rows:

...

If you really aren't comfortable with the QU (I don't have a problem with it myself, but have yet to need it...), then a simpler pre-select and index gets the...

Toreador (4/26/2011)

---

It can be really annoying when someone posts an interesting question, but the motivation behind it gets virtually ignored as people moan on with repeated posts complaining about the...

Jason, good question - not going to bother commenting on the answer as the question is the important bit.

For the record, (as part of the general discussion of the issue...

opc.three (4/15/2011)

---

I have looked around for a solution using TYPE but have come up empty...what is it that you know and why have you been holding out on us? :-D...

David Dubois (4/15/2011)

---

Let's think about what might be going on inside when those concatenations are being done.

I can't say that I know how this is implemented in this particular...

I don't know the answer, but suggest capturing the query plan using sql profiler, then checking the properties of the SELECT object - it shows the SET options in...

LEFT(your_column,CHARINDEX('_',your_column+'_')-1)

Ninja's_RGR'us (4/13/2011)

---

I guess I wasn't clear. It takes both. Prepending alone is not enough, it takes EVERYTHING varchar. Even a single nchar in there screws it up...