March 2023 Discount: Comprehensive Database Performance Health Check | Testimonials

  • Consulting
  • Training
  • Free Videos
  • All Articles
    • Interview Questions and Answers
    • SQL Tips and Tricks
    • SQL Performance
    • SQL Puzzle
    • Big Data
    • Blog Stats
    • SQL Books
    • Search SQLAuthority
  • Downloads
  • Hire Me
  • Health Check
  • Training
Virtual Log Files

SQL Server 2022 – Managing Virtual Log Files

February 28, 2023
Pinal Dave
SQL Tips and Tricks
SQL Log, Transaction Log, VLF

Virtual Log Files (VLFs) are internal divisions of physical log files created by the SQL Server Database Engine. They have no fixed size.

Read More
shrinklog

SQL SERVER – Reasons – Not Able to Shrink the Transaction Log

August 24, 2022
Pinal Dave
SQL Tips and Tricks
Shrinking Database, SQL Log, SQL Server, System Database

Recently during consulting engagement Comprehensive Database Performance Health Check, my client asked if I knew why they could not shrink the transaction log.

Read More
Free Space

SQL SERVER – Available Free Space in Data and Log File

August 16, 2021
Pinal Dave
SQL Tips and Tricks
SQL Log, SQL Scripts, SQL Server

Lots of good feedback, I have received on my recent to the point blog posts. Today we will see a script for Available Free Space in Data and Log File.

Read More
Recovery Models

SQL SERVER – Logs are Full and Can’t Switch Recovery Models

August 2, 2021
Pinal Dave
SQL Tips and Tricks
Recovery Model, SQL Log, SQL Server, Transaction Log

His question was about their database Logs, which were Full and they Can’t Switch Recovery Models. Let us discuss this problem today. 

Read More
drop table

SQL SERVER – Who Dropped Table? Part 2

February 8, 2021
Pinal Dave
SQL Tips and Tricks
SQL Log, SQL Scripts, SQL Server, SQL Server Security

There is a way to find out few more things. However, before we continue I strongly suggest that you watch the following video about the dropped table.

Read More
Flushing Log

SQL SERVER – Delayed Durability and Flushing Log Files

December 30, 2020
Pinal Dave
SQL Tips and Tricks
SQL Log, SQL Scripts, SQL Server, SQL Stored Procedure, Transaction Log

Today we will be seeing a simple solution of Delayed Durability and Flushing Log Files. Comprehensive Database Performance Health Check.

Read More
Simple Recovery

SQL SERVER – Simple Recovery Model and Restrictions

September 23, 2020
Pinal Dave
SQL Tips and Tricks
Recovery Model, SQL Backup, SQL Log, SQL Restore, SQL Scripts, SQL Server

I received a question from a client that they want to move their database from the Full Recovery Model to the Simple Recovery Model, can they do it?

Read More
1 2 3 4 … 18 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

© 2006 – 2023 All rights reserved. pinal @ SQLAuthority.com

Go to mobile version