Viewing 15 posts - 1 through 15 (of 75 total)
A bit of fun.
Question:
Since I assume the computer your SQL Server is on has a network card, why not just order by newid()?
June 9, 2015 at 8:26 pm
February 24, 2013 at 8:29 pm
Curse you Precedence!
always the one that I forget about, ah well π
February 5, 2013 at 9:44 pm
harmiewiz (12/14/2012)
Curious about this one, wouldn't the second SET IDENTITY_INSERT ON statement generate an error right there?
Yes it does π
and if it weren't for all those GO's in the code...
December 16, 2012 at 4:32 pm
L' Eomot InversΓ© (12/11/2012)
December 11, 2012 at 2:41 pm
It occurs to me that we should not be confusing STUFF with arithmetic (string concat is a form of additive string arithmetic) with regards to the replaceWith argument.
yes, anything +...
December 10, 2012 at 7:03 pm
To be fair to the ISP's out there, we aren't talking a few connections here, we're talking many tens or hundreds of thousands if not millions (for the bigger providers)...
November 6, 2012 at 9:04 pm
Sounds very interesting for a self contained database, I have many business systems where I would find this valuable for DR.
Just wondering how this works if I need to join...
May 22, 2012 at 9:26 pm
I wouldn't use ATM's as an example as I think you will find that in this day and age, all ATM transactions are live (both debit and credit cards).
You need...
March 14, 2012 at 4:32 pm
I'm not amazed in the least...
I will often cite Jeff's articles to our developers and also to people I know outside of work.
He is one of those people whose name...
September 13, 2011 at 10:27 pm
This article might be interesting: note the reply from microsoft at the bottom
Replace of char(0) does not work in DB with Windows collation
I know it isn't exactly the same issue,...
July 31, 2011 at 11:57 pm
O' and sleep.
Fatigue is also a major source of general eye strain.
I have found this to be true for myself as when I have a run of late nights (for...
July 12, 2011 at 12:25 am
One concept that has floated around for many years (and I find it works fairly well) is for those with more than 1 monitor, ensure that they are at different...
July 12, 2011 at 12:14 am
1) Nope, although growing up on a dairy farm sometimes felt like one π
2) Yes.
I think there are enough core concepts that you could make one:
The ANSI Standard...
July 5, 2011 at 11:45 pm
Again, it depends on how you define it.
Exactly right, and that is the problem. Sales people say "Cloud" as some kind of cureall.
"I need to make coffee. ...
June 27, 2011 at 7:38 pm
Viewing 15 posts - 1 through 15 (of 75 total)