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...
2014-01-20
308 reads
SQL and Me
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...
2014-01-20
148 reads
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...
2014-01-13
1,443 reads
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...
2014-01-13
263 reads
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...
2014-01-13
141 reads
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...
2014-01-09 (first published: 2014-01-06)
2,063 reads
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...
2014-01-06
271 reads
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...
2014-01-06
147 reads
SQL Server – Calculating elapsed time from DATETIME
Elapsed time can be calculated from DATETIME field by extracting number of hours/minutes and seconds. You can use below query...
2013-12-31 (first published: 2013-12-23)
6,039 reads
SQL Server – Calculating elapsed time from DATETIME
Elapsed time can be calculated from DATETIME field by extracting number of hours/minutes and seconds. You can use below query...
2013-12-23
254 reads
Blogs
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Forums
Which 'Where' statement conditional upon a variable
Thanks in advance for any clues on this. I am trying to write a...
Backup to Immutable Storage
Comments posted to this topic are about the item Backup to Immutable Storage
Microsoft Security Changes and SQL Server
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Question of the Day
Backup to Immutable Storage
In SQL Server 2025, a backup can be made on Azure Immutable Storage. What changes in how the backup is created?
See possible answers