Monthly Archives: June 2015

Archive Every Day

Posted on June 9, 2015 by way0utwest

I regularly see questions posted online from people struggling to manage a large archive process. Often the inserts into an archive table and the deletes from the source require large amounts of resources that strain systems and block other activity. … Continue reading →

Posted in Editorial | Tagged | 1 Comment

T-SQL Tuesday #67 – Extended Events for DBCC

Posted on June 9, 2015 by way0utwest

It’s the second Tuesday of the month and time for another T-SQL Tuesday. This time it’s #67 from Jes Borland on Extended Events. You can read the invite, and whether you can participate today or not, write your blog and … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on T-SQL Tuesday #67 – Extended Events for DBCC

SQL Saturday #390 – Philadelphia Recap

Posted on June 8, 2015 by way0utwest

I was at SQL Saturday #390 in Philadelphia last week and it was an exciting, but short time. The event was at the end of a  five day trip for me, Seattle first and then Philadelphia, so I was tired … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on SQL Saturday #390 – Philadelphia Recap

When Should We Be Cleaning Data?

Posted on June 8, 2015 by way0utwest

I was reading Grant Fritchey’s update from the Business Analyst Conference  and noticed this quote: ” There were lots of sessions on the need to clean data, which implies that we need to do a better job at data collection in order … Continue reading →

Posted in Editorial | Tagged , , | Comments Off on When Should We Be Cleaning Data?