Viewing 15 posts - 61 through 75 (of 8,416 total)
KTD (9/6/2013)
Your version of the query ran in 30 seconds without any high disk latencies observed.
Good to know, thanks. Just for a bit of fun (and because other people might...
September 6, 2013 at 8:42 am
Erland Sommarskog (9/6/2013)
September 6, 2013 at 3:22 am
KTD (9/4/2013)
However the new server creates massive IO and doesn't make use of some indexes that it should be using.
The first thing to say is that your index on RecordDate...
September 5, 2013 at 8:21 pm
Grant Fritchey (8/31/2013)
Cool. That relieves a lot of pressure. I haven't taken a single Microsoft certification. Now, since the only one I respect is gone, I don't have to.
+1
August 31, 2013 at 2:58 pm
Jack Corbett (8/26/2013)
August 26, 2013 at 7:13 pm
Grant Fritchey (8/16/2013)
I was just going to look that up because I thought it was one of the upgrades in 2014. Thanks.
No worries 🙂
August 16, 2013 at 6:04 am
iBar (8/13/2013)
So what is the alternate option available to avoid excessive reads from table in every query and in many SPs wherever I need to use this logic?
Correct indexing can...
August 16, 2013 at 5:21 am
karthik M (7/16/2013)
Does SQL 2014 still support "Quirky Update" ? or is this hole sealed with "QuickFix" ? 🙂
No-one knows, because SQL Server 2014 has not been released yet. It...
August 16, 2013 at 4:36 am
Jeff Moden (8/15/2013)
While I've found some workarounds for it, it seems bloody incredible to me that you cannot rebuild a partitioned index at the partition level in an online fashion.
Online...
August 15, 2013 at 10:12 pm
Good stuff, Simon.
If people want to see the impact more clearly, pushed non-SARGable predicates can be separated out into a separate Filter operator by enabling undocumented trace flag 9130 (OPTION...
August 15, 2013 at 10:01 pm
ChrisM@Work (6/25/2013)
Absolutely. Paul, you don't often post on ssc these days...
It's nothing personal, I just sort of drifted away when I found there weren't often "my sort of questions" around....
June 25, 2013 at 2:24 am
Jeff Moden (6/24/2013)
Couple of other good ones on the same subject...http://sqlinthewild.co.za/index.php/2010/02/18/not-exists-vs-not-in/
http://sqlinthewild.co.za/index.php/2010/03/23/left-outer-join-vs-not-exists/
Oh yes, of course. Thanks!
June 24, 2013 at 1:13 pm
David Moutray (6/24/2013)
I will be particularly interested to play around with using NOT EXISTS logic where we currently use WHERE IS NOT NULL.
If you feel like reading up on it...
June 24, 2013 at 12:42 pm
The only place in Books Online I can think of that mentions that the type of a literal NULL is integer, is in the ISNULL topic.
The following text was added...
June 24, 2013 at 9:12 am
Viewing 15 posts - 61 through 75 (of 8,416 total)