Home » Posts tagged 'SQL Server Management Studio' (Page 2)

Tag Archives: SQL Server Management Studio

What’s new in SQL Server 2016 installation?

1) As MS is kept increasing number of option while installation. To reduce no. of click, if setup pass Rules it will automatically moves to Next window. 2) On Server Configuration page, MS specifically ask to GRANT PERFORM VOLUME MAINTENANCE TASK permission to service account. SQL Services needs this access to perform instant file initialization … Continue reading

SQL Server Discovery Report

How can I check what all SQL server features and version are installed on my Machine ? It’s a frequently asked question. You need to study your environment, need to login each instance to check version & other details, to answer this question. Till SQL Server 2005, you have no direct solution. But Starting from … Continue reading

Refresh Intellisense in SSMS(SQL Server Management Studio) 2008 & above

Intellisense is a new feature that comes with SSMS(SQL Server Management Studio) 2008 onwards. Intellisense makes coding quite easy. But Sometimes I find that intellisense becomes stale and you start getting the wavy red lines when writing code. Even though object exists in database but Intellisense is not able to recognize it. Refreshing the cache … Continue reading

Text information from RPC trace events not displayed in Profiler

In SQL Server 2005 and later, the information in the TextData column captured for the RPC:Starting and RPC:Completed events is also available in the BinaryData column. For performance reasons, it is more efficient to include the BinaryData column and omit the TextData column, when adding these events to the trace. If the BinaryData column is … Continue reading

%d bloggers like this: