Viewing 15 posts - 4,456 through 4,470 (of 22,211 total)
You have two different delete statements, each one using a different WHERE clause, but both on the same table. So, first up, what other statements are involved with the transaction?...
August 30, 2016 at 10:30 am
If you're getting different execution plans, then it has to be differences between the servers and/or databases that is causing it. The trick is identifying the differences. Most of the...
August 30, 2016 at 10:24 am
Sergiy (8/30/2016)
Grant Fritchey (8/30/2016)
That's if they add shrink file. That wasn't in your original answer. You just talked about the truncate, which won't result in freeing space on the drive.
Probably...
August 30, 2016 at 7:01 am
Sergiy (8/30/2016)
Grant Fritchey (8/30/2016)
August 30, 2016 at 6:04 am
Sergiy (8/29/2016)
During reindexing the log grows until it runs out of free space on the disk.
Then it fails and stops.
The backup job comes couple of hours later, cleans...
August 30, 2016 at 4:53 am
JALLYKAMOZE (8/29/2016)
Grant Fritchey (8/29/2016)
August 30, 2016 at 4:51 am
TheSQLGuru (8/29/2016)
Possible causes:3) Parameter sniffing issue. Crack open the actual execution plan xml and check the parametercompilevalue and see how that compares to the actual execution value for parameter inputs.
Or,...
August 29, 2016 at 10:05 am
You're saying parameters and variables. Let's get real clear, because it matters. Parameters are values defined with the CREATE statement for a stored procedure, as part of the preparation of...
August 29, 2016 at 10:04 am
dan.brown1 (8/29/2016)
SQL server version,configuration is similar.
That's most likely the issue, similar.
You need to validate that the ANSI connection defaults are the same, same cost threshold for parallelism, same...
August 29, 2016 at 6:31 am
Make sure you're up to date on service packs and cumulative updates. It's pretty unlikely such a fundamental bug is unaddressed by Microsoft. There's be a lot more yelling and...
August 29, 2016 at 6:26 am
bruce the wiesel (8/29/2016)
https://msdn.microsoft.com/en-us/library/ee342167(v=sql.120).aspx
That's from Policy Based Management. It does have some examples that are similar to the BPA, but not complete the way the BPA was.
SQLCop from the LessThanDot.com...
August 29, 2016 at 6:24 am
That's a great idea for an article, maybe one that can be maintained over time. Unfortunately, it's not going to stop, or probably even slow, the "just give me the...
August 29, 2016 at 6:20 am
Luis Cazares (8/26/2016)The only problem, is that I don't want to spend more time on that site.
DING DING DING!
WINNER!
August 26, 2016 at 11:17 am
WayneS (8/26/2016)
Grant Fritchey (8/25/2016)
Lynn Pettis (8/25/2016)
Got to the following from a LinkedIn email. Not sure about a few of the answers.https://intellipaat.com/interview-question/sql-interview-questions/
I posted a comment. I couldn't help it.
As did...
August 26, 2016 at 10:56 am
Phil Parkin (8/26/2016)
Steve Thompson-454462 (8/26/2016)
Grant Fritchey (8/25/2016)
Eirikur Eiriksson (8/25/2016)
August 26, 2016 at 8:18 am
Viewing 15 posts - 4,456 through 4,470 (of 22,211 total)