Tag Archives: sql server

RECONFIGURE can flush the procedure cache

Posted on January 19, 2012 by way0utwest

I ran across this KB article the other day, which lists a few ways in which performance is affected by various maintenance or administrative type operations. In KB article 917818, it notes that some operations cause a performance issue. Some … Continue reading →

Posted in Blog | Tagged , , | Comments Off on RECONFIGURE can flush the procedure cache

Capacity Planning – Monitor and Extrapolate

Posted on January 16, 2012 by way0utwest

I wrote a post recently on capacity planning, and then thought of one more thing. In addition to planning for the future for new systems, you also need to regularly monitor your existing ones. Planning for the future, IMHO, isn’t … Continue reading →

Posted in Blog | Tagged , , | 2 Comments

T-SQL Tuesday #26 – Second Changes with Date/Time

Posted on January 10, 2012 by way0utwest

I missed the very first T-SQL Tuesday, so when this month’s topic of second chances came up, I decided to write that one. If you are unsure of what T-SQL Tuesday is, follow the link to this month’s topic to … Continue reading →

Posted in Blog | Tagged , , , | 3 Comments

Referencing Remote Data

Posted on January 10, 2012 by way0utwest

One of the features added to SQL Server a few years ago were the ability to create synonyms and use those to reference other objects. The ability to create synonyms is something that I had wanted for years in SQL Server, but … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Referencing Remote Data