Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: January 2014

SQL Server – Displaying line numbers in Query Editor – SSMS

You can enable line numbers to be displayed in SSMS Query Editor. This is extremely useful when working on a large module.

To enable line numbers in Query Editor windows, follow below steps:

Step1: Go to Tools > Options

Step2: In the Options dialog box navigate to Text Editor >… Read more

0 comments, 401 reads

Posted in SQL and Me on 20 January 2014

SQL Server – Difference between @@CONNECTIONS and @@MAX_CONNECTIONS

@@MAX_CONNECTIONS in SQL Server returns maximum number of simultaneous user connections allowed. Maximum user connections allowed by SQL Server by default is 32,767; this number also depends on application and server hardware limits. This cam also be configured at server-level to avoid too many connections.

@@CONNECTIONS returns number of connection… Read more

0 comments, 567 reads

Posted in SQL and Me on 13 January 2014

SQL Server – Different ways to check Recovery Model of a database

A Recovery Model is property of a database which control how transaction log is maintained. SQL Server supports SIMPLE, FULL and BULK-LOGGED recovery models.

There are multiple ways to check recovery model of a database in SQL Server.

1. Using SQL Server Management Studio:

Right click on Database in… Read more

1 comments, 1,401 reads

Posted in SQL and Me on 6 January 2014