Viewing 15 posts - 751 through 765 (of 5,843 total)
Jeff Moden (9/15/2016)
TheSQLGuru (9/15/2016)
http://www.red-gate.com/products/dba/sql-clone/
https://www.simple-talk.com/sql/sql-tools/clone-sweet-clone-database-provisioning-made-easy/
Tell Richard...
September 16, 2016 at 6:14 am
I don't think you need to shrink it to share it with a bunch of developers efficiently. Go get a copy of Redgate's SQL Clone.
http://www.red-gate.com/products/dba/sql-clone/
https://www.simple-talk.com/sql/sql-tools/clone-sweet-clone-database-provisioning-made-easy/
Tell Richard I sent you!...
September 15, 2016 at 8:28 pm
Late to the party, but I have had very good success with value-driven-index-seek based deletes (where possible) too.
September 15, 2016 at 1:56 pm
j-1064772 (9/15/2016)
Eirikur Eiriksson (9/15/2016)
Here is a simple test harness which you can use
Again, another example of multiple senior contributors moving the goal posts farther away to better explore the subject,...
September 15, 2016 at 8:22 am
Check to see if anything is running currently before you start the restore. Wait a bit if they are. Decide if you want to kill them and force the restore...
September 14, 2016 at 3:30 pm
Sheesh, I missed that too, but based on the OPs code they would certainly have been able to get the right aggregated output thankfully! 🙂
September 14, 2016 at 6:47 am
Mike Scalise (9/14/2016)
I've been looking into log-shipping since, honestly, you have me a little scared about the potential performance impacts of mirroring and transactional replication.
It seems to be a...
September 14, 2016 at 6:45 am
sqlenthu 89358 (9/14/2016)
September 14, 2016 at 6:41 am
CROSS APPLY VALUES #FTW!! Nicely done Jason. 🙂
September 13, 2016 at 3:02 pm
Run sp_whoisactive and get some of the additional stuff it can show you and see if anything makes sense then.
September 13, 2016 at 3:01 pm
drew.allen (9/12/2016)
TheSQLGuru (9/12/2016)
ROWS is (almost ?) ALWAYS offers MUCH better performance than RANGE! Try your best to use ROWS when possible.
ROWS won't work for the overall total here, because the...
September 12, 2016 at 3:00 pm
Sounds like you know what you are doing Steve. Kudos for you! Do note that we don't get a whole lot of that on these forums (because if they did...
September 12, 2016 at 11:58 am
SQL Diagnostic Manager offers lots of options for showing you what queries are eating various resources.
September 12, 2016 at 11:51 am
Viewing 15 posts - 751 through 765 (of 5,843 total)