Table variables and row estimations – Part 1

Hello all, The subject of estimated rows vs. actual rows in plan execution has a lot of impact in query performance, and the source of these skews can be quite diverse, from outdated statistics, to incorrect sampling, or the inability of the query processor to know the value of certain variables at compile time, just…

0

Upgrading Data Quality Services (DQS) from RTM to SQL Server 2012 SP1

Hello everyone,   Today Data Quality Services (DQS) team release a post about upgrading DQS RTM to SQL Server 2012 SP1. Please refer to http://blogs.msdn.com/b/dqs/archive/2012/11/29/upgrading-dqs-to-sql-server-2012-service-pack-1-sp1-release.aspx for instructions. If have any issues using this article please let us know!   See you next time! Disclaimer: I hope that the information on these pages is valuable to you. Your…