This tip is intended to help someone who is or will be facing a no free buffer found issue with the SQL Server LazyWriter. Recently, we experienced some unknown issues with our SQL Server and after inspecting the error log file we noticed the following errors: "SQL Server has encountered 50 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file..." and "LazyWriter: warning, no free buffers found." These error messages were followed by a SQL Server memory dump file like SQLDump0030.mdmp in the file system.

The T-SQL Hammer

by Chad Miller

SQLServerCentral.com

Blogs

The over-reliance on a familiar tool is best described with the quote, “if all you have is hammer, everything looks...

Cleaning Up Garbage from Data

by Shubhajyoti Ghosh

SQLServerCentral.com

T-SQL

Cleaning up garbage from data can be a big problem for a developer.Check out a simple solution from Shubhajyoti Ghosh to cleaning up garbage from data.

FizzBuzz

by Steve Jones

SQLServerCentral.com

Editorial

Can most programmers not program? A new test, the FizzBuzz test, is being used to weed out candidates. Steve Jones comments on the types of FizzBuzz questions he's used in T-SQL.

Oracle: Overhaul or Overkill?

by Chris Massey

SQLServerCentral.com

Editorial

Vendor-specific hardware might make Oracle less painful to use in the future, so Chris Massey considers whether Microsoft should consider providing a more tailored and complete product with SQL Server. The verdict? "Not necessary".

SSIS 2008 Script Component variable gotcha..

by Josef Richberg

SQLServerCentral.com

Blogs

In a previous post I showed you how to access variables from within an SSIS script component. More specifically I...

Tips for Simplifying Crosstab Query Statements

by Additional Articles

Database Journal

T-SQL

Rob Gravelle takes a complex SQL statement and shows you several ways to re-write it that both simplifies and shortens it, while still yielding the same results.

TSQL Challenge 24 - Find discrepancies in the scheduled activities and actual activities performed by employees

by Additional Articles

T-SQL Challenges

T-SQL Challenges

This is a problem that I had seen in one of the forums many years back. This problem is related to a reporting requirement from the data stored by a 'poorly designed' system.