Viewing 15 posts - 2,986 through 3,000 (of 22,202 total)
You don't think that processing scans isn't going to cost you more in...
September 10, 2018 at 5:02 am
September 8, 2018 at 11:30 pm
I don't have a lot of faith in certificates. We've interviewed candidates...
September 7, 2018 at 8:50 am
September 7, 2018 at 7:21 am
Availability groups and read only secondaries are, I think, supported on managed instances. That would be a solution.
September 7, 2018 at 5:24 am
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...
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...
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...
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.
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...
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.
September 7, 2018 at 2:42 am
Man, I'm sorry. I've got nothing. You might be looking at some kind of bug.
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...
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...
September 5, 2018 at 2:00 am
And once you do what Grant instructed, if you still get the error, you...
September 4, 2018 at 7:24 am
Viewing 15 posts - 2,986 through 3,000 (of 22,202 total)