Simon's SQL

SQL,DBA,tuning,Trouble Shooting,Performance

Archive for January, 2017

Source Control in SQL Server Management Studio (SSMS)

Posted by Simon Cho on 01/31/2017

enable the Visual studio ssms team explorer : C:\Program Files (x86)\Microsoft SQL Server\130\Tools\Binn\ManagementStudio\ssms.pkgundef

 

https://blogs.technet.microsoft.com/dataplatforminsider/2016/11/21/source-control-in-sql-server-management-studio-ssms/

Advertisements

Posted in Common | Tagged: | Leave a Comment »

SQL Server Column store row group investigation

Posted by Simon Cho on 01/10/2017

https://blogs.msdn.microsoft.com/sqlcat/2015/08/17/sql-2016-columnstore-row-group-merge-policy-and-index-maintenance-improvements/

https://msdn.microsoft.com/en-us/library/dn935008.aspx

 

Posted in Common | Tagged: | Leave a Comment »