Viewing 15 posts - 4,516 through 4,530 (of 22,211 total)
BLOB_EATER (8/18/2016)
Grant Fritchey (8/18/2016)
Jeff Moden (8/18/2016)
It also names the stats in a fashion almost identical to how SQL Server does it
BWA-HA-HA!
I was just having a conversation about statistics in...
August 18, 2016 at 10:02 am
Jeff Moden (8/18/2016)
It also names the stats in a fashion almost identical to how SQL Server does it
BWA-HA-HA!
I was just having a conversation about statistics in India last week...
August 18, 2016 at 8:36 am
Using extended events, you can capture all the connection information and suss out if there is any information that might lead to the individual user in that way. However, the...
August 18, 2016 at 7:55 am
ChrisM@Work (8/18/2016)
Brandie Tarvin (8/18/2016)
Brandie Tarvin (8/18/2016)
Ed Wagner (8/17/2016)
August 18, 2016 at 5:34 am
It means that while inserts/updates/deletes are occurring, the processing necessary to add/modify that data in that index is causing blocking of other processes. That's all. Based on this, we don't...
August 18, 2016 at 4:11 am
Yes to everything Gail says. Plus, we're not even addressing whether or not we need to worry about sample size or Full Scan on the statistics updates. Different statistics and...
August 18, 2016 at 3:59 am
Josh B (8/17/2016)
August 17, 2016 at 11:32 am
Lots of different standards on this. My one suggestion, regardless of the method you arrive at, be consistent in applying it. Doing some stuff one way, other stuff another, is...
August 17, 2016 at 9:29 am
Yep, and could come from a number of causes. One of the easiest to explain is that you have a Spool operation which is writing out to tempdb. Another is...
August 17, 2016 at 7:34 am
Chris is also offering good advice. It just wasn't there when I started typing.
August 17, 2016 at 7:31 am
Everything Lowell says.
I'm assuming that you're getting a LOOPS join, hence the estimated number of rows is 1? If so, that estimate isn't necessarily off. You need to combine that...
August 17, 2016 at 7:29 am
Brandie Tarvin (8/17/2016)
Steve Jones - SSC Editor (8/16/2016)
Brandie Tarvin (8/16/2016)
If so, what did you think about it? Was it helpful? Was it annoying? Any caveats I...
August 17, 2016 at 6:32 am
JarJar (8/17/2016)
...i've added missing indexes for all the joins possible...
based on an evaluation of the execution plans to understand where indexes are needed... I hope. Not just a blanket,...
August 17, 2016 at 6:02 am
joshua 15769 (8/16/2016)
If i use Primary keys for my query? am i properly indexing my query? sorry for these replies, I really don't know much about data degeneration and such...
Maybe....
August 17, 2016 at 5:50 am
Viewing 15 posts - 4,516 through 4,530 (of 22,211 total)