Viewing 15 posts - 4,471 through 4,485 (of 22,219 total)
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
Look to extended events as a way of ensuring you'll capture exactly what you need in a controlled fashion.
"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 6:43 am
The 1000 pages is just a guideline. If the number of pages is less than an extent (8 pages), it can be completely ignored, regardless of the level of fragmentation....
"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 6:42 am
No, it's unlikely that the statistics on tables that are emptied and reloaded should have been updated before they were emptied and reloaded. They would naturally get updated through that...
"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 6:40 am
Please, please, please, listen to what Gail is saying.
If the log is full and you're doing log shipping, make darned sure that you're shipping the log often enough. If it's...
"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 6:26 am
GilaMonster (8/26/2016)
Jeff Moden (8/26/2016)
Grant Fritchey (6/9/2015)
There are places where partitioning can, and does, improve performance.
Apologies for the year late response and I hate to be contrary but everywhere I've...
"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 6:21 am
Viewing 15 posts - 4,471 through 4,485 (of 22,219 total)