Tuesday, June 26, 2012

How to use SQL Server Management Studio (SSMS) effectively

SSMS is the primary development tool use by SQL Server professionals to work with SQL Servers. This has introduced in SQL Server 2005 and it has evolved with rich features till SQL Server 2012. In this article I discuss some of the valuable features of SSMS which increases the productivity and efficiency of users. The target audience would be any user (beginner to intermediate) who deals with SSMS to do various tasks with SQL Servers. 
sql-server-performance.com
at No comments:
Subscribe to: Posts (Atom)

How to interpret Disk Latency

I was analyzing IO stats in one of our SQL Servers and noticed that IO latency (Read / Write) are very high. As a rule of thumb, we know tha...

  • Stored procedure taking long time to execute
    This can happen due to many factors like lack of indexes, out of dates statistics, if it returns a large number of records, etc. I observed...
  • Identifying slow running queries
    This post is for SQL Server Database Administrators who have find difficulty in some situations when identifying slow running queries. The D...
  • How to get database sizes
    There are several ways to get database sizes in a server. Following three system tables has the information to get database sizes. sys . sy...