Viewing 15 posts - 1 through 15 (of 57 total)
Heh, maybe you could sp_help_targetserver if you made a link to the local server
March 13, 2006 at 9:53 pm
Anecdotally, distinct is often faster, although I do not know why--I much prefer group by, myself, as I prefer to have the demographics as well
March 13, 2006 at 9:47 pm
You are aware that SQL Server has nvarchar type for UCS-2 Unicode, but you're using varchar -- which means a specific codepage? Could your source data be outside the specific...
March 10, 2006 at 5:14 pm
I saw this, btw: http://forums.oracle.com/forums/thread.jspa?threadID=226114&tstart=30
Also, maybe the .net provider can't figure out whether your nvarchar(2) source data is UTF-8 or UTF-16. I don't know if SQL Server can...
March 10, 2006 at 5:13 pm
There ought to be a way to get the local MAC address, because the client is apparently passing it to the server (it's visible in the current activity pane).
But the...
March 9, 2006 at 8:54 am
I think SQL Server always rounds the 5s up, and that gives you a biased estimator (considered with a uniform distribution).
March 8, 2006 at 6:56 pm
Do you know if that old CTP version uses some old .NET 2.0 CTP version?
I remember multiple problems with CTP & beta versions of .NET, Whidby, and Yukon, so I'm...
March 8, 2006 at 4:37 pm
March 7, 2006 at 2:18 pm
You could try removing the brackets (old bug: http://support.microsoft.com/kb/290413/EN-US/), or try different cursor types?
March 6, 2006 at 6:27 pm
It is called SQL Server 2005 Express Edition (and obviously you simply google on the name and look for the hit at Microsoft).
March 6, 2006 at 6:04 pm
I figured out a replicate call, but it required wrapping it in a case to avoid passing a negative to the replicate. That right/convert combo is more succinct. Thanks.
March 6, 2006 at 5:56 pm
March 6, 2006 at 4:44 pm
(Hit too soon.)
You could manually convert your source files to another encoding, eg,
type original_file | iconv -f CP862 -t UTF-8 > new_file
(which converts the file to Unicode UTF-8 encoding)
March 6, 2006 at 4:40 pm
You could try another codepage (1255?).
You could look in the machine's registry to see what codepages it has registered support for:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Nls\CodePage
March 6, 2006 at 4:39 pm
This is probably not relevant, but there are a lot of other titles in the world, and there are suffixes (such as Jr), and there are multiple surnames which are...
March 6, 2006 at 4:35 pm
Viewing 15 posts - 1 through 15 (of 57 total)