Viewing 15 posts - 3,391 through 3,405 (of 9,725 total)
mar1jxm (9/20/2013)
September 24, 2013 at 6:15 am
GAH. I keep forgetting that I can't create an index on the Extract column because the column is too big.
I guess I'll have to live with the Key Lookup after...
September 24, 2013 at 6:07 am
mister.magoo (9/20/2013)
Query 4 is RBAR on acid!
Tell me about it.
Triangular join from hell with over 500 billion rows in one section. The comment says you are linking "3" records to...
September 24, 2013 at 6:00 am
wolfkillj (9/20/2013)
In just a quick review of your DDL, I didn't see an index that would cover this query. FIDX_StagingRecID2 comes close but it doesn't include the Extract_RI column.
*headdesk*...
September 24, 2013 at 5:55 am
This is no real best practice. And most people don't worry about the Transaction logs hitting at the "same time" as the Differential or Full backups because they deliberately create...
September 23, 2013 at 11:48 am
WayneS (5/13/2013)
Brandie Tarvin (5/13/2013)
So, any ideas?Brandie, Try this out:
Wayne, YOU DA MAN!
I've been fighting a lot of fires lately and the coworker didn't quite understand everything you posted, so it's...
September 20, 2013 at 9:06 am
Here's the UPDATE statement with the Key Lookup. To be honest, it isn't taking very long to run. My biggest issue is with another part of the query. Still, I'd...
September 20, 2013 at 6:17 am
GilaMonster (9/20/2013)
Is that plan with them being run together with other stuff, or them running separately?
Running together with GO between parts of the statement. I'm about to run the two...
September 20, 2013 at 6:06 am
Sean Pearce (9/20/2013)
SSMS doesn't like it when it has to print loads of messages.
Which would explain why it did it after I set Statistics Time and Stitistics IO on AND...
September 20, 2013 at 6:05 am
Make sure you have a good recovery plan (and lots of backups) in case the upgrade goes wrong. My laptop wasn't an issue because it was my personal sandbox and...
September 20, 2013 at 5:35 am
daniel.carreira (9/20/2013)
What happens if they are not in the same domain? Which seems to be the case!?
Then you have domain trust issues. Get with your domain admins and see what...
September 20, 2013 at 5:32 am
It's not doing it all the time, which is what confuses me. And now that I think about it, I did see this behavior with SQL 2005 and 2008 on...
September 20, 2013 at 5:29 am
L' Eomot Inversé (9/19/2013)
Brandie Tarvin (9/19/2013)
If you find one, let...
September 20, 2013 at 5:26 am
NTILE?
This is the first time I've heard of that one. Thanks, Micky.
September 20, 2013 at 5:25 am
Here we go. Tables & Indexes in the below code box. Execution Plan attached.
USE [MyDB]
GO
/****** Object: Table [dbo].[tblTransactionDetail] Script Date: 09/18/2013 07:54:20 ******/
IF EXISTS (SELECT...
September 20, 2013 at 5:14 am
Viewing 15 posts - 3,391 through 3,405 (of 9,725 total)