Viewing 15 posts - 4,471 through 4,485 (of 22,224 total)
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 30, 2016 at 7:01 am
Sergiy (8/30/2016)
Grant Fritchey (8/30/2016)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 30, 2016 at 4:53 am
JALLYKAMOZE (8/29/2016)
Grant Fritchey (8/29/2016)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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,...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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!
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 26, 2016 at 8:18 am
Steve Thompson-454462 (8/26/2016)
Grant Fritchey (8/25/2016)
Eirikur Eiriksson (8/25/2016)
Taking my girls (7 & 9) to New York this weekend, does anyone have a suggestion on what to do there for their age?😎
The...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 26, 2016 at 8:14 am
rarara (8/26/2016)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 26, 2016 at 7:24 am
Viewing 15 posts - 4,471 through 4,485 (of 22,224 total)