This metric picks up excessive counts of Virtual Log Files (VLF) in a transaction log that can lead to performance problems, including write performance, restore and recovery times. The ideal value for this metric should be less than 25; excessively high values (greater than 50) can cause high write times when writing to the transaction log.
2014-12-11
7,312 reads
How do you use SQL Server, and how do you expect this to change next year? Fill in our survey, and enter a prize draw to win Amazon vouchers.
2014-12-11 (first published: 2014-12-02)
19,631 reads
Nominations open until December 10. The Tribal Awards are back and looking to recognize some of the great contributors to the SQL community. Nominations are now open for 11 different categories, but closing soon so make sure your user group, favorite twitter account, or person who's helped you the most this year is nominated.
2014-12-09 (first published: 2014-12-02)
713 reads
Participate in an online survey on SQL Server Developer Tools for a chance to win one of ten $100 Amazon vouchers.
2014-12-09 (first published: 2014-12-05)
14,836 reads
In this LIDNUG webinar, Mitchel Sellers walks through performance tuning best practices, and investigates how developers can use ANTS Performance Profiler to explore their application code and the SQL queries and execution plans behind it.
2014-12-05
7,720 reads
When a table has multiple indexes defined on the same columns, it produces duplicate indexes that waste space and have a negative impact on performance. This metric measures the number of possible duplicate indexes per database above a set threshold. You can then consider dropping the indexes and reverse the change.
2014-11-18
7,931 reads
On November 19, 2014, the SQL Server Luxembourg User Group and Dell Software will be hosting a free event. Richard Douglas will be be presenting a double bill: SQL Server 2014 features everyone can use, and Wait watchers - Gain Performance Increases Fast! This event is free to registered attendees.
2014-11-11
6,908 reads
SQL Server MVP Grant Fritchey and Steve Jones will present the Stairway to Continuous Delivery in Washington DC again this December. Learn how to build an efficient development and deployment process for your organization. Register for this free event.
2014-11-06
7,086 reads
PASS attendees will get the chance to learn about Database Lifecycle Management (DLM) straight from its chief proponent: Red Gate Software, the database and .NET tooling company.
2014-11-03
184 reads
The MidnightDBAs have developed a free reindexing solution to help DBAs perform maintenance on their instances. Read about the solution and attend their webinar.
2014-10-24
2,159 reads
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
By DataOnWheels
I have been active in the data community throughout my career. I have met...
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
Comments posted to this topic are about the item Having a Little Fun at...
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers