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
309 reads
- Interests: SQL Server!
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,445 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
264 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
142 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
How to Find Expensive Queries in Amazon Redshift
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
The Notification Trap: How Input Fatigue Is Killing Deep Work in Tech
By gbargsley
If you've been here before, you know this blog is usually about SQL Server,...
Designing a Storage Load Test for SQL Server
I’ve been doing storage load tests for SQL Server for a long time, both...
Forums
How Long is a Long I/O?
Comments posted to this topic are about the item How Long is a Long...
T-SQL Trigonometric Functions in SQL Server
Comments posted to this topic are about the item T-SQL Trigonometric Functions in SQL...
Half of All Engineers
Comments posted to this topic are about the item Half of All Engineers
Question of the Day
How Long is a Long I/O?
In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?
See possible answers