T-SQL to check Data and Log Files are on same drive or not
The below query help us in finding the physical existence of data and log files are on same drive or...
2014-01-13
649 reads
The below query help us in finding the physical existence of data and log files are on same drive or...
2014-01-13
649 reads
My first webinar of the year! I’m joining forces with the GreenSQL and MSSQLTips to present Security, Compliance, and SQL...
2014-01-27 (first published: 2014-01-13)
990 reads
First meeting of the year with Bradley Ball presenting Locking, Blocking, Latches, Deadlocks, and Spinlocks. Let them know you’ll be...
2014-01-13
674 reads
I came across an interesting question on SE last week. Guid vs INT – Which is better as a primary key?...
2014-01-20 (first published: 2014-01-13)
4,907 reads
@@MAX_CONNECTIONS in SQL Server returns maximum number of simultaneous user connections allowed. Maximum user connections allowed by SQL Server by...
2014-01-13
148 reads
@@MAX_CONNECTIONS in SQL Server returns maximum number of simultaneous user connections allowed. Maximum user connections allowed by SQL Server by...
2014-01-13
273 reads
@@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,464 reads
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,064 reads
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,701 reads
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
559 reads
By DesertDBA
I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it...
Should you adopt an off-the-shelf AI tool, partner with a specialist, build in-house, or...
By ReviewMyDB
Part 1 of my What's New in SQL Server for the Developer series. IIF,...
Comments posted to this topic are about the item Server-level Roles
Comments posted to this topic are about the item Pay for Performance
Comments posted to this topic are about the item Tracking Inserted, Updated, and Deleted...
In SQL Server 2025, can I alter a fixed server role?
See possible answers