MSDB Tuning by purging backup and restore history
Have you ever had problem with your backup jobs taking more time than usual overlapping your maintenance window? It is...
2017-12-01
199 reads
DBA Mastery
SQL Server Management Studio Reports
Today’s tip is a very basic functionality that comes with any SSMS (SQL Server Management studio), we are talking about...
2017-11-07
157 reads
Blogs
SQL Server Logins vs. Users: Why You Really Need to Know the Difference
By Kevin3NF
The Two-Layer Model Explained “We added them to the database, but they still can’t...
Using AI to Test a SQL Query
By Steve Jones
Someone sent me this code. WITH p AS ( SELECT ID, ROW_NUMBER() OVER (ORDER...
Your SQL Starting Line: Best Free Databases for Beginners
Wondering which database to tackle first? I’ve got the lowdown on the top free...
Forums
can ssrs detect rls and cls thru proxy like user ids?
Hi we often use non expiring windows and sql accounts to actually run (credential...
Changing the Paradigm of Work
Comments posted to this topic are about the item Changing the Paradigm of Work
Removing a File
Comments posted to this topic are about the item Removing a File
Question of the Day
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