Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with Search options user 21551

SQL Server 2012 (major build version 11.00.xxxx). Please also tag sql-server.

6
votes
I think that mirroring is not the the best solution in this scenario, and discontinuation announcement is not even the main reason, especially if you're planning to maintain the test environment only …
answered Feb 27 '15 by Adam Luniewski
1
vote
How about sp_estimate_data_compression_savings? It allows you to estimate the gain from compression BEFORE you compress the table, but it's quite accurate.
answered Sep 20 '13 by Adam Luniewski