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
925 reads
You can enable line numbers to be displayed in SSMS Query Editor. This is extremely useful when working on a...
2014-01-20
925 reads
You can enable line numbers to be displayed in SSMS Query Editor. This is extremely useful when working on a...
2014-01-20
298 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
256 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,437 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
134 reads
A Recovery Model is property of a database which control how transaction log is maintained. SQL Server supports SIMPLE, FULL...
2014-01-06
136 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,057 reads
A Recovery Model is property of a database which control how transaction log is maintained. SQL Server supports SIMPLE, FULL...
2014-01-06
259 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
243 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,029 reads
By Kevin3NF
The Two-Layer Model Explained “We added them to the database, but they still can’t...
By Steve Jones
Someone sent me this code. WITH p AS ( SELECT ID, ROW_NUMBER() OVER (ORDER...
Wondering which database to tackle first? I’ve got the lowdown on the top free...
Hi we often use non expiring windows and sql accounts to actually run (credential...
Comments posted to this topic are about the item Changing the Paradigm of Work
Comments posted to this topic are about the item Removing a File
I attempted to use ALTER DATABASE to remove a file from my filegroup in SQL Server 2022. There are 4 files in this filegroup, but I don't need them all. However, I received a message that the file was not empty. How do I empty this file so it can be removed?
See possible answers