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
147 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
269 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,462 reads
SSAS – Using the Euro or Pound currency Symbol in a measure Format String
If you have a set of measures and some of them are US dollars, some are Euros, and some are...
2014-01-17 (first published: 2014-01-13)
2,061 reads
My Favourite SSMS productivity tips
It’s a well known fact that any sitcom that runs for a certain length of time will release a clip...
2014-01-13
1,697 reads
What Tables Are Wasted?
Wasted space still seems to be on everyone's mind to some extent. I've wondered what tables do we use? We...
2014-01-13
553 reads
SQLSaturday #272 Nashville
SQLSaturday #272 Nashville here I come! Looking forward to having an opportunity to speak and network in Nashville. I am...
2014-01-11
373 reads
Question of the Week - 11/1/2014
Question:- Suppose there are two tables A and B and we need to write 3 SQL queries which returns the record...
2014-01-11
790 reads
Answer - Objective Question (In which database temporary tables are created in SQL Server)
Question :- In which database temporary tables are created in SQL Server?
1) User database (where temporary table are defined)
2) Master...
2014-01-11
1,686 reads
Who Owns SQL Backups?
I was asked by Idera to take a look at the things that could cost a DBA their job. This...
2014-01-10
1,069 reads
Blogs
How to Measure AI Value: A 6-Branch AI Maturity Model for Use Cases and Agents
Your AI is busy. But do you know what it's worth? Most companies can...
Speeding Up Patching – Beyond Patch Delivery
By Brian Kelley
I wear many hats in technology, and one of those is as a (cyber)security...
Monday Monitor Tips: Query Recommendations
By Steve Jones
We keep adding stuff to Redgate Monitor, and it’s easy to miss some of...
Forums
Azure SQL Hyperscale Unveiled
Comments posted to this topic are about the item Azure SQL Hyperscale Unveiled
What is the worst part about existing monitoring solutions?
Hi. What is the most difficult aspect of using monitoring software like idera, redgate,...
MiniMax m3 and SQL Server
Comments posted to this topic are about the item MiniMax m3 and SQL Server
Question of the Day
SQL Server Vector Support I
What are vectors in SQL Server 2025, as related to the new AI features?
See possible answers