Viewing 15 posts - 2,746 through 2,760 (of 9,707 total)
The only two things that changed in the Execution Plan was the complexity of my variable calls (expected) and the CompileMemory went from 256 to 240. Everything else is the...
March 24, 2015 at 7:42 am
GilaMonster (3/24/2015)
Could we get a scrubbed query that matches the columns in the table?
Sorry. I should have thought about that. Here it is.
DECLARE @YrMo INT,
@YrMoStrg CHAR(6) = (SELECT CONVERT(CHAR(6),DATEADD(m,-1,GETDATE()),...
March 24, 2015 at 7:37 am
djj (3/24/2015)
Brandie,A side note not related to the problem. What if you use the following?
@YrMoStrg CHAR(6) = CONVERT(VARCHAR(6), DATEADD(m,-1,GETDATE()), 112)
Oh, will you please stop making sense? I...
March 24, 2015 at 7:12 am
Scrubbed table structure and execution plan attached. I have not included sample data yet because it will take a while for me to scrub it. Let me know if this...
March 24, 2015 at 7:09 am
These are awfully flat jars.
I love history. "We jousted on a pile of garbage."
March 24, 2015 at 5:57 am
I think the point I was trying to make has been missed. Maybe I didn't explain myself very well, so I'm going to try again.
I'm not trying to bash anyone...
March 23, 2015 at 10:29 am
Eirikur Eiriksson (3/23/2015)
GilaMonster (3/23/2015)
Eirikur Eiriksson (3/22/2015)
Now where is the Crystal Ball?😎
If you find it, I think this query can only be done if the WITH (CrystalBall) join hint is used.
http://www.sqlservercentral.com/Forums/Topic1670606-391-1.aspx
Thanks...
March 23, 2015 at 9:59 am
xsevensinzx (3/22/2015)
Speaking on getting hired and the job market, here is an interesting read:http://lifehacker.com/the-programming-skills-jobs-and-company-types-that-pa-1692152608
Wait... 11-15 years of experience get paid less than up to 10 years of experience?
That seems a...
March 23, 2015 at 5:27 am
TomThomson (3/20/2015)
Alvin Ramard (3/20/2015)
Maybe it's time to reboot the server in which life is running.
Oh God, would that mean I have to go back to square one and make all...
March 23, 2015 at 5:21 am
So Scott Adams stepped into the gender bias debate and he has some interesting conclusions. I thought you all might like to read this.
March 20, 2015 at 9:16 am
BWFC (3/20/2015)
Brandie Tarvin (3/20/2015)
I'm trying to figure out if this one is real or not. Anyone seen this? (click the link on the tweet).
Wow. Just ... WOW.
March 20, 2015 at 7:33 am
Paul Bradshaw (3/19/2015)
I pull it out, converting it to varchar, into...
March 20, 2015 at 7:13 am
I'm trying to figure out if this one is real or not. Anyone seen this? (click the link on the tweet).
March 20, 2015 at 6:44 am
I am so proud of myself. I learned how to do substrings and get month names out of C#.net all by my lonesome today.
Well, mostly. I had to have a...
March 19, 2015 at 12:42 pm
spaghettidba (3/19/2015)
TomThomson (3/19/2015)
spaghettidba (3/19/2015)
If you think it's not possible, that you are different, just read this article: http://www.bu.edu/today/2014/bu-research-riddle-reveals-the-depth-of-gender-bias/
What is really surprising...
March 19, 2015 at 12:25 pm
Viewing 15 posts - 2,746 through 2,760 (of 9,707 total)