Archives: January 2014
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
@@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.
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