SQL Server SSMS Articles

Understanding SQL Server Query Optimization – Part 2

In the first of this four part series I gave an overview of the tools and techniques of query optimization in SQL Server. In this second part, I will talk about the process of displaying and interpreting query execution plans. I will also talk about how to generate query execution plans using SQL Server Management […]

SEQUENCE in SQL Server 2012

SQL Server 2012 (or Denali) has now arrived CTP. In this article I will look at a core new feature of SQL Server 2012 which is SEQUENCE. Well, if you are familiar with Oracle, you will already know all about this feature since it has been standard on Oracle more than 10 years I guess. […]

Are You Using SSMS effectively ?

SQL Server Management Studio is an essential tool for DBAs and developers. But are you using it effectively?  In this article, I will try examine a few tips and techniques which could well boost your efficiency using SSMS. Object Filtering The below screen is probably familiar to most DBAs – it lists all tables under […]

Automate Generate Scripts in SSMS

The SSMS allows you to manually generate scripts for a database by right-clicking a database and selected Generate Scripts and selecting what elements you wish to be scripted. However, suppose you do wish do manually perform this task, how can it be automated? Actually there is no way to automate it from SSMS, currently the […]

Change Select Top 1000 Rows value in SSMS

One seemingly minor change to SQL Server Management Studio (SSMS) in SQL Server 2008 is that by default it will only allow the visually select the top 1000 rows . This is primary to save on memory which can be drained by loading numerous rows into the SSMS visual editor. If, however, you don’t want […]

Change Edit Top 200 Rows value in SSMS

One seemingly minor change to SQL Server Management Studio (SSMS) in SQL Server 2008 is that by default it will only allow the visually edit the top 200 rows . This is primary to save on memory which can be drained by loading numerous rows into the SSMS visual editor. If, however, you don’t want […]
Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |