SQLskills SQL101: The SQL Server ERRORLOG

One of the most useful logs you can review when there’s a problem in SQL Server is the ERRORLOG.  It may not always be the answer to your problem, but it’s a good place to start. When you initially install SQL Server it only keeps the most recent six (6) ERRORLOG files, in addition to […]

SQLskills SQL101: Trace Flags

“You should always use trace flag X for a SQL Server install.” “Have you tried trace flag Y?” “We fixed the problem using an undocumented trace flag.” If you’re new to SQL Server, you might have heard or read some of the above statements.  If you’ve never used a trace flag, you might wonder why […]