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
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
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
@@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,452 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
264 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
142 reads
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,071 reads
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
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
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
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
By Steve Jones
It’s Prime Day. A few of my recommendations, since I want to do some...
With Fabric Mirroring, Microsoft is promoting a nice and appealing story for operational reporting...
If you’ve been watching AI roll through the data community and thinking, “this seems...
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Comments posted to this topic are about the item Concurrency and Baseline Control: Level...
Comments posted to this topic are about the item Spending Time in the Office
I have this code on SQL Server 2022. What happens when it runs all at once?
DROP TABLE IF EXISTS dbo.Commission GO CREATE TABLE dbo.Commission (id INT NOT NULL IDENTITY(1,1) CONSTRAINT CommissionPK PRIMARY KEY , salesperson VARCHAR(20) , commission VARCHAR(20) ) GO INSERT dbo.Commission ( salesperson, commission) VALUES ( 'Brian', 12 ), ( 'Brian', 'None' ) GOSee possible answers