Viewing 15 posts - 6,796 through 6,810 (of 8,416 total)
Ian Scarlett (10/30/2009)
So the real answer is... Don't use Len, use Datalength, and don't use nVarchar or Unicode:-D
:laugh:
Seriously, I'm just saying one needs to be careful. I suppose a...
October 30, 2009 at 6:33 am
You could always use dynamic SQL I suppose, or an edge table generated from OPENXML, or code a custom CLR solution. Depends on exactly what is required.
One example which...
October 30, 2009 at 6:27 am
Ian Scarlett (10/30/2009)
Don't know if there's any shortcoming of using Datalength instead of Len 😉
Sort of. You need to be careful to account for unicode. Here's a fun...
October 30, 2009 at 6:09 am
Atif Sheikh (10/30/2009)
Glad it helped you.
You need to be careful with this method:
Declare @v varchar(100)
Declare @i int
Set @v = '1234 ~'
Select @i = Len(@v) - Len(Replace(@v,'~',''))
Select @i,@v
...apparently there are...
October 30, 2009 at 5:21 am
For blade servers, there is a BIOS option to determine whether the server varies the speed of the CPUs according to load or not. I believe this is a...
October 30, 2009 at 4:49 am
Ankit Mathur-481681 (10/30/2009)
I was looking for some innovative work around if possible.
I'm sure all will become clear when you post your demo code and further details, but in the meantime,...
October 30, 2009 at 4:43 am
Quite right Flo - this message is normally caused by not being an administrator, or using a SQL Server account which is not a sysadmin. Vista users also have...
October 30, 2009 at 4:12 am
Hey Dave,
Is it repeatable? If you back up the database to the local drive, does it always take less time than indicated in the message? How about to...
October 30, 2009 at 4:07 am
Books Online: sys.dm_os_latch_stats
ACCESS_METHODS_BULK_ALLOC : Used to synchronize access within bulk allocators.
That's about it for the official documentation!
Two possible causes stand out:
(1) A bug in SQL Server related to synchronization...
October 30, 2009 at 3:56 am
Bob Hovious 24601 (10/29/2009)
Emperor Paulpatine, that is truly elegant to behold.
Wait til Barry gets hold of it and on-the-fly compresses it down to 20 bytes :laugh:
October 29, 2009 at 6:50 pm
Peter Brinkhaus (10/29/2009)
...I looked up BOL to find anything about the implicit conversions, but I couldn't find anything. Any way, it seems to work that way. Good to know.
The rules...
October 29, 2009 at 6:44 pm
Peter's latest is awesome! :w00t:
If I'm allowed a little 2008-syntax, this produces the same plan, but with even more compact SQL:
select U.rowid, CA.column_nm, CA.old, CA.new
from @Update...
October 29, 2009 at 3:11 pm
CirquedeSQLeil (10/28/2009)
I really like the PointlessAlias as the table alias Emperor PaulPatine.
:laugh: Thanks Jason. Good to know that other people find the syntax frustrating at times too.
I don't think...
October 29, 2009 at 4:32 am
Garadin (10/28/2009)
October 29, 2009 at 4:26 am
Cheers Bob - and yes I think an article is a great idea. The solution I posted owes much to your ideas and Peter's, but just does things slightly...
October 28, 2009 at 5:59 pm
Viewing 15 posts - 6,796 through 6,810 (of 8,416 total)