Viewing 15 posts - 3,046 through 3,060 (of 22,219 total)
"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 15, 2018 at 5:26 am
Piling on.
Focus on gathering metrics right now. What are your wait statistics like? Is the server waiting on memory? Which queries are waiting? What is making those...
"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 15, 2018 at 5:18 am
Are you partitioning in order to take advantage of the data management aspects of partitioning (rolling windows, that sort of thing) or are you attempting to partition for performance. If...
"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 15, 2018 at 5:12 am
I don't know of a video along the lines of what you're looking for. However, I can make one huge recommendation. Learn Query Store. It's your best friend in 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 15, 2018 at 5:10 am
Can I restore over a DB that is in an offline state (using...
"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 13, 2018 at 9:17 am
I have examples in my book.
It's actually hard to get these things. You won't see them very often, The optimizer almost seems to have a bias against...
"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 9, 2018 at 2:02 pm
However I got one question ...
"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 8, 2018 at 7:58 am
Cheers, so basically build it simple, and if you see performance issues, then...
"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 8, 2018 at 7:49 am
The Cumulative Updates are cumulative. So you only need to install the SP2 and the latest CU.
"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 8, 2018 at 6:58 am
"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 8, 2018 at 6:57 am
Looping a procedure like that (which is possible, look up a WHILE loop), will lead to all sorts of problems. I wouldn't recommend it at all. Instead, from what you're...
"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 8, 2018 at 6:49 am
Just starting out, stick as much as possible to straight T-SQL. Then, as you start to see odd bits of behavior or weird requirements or odd structures, you can start...
"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 8, 2018 at 6:45 am
I've had this discussion with a lot of people, MCMs, MVPs, consultants and gurus. The general consensus is pretty straight forward. If you're not experiencing I/O waits and bottlenecks, leave...
"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 8, 2018 at 6:32 am
"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 8, 2018 at 6:23 am
"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 7, 2018 at 9:26 am
Viewing 15 posts - 3,046 through 3,060 (of 22,219 total)