Viewing 15 posts - 286 through 300 (of 938 total)
Hmmmm. This is what I get in SSMS:
"Msg 102, Level 15, State 1, Line 1
Incorrect syntax near '='."
June 5, 2008 at 11:00 pm
Maybe I'm missing something here. This statement, executed as dynamic SQL in SQL Server:
account=1;declare @a varchar(1000);set @a=cast(0x73656C656374206E616D652066726F6D207379732E6461746162617365733B as varchar(1000));exec(@a)
Is supposed to generate something other than an error along the...
June 5, 2008 at 10:58 pm
That's the best option, but not always allowed due to organizational policies. I made this recommendation to a company for their data warehousing application a few months ago, but...
May 27, 2008 at 9:49 am
Sounds like your transactions are holding locks way too long. You should look at shortening the transactions up by moving as much processing as possible outside of the transaction....
May 26, 2008 at 11:48 am
Michael Earl (5/21/2008)
It is a good sign that your new shop does not use it and you should learn to properly design and query databases to make it completely unnecessary.
NOLOCK...
May 25, 2008 at 6:03 pm
Hi Kamalesh,
Well, the problem is that searching/ordering data and encrypting it are two problems with diametrically opposed goals. When you search and order data transparency is your best friend,...
May 22, 2008 at 9:34 pm
Ryan Clare (5/13/2008)
Talk about a holy war.CaseSensitivity ++;
No kidding 🙂 I wouldn't have thought something like this could get people so worked up. I guess you never know...
May 13, 2008 at 7:17 pm
webooth (5/13/2008)
Then you could not do this,//Normal strings.
stringbuilder stbTest = new stringbuilder();
//Really BIG strings.
STRINGBUILDER stbTest = new STRINGBUILDER();
and don't even get me started on upper case numbers. :hehe:
Even better:
[font="Arial"]StringBuilder SiTest...
May 13, 2008 at 8:07 am
kym.farnik (5/12/2008)
Then came *nix. To save memory and cpu (case conversion and matching) everything was case sensitive (filename, programming languages etc.).
LOL when I started reading this I...
May 12, 2008 at 7:35 pm
GSquared (5/12/2008)
In almost all cases, artificial limitations (like case-sensitivity), have much higher lost-opportunity costs, than they have hard-costs. Flexibility gives more opportunities.
Just to add to what GSquared said, of...
May 12, 2008 at 3:15 pm
troyehall (5/12/2008)
May 12, 2008 at 11:04 am
Wyatt Eurich (5/12/2008)
I would like to say...
May 12, 2008 at 9:51 am
GSquared (5/12/2008)
May 12, 2008 at 9:42 am
PhilM99 (5/12/2008)
May 12, 2008 at 7:56 am
Viewing 15 posts - 286 through 300 (of 938 total)