How Many SQL Server ERRORLOG Files Do I Keep?

When working with SQL Servers there are lots of settings that people like to tweak to make their SQL Server run smoother.  One setting that I really like tweaking is the number of ERRORLOG files that are kept.  By default SQL Server keeps the last 6 ERRORLOG files around deleting the last one each time […]

How Many SQL Server ERRORLOG Files Do I Keep?

When working with SQL Servers there are lots of settings that people like to tweak to make their SQL Server run smoother.  One setting that I really like tweaking is the number of ERRORLOG files that are kept.  By default SQL Server keeps the last 6 ERRORLOG files around deleting the last one each time […]

Recommended reading from mrdenny for March 29, 2013

This week I’ve found some great things for you to read. These are a few of my favorites that I’ve found this week. How To Return Document Property Values in Full-Text Search Thinking about the inaccurate_cardinality_estimate Event SQL Server 2012 security: Changes for the newest version Detecting Cardinality Estimate Issues with sys.dm_exec_query_stats Is the SAN […]

Recommended reading from mrdenny for March 29, 2013

This week I’ve found some great things for you to read. These are a few of my favorites that I’ve found this week. How To Return Document Property Values in Full-Text Search Thinking about the inaccurate_cardinality_estimate Event SQL Server 2012 security: Changes for the newest version Detecting Cardinality Estimate Issues with sys.dm_exec_query_stats Is the SAN […]