Viewing 15 posts - 2,506 through 2,520 (of 22,214 total)
It sounds like bad parameter sniffing, but you're going to have to get the plans to be sure. Without the plans, you can look at the statistics for the column(s)...
June 25, 2019 at 11:48 am
The best tool for the job, if you want detailed query behaviors, is Extended Events. They are the least cost way to gather detailed query metrics. You only really need...
June 25, 2019 at 11:39 am
Be honest, was this one of you? https://www.newsweek.com/drunk-poland-soviet-tank-1444475
I was on Poland recently, but no one let me drive a tank... as far as I can recall.
June 21, 2019 at 1:33 pm
To really deal with this, you need to get some input and insight into the load process. I know you say you have zero control over it, but, that's where...
June 21, 2019 at 12:30 pm
Let's start with the last question first, yes, an index rebuild will reduce the level of fragmentation.
First question, is fragmentation of indexes bad?
Well, probably not, no. Fragmentation hurts in a...
June 21, 2019 at 12:19 pm
I'd need to see more specifics around this. There's nothing magically or uniquely bad or dangerous about a LEFT JOIN when manipulating data, so there's got to be more to...
June 10, 2019 at 1:09 pm
Defining "used" may lead you to different ways of checking this. I would first get this definition so that you can understand what you then need to do to ensure...
June 10, 2019 at 1:07 pm
Oh, god. It's really Dynamics. People were cracking jokes about this on Twitter.
Yeah, there is literally no easy way around this. Microsoft purchased this horrible piece of software and then...
June 7, 2019 at 10:19 am
The only one of those that offers the slimmest of hopes is the log explorer. However, you better not have the log on simple recovery or that's a lost hope...
June 6, 2019 at 7:40 pm
I will talk with developers to understand how the integrity of the data is maintained through the code without foreign keys. thank you for all the responses.
It won't...
June 6, 2019 at 7:36 pm
You're missing Availability Groups and then all the third party solutions through software and hardware. Also not mentioned, just backing up the database on one server and restoring to another....
June 5, 2019 at 12:45 pm
You are in a world of pain. There is literally no easy way out. At all. So very sorry.
If, and it's probably a huge "IF", you are lucky and they...
June 5, 2019 at 12:41 pm
Query said:
...WHERE 1=0...
Comment in front of the query said:
-- WHERE 1 = 0
No explanation for it at all.
June 5, 2019 at 12:23 pm
I have a bit of bittersweet news. After more than a decade of coaching youth soccer I am finally hanging up the whistle (although I never actually use one...
June 3, 2019 at 5:55 pm
Just saw a joke.
Coach calls over little 8 yo player:
Coach: You know that I substitute everyone so you call get some time to play right?
Player: Yes
Coach: And you know we're...
June 3, 2019 at 5:52 pm
Viewing 15 posts - 2,506 through 2,520 (of 22,214 total)