Viewing 15 posts - 2,761 through 2,775 (of 9,725 total)
ChrisM@Work (3/27/2015)
TomThomson (3/27/2015)
dwain.c (3/26/2015)
Edit: This query shows the same thing:
IF EXISTS (SELECT 1 FROM (VALUES(CAST(1 AS BIT))) d (n))
SELECT * FROM sys.all_columns;
Which means that it has something to do...
March 27, 2015 at 7:51 am
ScottPletcher (3/25/2015)
I don't see a clustered index on the table (but maybe I just missed it).
There isn't one. I don't know why they don't have one, except that they really...
March 27, 2015 at 6:04 am
So here's a tale from my workplace that will change up the conversation...
I was having a Really Bad Day last week. I was trying to send an email to a...
March 27, 2015 at 5:57 am
Luis Cazares (3/26/2015)
March 27, 2015 at 5:10 am
GilaMonster (3/25/2015)
spaghettidba (3/24/2015)
What I find disturbing is the assumption that men are sexist and if they say they don't do that it's just "not-meing".
That's certainly not what I said...
March 27, 2015 at 4:29 am
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
Viewing 15 posts - 2,761 through 2,775 (of 9,725 total)