Viewing 15 posts - 2,806 through 2,820 (of 22,202 total)
December 19, 2018 at 5:23 am
If you're using Azure SQL Database I'd look into the COPY DATABASE command in Powershell. That's going to let you capture a quiet copy of the database and then you...
December 19, 2018 at 4:21 am
Look through the system views and you ought to be able to figure it all out. sys.dm_exec_query_stats has a number of values like sql_handle for finding statements and the plan_handle...
December 19, 2018 at 4:15 am
So, automatically killing long running queries or queries that are blocking is a very bad idea. Can it be done? Certainly. There are a number of ways you could do...
December 18, 2018 at 6:28 am
Or, since we're talking 2016, there's always:
ALTER DATABASE SCOPED CONFIGURATION CLEAR PROCEDURE CACHE
However, same rules apply. Don't do this in production.
You can also try using...
December 18, 2018 at 6:10 am
December 17, 2018 at 1:09 pm
If all the data has to be returned all the time, the only way to speed that up is to spend lots and lots of money on hardware. There is...
December 17, 2018 at 5:42 am
You have an 8gb server (half my laptop by the way) and a query that moves ALL the data. How big is this database? If you're moving all the data...
December 17, 2018 at 5:14 am
It would be a lot easier to give you detailed answers with example queries, structure, and execution plans for the existing queries you're running. Otherwise, we're making guesses here.
December 17, 2018 at 5:11 am
Are you in an Azure Virtual Machine (in which case, it's just Windows & SQL Server and should behave the same as a local instance of SQL Server) or are...
December 17, 2018 at 5:07 am
100% agreement with Joe. You should be following best practices and writing the code correctly including object ownership. However, Azure SQL Database is SQL Server. If you have a valid...
December 14, 2018 at 1:43 am
The way I'd do it is to create a copy of the production database, then export that to a BACPAC. The reason to do two steps is because the BACPAC...
December 14, 2018 at 1:41 am
Agree with everything Lynn said. Emphasizing, this: December 13, 2018 at 2:04 am
December 12, 2018 at 1:50 am
That's a lot of down time. Doing a side-by-side install would allow you to set up mirroring to migrate between the servers minimizing downtime. Further, that method means that you...
December 11, 2018 at 1:57 am
Viewing 15 posts - 2,806 through 2,820 (of 22,202 total)