A restore from LDF file only is not possible, because a log holds changes and not the database. This post answers five common questions, shows the error SQL Server gives, and restores a database from a full backup, a log backup and a tail-log backup.
Schema Changes History Has No Data: Check Default Trace Enabled
The Schema Changes History report can say it has no data to show. A client saw this message in SSMS. Check that default trace enabled is 1, make a schema change, and run the report again.
Where to Download SQL Server 2019 for FREE? – Interview Question of the Week #276
Question: Where to Download SQL Server 2019 for FREE?
Answer: This is one of the most popular questions, I keep on receiving from blog readers.
SQL SERVER – Last Page Insert PAGELATCH_EX Contention Due to Identity Column
Today’s goal is to understand what is the Last Page Insert PAGELATCH_EX Contention Due to Primary Key. Let us start understanding it together.
SQL SERVER Management Studio and SQLCMD Mode
Honestly, there is an alternative way to quickly use SSMS SQLCMD mode as a development environment, let us learn about it today.
sqlcmd vs SSMS: How to Time the Same Loop Fairly
A sqlcmd vs SSMS timing is fair only when both tools run the same file. The clock must sit inside the script. This post times 10,000 inserts three ways with a log table, shows what changed and what didn’t, and lists the settings to match before you compare.
oStress vs SSMS: What Each Tool Is Built to Measure
oStress vs SSMS is not a race, because the tools measure different things. This post times 10,000 inserts in three ways with a clock inside the script, then shows how eight sessions finish the same work faster. It explains what a one-session loop really measures.