Viewing 15 posts - 46 through 60 (of 216 total)
GilaMonster (9/20/2012)
David Moutray (9/20/2012)
Somehow I think SELECT LEN('a') is too simple for Dave's competition. There must be some really obscure way of returning a 1.
I can think of several...
September 20, 2012 at 1:09 pm
Somehow I think SELECT LEN('a') is too simple for Dave's competition. There must be some really obscure way of returning a 1.
I'm wracking my brain trying to think of...
September 20, 2012 at 12:21 pm
Now, now, Gentlemen. :rolleyes:
The questions posted here are from today's blog by Pinal Dave on SQLAuthority. You can ask any question, but perhaps some of us would like to...
September 20, 2012 at 12:08 pm
LOL :hehe:
That reminds me of a Dilbert cartoon where an applicant is interviewing with the Pointy-Haired Boss:
Applicant: "But enough about me, let's talk about how I can help you...
September 20, 2012 at 8:13 am
Some of the customer's irritation may have come from waiting for each cascading parameter to populate a list of options after selecting the previous parameter.
So, another solution might be to...
September 20, 2012 at 7:38 am
Here are the IO/timing results:
----------------- Dwain
Table 'Worktable'. Scan count 368, logical reads 101966, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads...
September 20, 2012 at 4:27 am
Very interesting problem! Thank you for posting it. There are some subtle "real-world" quirks in here that make this potentially quite complex.
Dwain is correct, posting some SQL Code...
September 19, 2012 at 9:08 pm
I, too, am interested to hear the answer you gave. I am not primarily a report developer. So, I would have said something along the lines of, "Take...
September 19, 2012 at 2:09 pm
If you suspect parameter sniffing, add OPTION (RECOMPILE) to the end of the query. That causes the query to be "recompiled" every time it executes. I don't recommend...
August 27, 2012 at 10:36 pm
SQL Kiwi (6/8/2012)The cause of your occasional problems is that SELECT...INTO is a bit of an unusual statement: it executes in two parts. You can't see this directly in...
June 24, 2012 at 11:48 am
I'm so glad that we have sites like hypertexttransferprotocol://StructuredQueryLanguageServerCentral.CommercialDomain, with people like you, to help keep us from making these awful mistakes!
All hilarity aside, the point is that your writing...
June 7, 2012 at 1:02 pm
Fair enough. You should do the work. I should do the work. However, we should not make others do the work. Define your acronyms where you...
June 5, 2012 at 9:49 am
decern
Discern
Sorry. Stuff like that bothers me.
June 5, 2012 at 9:36 am
An acronym is always unknown to someone. Think of the new guy who might never have heard or seen it before.
Also, Google is fallible. There are many acronyms...
June 5, 2012 at 9:34 am
Nope, that wasn't me either.
Dude, you are really making me look bad. OK, OK, I admit it was at a PASS party and I might have had a few...
June 5, 2012 at 9:01 am
Viewing 15 posts - 46 through 60 (of 216 total)