Tag Archives: ssms

How to operate multiple objects in SSMS (F7)

While working on a service restoration, we had to resume data movement on 100+ random databases. Generating TSQL is the best option but UI will be very quick and reliable. Biggest challenge with SSMS UI will be to perform the … Continue reading

Posted in SQL, SQL Server, SSMS, Uncategorized | Tagged , , | 2 Comments

Install SQL Server Management Studio (SSMS)

Now SSMS (SQL Server Management Studio) can be installed as a stand alone, need not download full version only for SSMS. SSMS can be downloaded and installed from: https://msdn.microsoft.com/en-us/library/mt238290.aspx -Vijred

Posted in Uncategorized | Tagged , , | Leave a comment

Avoid Next Line character in SSMS results

Many a time we copy data from SQL Server Management Studio results pane into Excel while preparing reports and analyzing the data. One of the most common problem is handling Next Line characters. These characters disrupts the indentation of data … Continue reading

Posted in Productivity, SQL Server, SSMS | Tagged , , , , | Leave a comment

SSIS Error, Solution: This error is thrown by Connections collection when the specific connection element is not found

Typically SSIS will throw this error if a connection used by SSIS package is either deleted or renamed. Most of the time it will be a human error, when we copy SSIS package and modify the package, renaming and deleting … Continue reading

Posted in SQL, SQL Error, SSIS | Tagged , , , | 1 Comment

Multiple SQL Server Query results in single Result set

Often I have to run same query against multiple Servers for analysis and club all results for presentation. I come across simple option which allows to do it all in one go… • View Registered Servers (Ctrl+Alt+G) • Create new … Continue reading

Posted in Productivity, SQL | Tagged , , , | Leave a comment

Knowledge Share 2014-06

• Can I change SQL Server Name/ Instance Name: o Yes, you can change SQL Server name. Especially when you rename your server name, it is good option to change your SQL Server name. o http://msdn.microsoft.com/en-us/library/ms143799.aspx is the article which … Continue reading

Posted in knowledge, SQL | Tagged , , , , | Leave a comment

How Statistics impact the performance of SQL Query

In this article I will run through a simple demo which explains how STATISTICS impact the performance. During this Demo, I will use the Number of Logical Reads as performance indicator (More Logical Reads indicates Performance Degrade) Created a new … Continue reading

Posted in Performance, Script, SQL | Tagged , , , , , , | 1 Comment

SQLServerCentral script library in SSMS

Now, you can search for scripts in SQL Server Management studio. the add-on is very good. Only Challenge I see is the performance as of now, hope it will be addressed soon! Reference: http://www.sqlservercentral.com/articles/SQLServerCentral/110671/#.U3VdqGdp5HM.facebook -Vijred

Posted in Productivity, SQL | Tagged , , | Leave a comment