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 […]
Using Event Viewer Logging for SSIS Performance Trouble Shooting
So while working with a client recently I was going some performance tuning on SSIS for them. While SSIS isn’t exactly my normal workload, the problem wasn’t really in SSIS, but just normal SQL Statements being called from SSIS. While attacking this problem, the first thing that I did was look into the SSIS package […]