Viewing 15 posts - 3,016 through 3,030 (of 22,227 total)
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 Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 7, 2018 at 5:22 am
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 Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 7, 2018 at 2:57 am
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 Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 7, 2018 at 2:51 am
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 Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 7, 2018 at 2:49 am
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 Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 7, 2018 at 2:46 am
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" Author of:
- Theodore Roosevelt
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 7, 2018 at 2:42 am
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 Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 5, 2018 at 6:45 am
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 Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 5, 2018 at 2:12 am
You can query the sys.sql_expression_dependencies to find that information. Here's documentation on that. I would also suggest you look into setting up a continuous integration process for your...
"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
September 5, 2018 at 2:00 am
And once you do what Grant instructed, if you still get the error, you...
"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
September 4, 2018 at 7:24 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
September 4, 2018 at 7:22 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
September 4, 2018 at 7:20 am
Try it with NORECOVERY instead of RECOVER in the restore. leave it in the recovering state until the differential is done.
"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
September 4, 2018 at 5:13 am
First, a bit of clarity, the title says "Indexing a character column". Then you type that you want "Indexing on Numeric column types" and then you say that the majority...
"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
September 4, 2018 at 3:25 am
Profiler has been deprecated for a long time. However, there is no indication that it will be removed from the product any time soon. That said, don't use it. Extended...
"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
September 3, 2018 at 3:14 am
Viewing 15 posts - 3,016 through 3,030 (of 22,227 total)