Viewing 15 posts - 4,021 through 4,035 (of 22,213 total)
You can use replication. Microsoft has great documentation on how to set it up. That's about your only option for going Azure SQL Database from an on-premises database....
February 25, 2017 at 5:59 am
It's going to halt the execution.
I'd put extended events on the job to monitor for procedure start and finish. If you have an unmatched pair, you've at least...
February 25, 2017 at 5:54 am
I assume the SELECT INTO...
February 25, 2017 at 3:57 am
February 24, 2017 at 11:38 am
February 24, 2017 at 9:04 am
February 24, 2017 at 6:43 am
Archiving means moving from one location to another for long term storage (possibly aggregation, possibly other stuff, that really depends on your business needs, I can't define this for you)....
February 24, 2017 at 6:04 am
If you need to do this regularly, building out scripts, a Powershell app, or even SQL Server Integration Services (SSIS), would be the best way to get it done. Using...
February 24, 2017 at 6:01 am
Azure SQL Database has a DMV sys.dm_db_wait_stats, which is absolutely wonderful. It will show you wait stats per database. However, the boxed product doesn't have that DMV. The one way...
February 24, 2017 at 5:59 am
A couple of things you can do to enhance performance on the data load. You can break up the files into 60 chunks to coincide with the 60 processes that...
February 24, 2017 at 5:57 am
That said, is there ever any case or reason why one...
February 24, 2017 at 5:47 am
February 23, 2017 at 12:04 pm
John has it nailed. If you put in a RECOMPILE hint, nothing gets cached because there's no need since each execution gets a new compilation.
Why would Optimize for...
February 23, 2017 at 11:34 am
You're going to want the RECOMPILE hint to be after the WHERE clause as defined in the documentation.
sp_executesql will attempt to reuse execution plans. Most of...
February 23, 2017 at 8:02 am
Viewing 15 posts - 4,021 through 4,035 (of 22,213 total)