Viewing 15 posts - 2,746 through 2,760 (of 9,715 total)
ChrisM@Work (3/27/2015)
Brandie Tarvin (3/27/2015)
ChrisM@Work (3/27/2015)
Brandie Tarvin (3/27/2015)
dwain.c (3/26/2015)
ChrisM@Work (3/26/2015)
March 27, 2015 at 8:26 am
ChrisM@Work (3/27/2015)
Brandie Tarvin (3/27/2015)
dwain.c (3/26/2015)
ChrisM@Work (3/26/2015)
March 27, 2015 at 8:16 am
ChrisM@Work (3/27/2015)
Brandie Tarvin (3/27/2015)
I was having a Really Bad Day last week. I was trying to send an...
March 27, 2015 at 8:14 am
ScottPletcher (3/27/2015)
Brandie Tarvin (3/27/2015)
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...
March 27, 2015 at 8:10 am
dwain.c (3/26/2015)
ChrisM@Work (3/26/2015)
March 27, 2015 at 7:55 am
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
Viewing 15 posts - 2,746 through 2,760 (of 9,715 total)