Viewing 15 posts - 61 through 75 (of 148 total)
Interesting problem. Thanks for posting. I must confess I have not yet read the whole article, but from what I've seen (replacing a cursor or a while loop with a...
June 17, 2013 at 10:18 pm
Great article. For those too young to know, Empire Burlesque was a towering collaboration between Mark Knopfler and Bob Dylan that never really got the credit it deserved. That it...
June 1, 2013 at 2:27 pm
Same thing happens with SQL Server (or any other software for that matter). In 2005, in a dysfunctional government department not too far from here, an employee (let's call him...
April 20, 2013 at 11:47 pm
The underlying problem here is that poorly constructed (but otherwise interesting) questions are finding their way into QOTD without some sort of review. What is the current process for getting...
April 4, 2013 at 2:17 pm
Two things immediately spring to mind.
1) What peer review process is undertaken prior to articles like this being published?
2) Was it meant to be published yesterday (April 1)?
April 2, 2013 at 1:50 pm
What a stupid question. How can you possibly answer it with the limited details provided?
January 24, 2013 at 12:50 am
I wonder whether your friendly tax office (yah right!) might be able to supply you with some business rules around validating "tax ids". For instance can it be only X...
January 4, 2013 at 2:38 pm
Be good to know what the underlying business need is. Maybe there's a solution we haven't given you because we don't have enough information about the underlying problem. What's the...
January 3, 2013 at 7:37 pm
Does this do what you want?
SELECT my_column
FROM dbo.my_table myt
WHERE...
January 3, 2013 at 1:45 pm
hire an Editor [sic] to clean up articles before they're posted,[sic] if your [sic] authors can't correct grammer [sic] /spelling themselves
Forum posters should remain exempt from this requirement though, obviously.:-D
January 2, 2013 at 2:13 pm
Why the move away from SAN storage pools? I'm way out of my depth on this topic (no pun intended). My theory is that maybe it's just too hard to...
January 1, 2013 at 12:06 pm
A lot of people are scared off data mining and inferential statistics because of the complex and sometimes counter-intuitive maths. Here is a classic examaple that I'm still struggling to...
November 18, 2012 at 6:27 pm
@mister.magoo
both are hacks
Yes I totally agree. I was just using the @@spid as an example. My point (that if you're using obscure hacks you should explain what you're doing...
November 14, 2012 at 5:10 pm
row_number() over (order by @@spid)
I'm not against using obscure hacks, and there's always going to be a debate about the point at which you even classify something as an...
November 14, 2012 at 2:50 pm
Viewing 15 posts - 61 through 75 (of 148 total)