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 […]
Now is the time to upgrade those SQL Server 2000 systems
The time for running SQL Server 2000 systems is quickly coming to an end. Microsoft long ago announced that support for SQL Server 2000 was going to be running out in April 2013. Well April 2013 is quickly coming upon us. So what does this mean for line of business systems which are running on […]