Last Backup Taken, or Not
Displays the last Full, Diff, and Log backup taken. If no backup has been taken that is displayed as well.
2012-05-24 (first published: 2012-05-15)
1,479 reads
Index Fragmentation for All Databases
Returns Top 25 fragmented indexes complete with full object name and index name.
2011-04-29 (first published: 2009-05-29)
9,938 reads
View Errors in the Default Trace
Returns records with errors from the default trace ordered by most recent first
2009-11-12 (first published: 2009-10-29)
679 reads
2009-09-08 (first published: 2009-08-31)
450 reads
Blogs
Sic Transit Gloria Community
When Covid took out the PASS organization, I had someone say to me, “Well,...
DATEADD Truncates the Number Parameter: #SQLNewBlogger
By Steve Jones
This was an interesting thing I saw in a Question of the Day submission....
Our SQL Server is Slow! What Do I Do First?
By Kevin3NF
Don’t Panic! It’s a vague but common complaint, frequently with no additional details. Before...
Forums
Dynamic T-SQL Script Parameterization Using Python
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
Fax/Phone Area code Substring
Hello, For the below SQL, why the column "Phone_Country_Code" Code is showing "0" instead...
Error when trying to enable cdc . Could not update the metadata
Server and db in SQL SERVER 2019. I have multiple tables that are enabled...
Question of the Day
A Strange Choice
What is returned when I run this code in SQL Server 2022?
CREATE TABLE CatIndex ( indexval VARCHAR(20) ) GO INSERT dbo.CatIndex (indexval) VALUES ('1'), ('2'), ('3') GO SELECT CHOOSE(indexval, cast('2025-01-01' AS DATE), CAST('2025-02-01' AS DATE), CAST('2025-03-01' AS DATE)) FROM dbo.CatIndex AS ciSee possible answers