Viewing 15 posts - 4,021 through 4,035 (of 22,211 total)
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
Nice to hear that people like the product.
DISCLOSURE: I work for Redgate.
My favorite stuff is the compression. It's way better than native. Also our automation around...
February 23, 2017 at 7:31 am
February 23, 2017 at 7:07 am
Viewing 15 posts - 4,021 through 4,035 (of 22,211 total)