Forum Replies Created
Viewing 15 posts - 3,001 through 3,015 (of 22,219 total)
-
RE: Fast Database Clone
Jeff is dead on accurate. That is the fastest and safest way I know to get the job done.
However, I do know a way that is just as...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: CPU time > Elapsed time
It really depends on how you're capturing the elapsed time. There is a way in extended events to only capture the execution time of a procedure, skipping the compile time...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Ideas for setting Azure SQLmanaged instance for transaction and reporting
Jeff Moden - Sunday, September 9, 2018 10:18 AM"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Ideas for setting Azure SQLmanaged instance for transaction and reporting
ebooklub - Friday, September 7, 2018 12:54 PM"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Are the posted questions getting worse?
Jonathan AC Roberts - Friday, September 7, 2018 7:54 AM"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Are the posted questions getting worse?
Sergiy - Friday, September 7, 2018 7:01 AMHere is the screenshot of a fresh job description.
Seems like ticks all the boxes.
🙂
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance TuningRE: Ideas for setting Azure SQLmanaged instance for transaction and reporting
Availability groups and read only secondaries are, I think, supported on managed instances. That would be a solution.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance TuningRE: Question about administration of your databases on Azure
It completely depends on what we're talking about when we say "Azure". So, if by Azure you mean Virtual Machines managed on Azure, it's just SQL Server instances and everything...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance TuningRE: Capture query which takes longer than 20 seconds and send email from SQL Server
Second vote for Redgate SQL Monitor. That will do everything you're asking for.
However, if you really want to build it yourself, look to Extended Events. You can use...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance TuningRE: Question about memory
Generally SQL Server will consume every bit of memory it can and hold on to it. That your'e seeing it go up and down is more concerning than that it...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance TuningRE: sql server documentation tools
Sorry. I don't know of a good and free tool. If you want a good tool, Redgate SQL Doc is the way to go.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance TuningRE: Report runs faster after Backup and Restore
Nothing in the backup and restore would make the query run faster. However, what you're likely seeing is the result of a new compilation of the query, possibly with different...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance TuningRE: In-place upgrade to SQL server 2017
For the tools, SQL Server 2017 has separated the tools install from the server install. If you need the new tools, you have to track them down separately.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance TuningRE: Index statistic is empty - how is this possible?
Man, I'm sorry. I've got nothing. You might be looking at some kind of bug.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance TuningRE: Index statistic is empty - how is this possible?
The only way that stats won't exist is if there is no data in the table when the index gets created AND you have turned off auto-update stats AND you...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance TuningViewing 15 posts - 3,001 through 3,015 (of 22,219 total)
