T-Log

External Article

SQL Server Transaction Log Fragmentation: a Primer

  • Article

Generally, you will have no need to worry about the number of virtual log files in your transaction log. However, if you use the default settings for 'auto-grow', you can end up with such 'fragmentation' in your transaction log as to affect performance noticably. How can this be avoided? How can you tell it's a problem? What do you do about it? Greg explains.

2012-11-23 (first published: )

7,126 reads

Blogs

Microsoft Purview GA menu’s

By

The new data governance features in Microsoft Purview are now being made generally available...

Connect to Power BI as a Guest User in another Tenant

By

Sometimes your Microsoft Entra ID account (formerly known as Azure Active Directory) is added...

Parsing EXE Output in PowerShell

By

I saw a post internally that asked this question: Anyone have a handy powershell...

Read the latest Blogs

Forums

GIT Configuration and Automated Release for Azure Data Factory

By Sucharita Das

Comments posted to this topic are about the item GIT Configuration and Automated Release...

Automate reports for when the SQL database was last used

By PreethiKenchappa1

Hi, I'm working on cleanup activity of deleting databases that aren't in use or...

Veeam Queries.

By goodtimecharlie

Good morning campers! I'm hoping to pick your collective hive brain wrt Veeam /...

Visit the forum

Question of the Day

Disable All the Indexes

How do I disable all the indexes on the dbo.Logger table?

See possible answers