Viewing 15 posts - 31 through 45 (of 193 total)
chef423 - Wednesday, October 11, 2017 2:24 PMTo ask, what is a more robust option?Thank you.
As Luis intimated earlier in the...
October 19, 2017 at 3:21 am
Plenty of times I've read through code and thought "which idiot wrote this?" and then think - "Oh I guess its this idiot!"
There are a few reasons firstly over...
October 12, 2017 at 7:20 am
DesNorton - Wednesday, February 1, 2017 2:45 AMHowever ....
When comparing varchars
'100' < '99'
That's because '1' < '9' in all collations I am...
February 1, 2017 at 2:54 am
can you really use < on varchar data and have it act reliably? Or...
February 1, 2017 at 2:31 am
January 23, 2017 at 2:59 am
January 17, 2017 at 6:25 am
One area where this can be complicated is where the business allocates resources based on geographical location (or indeed on any other sensitive or personal information)
Typically this would cover...
January 13, 2017 at 10:16 am
Igor Micev (12/23/2016)
skeleton567 (12/23/2016)
crmitchell (12/23/2016)
skeleton567 (12/21/2016)
skipping a minute won't hurt a thing, as long as you don't tell anybody.
Until that one occasion where it does matter. As Murphy and...
December 23, 2016 at 11:58 am
skeleton567 (12/21/2016)
skipping a minute won't hurt a thing, as long as you don't tell anybody.
Until that one occasion where it does matter. As Murphy and Sod will cheerfully point...
December 23, 2016 at 5:00 am
How you handle alerts really needs to reflect the volume of those that are generated.
For low volumes the success mails have value (or rather the absence of them does). When...
December 1, 2016 at 2:59 am
homebrew01 (11/10/2016)
Eirikur Eiriksson (11/10/2016)
Think this is the wrong question, should be "what are the justifications for running an unsupported version of SQL Server"
😎
Doesn't cost any money ?? $10,000 to...
November 11, 2016 at 5:43 am
julian.fletcher (11/11/2016)
SQL Guy 1 (11/8/2016)
declare @var1 varchar(max) = 'It''s now or never I ain''t gonna live forever'select len(@var1)-len(replace(@var1,' ','')) + 1
My thoughts exactly. But you probably need to boil...
November 11, 2016 at 3:28 am
Eric M Russell (9/23/2016)
September 26, 2016 at 4:10 am
So change the column delimiter to something which does not otherwise appear. | is often a good candidate.
or better yet fix the input routines to strip out the superfluous commas...
September 20, 2016 at 9:49 am
Gregory Hart (9/8/2016)
My understanding of databases and mathematics for NULL and infinity is as follows:
Infinity represents a known value, but for which is infinite in size. Size can be either...
September 8, 2016 at 7:32 am
Viewing 15 posts - 31 through 45 (of 193 total)