RECONFIGURE can flush the procedure cache

I ran across this KB article the other day, which lists a few ways in which performance is affected by...

Case Sensitive searches in T-SQL

I just ran into an issue with one of my applications where a SQL statement had updated a status code...

SSRS Tip: Hide a tablix if no rows returned

I have a tablix in an SSRS report, populated by a query that might or might not return any rows. ...

Session Code – Extending Reporting Services with Custom Code

This is my wish list of things I’d like to cover in todays session at 11 AM EST https://www1.gotomeeting.com/register/935071481 but...

Dedicated Administrator Connection

Recently you may have read my article about some hidden functions in SQL Server.  In that article you learned that those functions were in some DMOs and that you...

Dedicated Administrator Connection

Recently you may have read my article about some hidden functions in SQL Server.  In that article you learned that...

SQL Server – Powershell Excel to HTML

SQL Server, Powershell and Excel are a good mix . But saving to Powershell output to HTML is versatile – if requiring...

Master Data Services 2012

As I mentioned in a pervious post Master Data Services for SQL 2012 is a huge improvement over the SQL...

Update Statistics and the new TraceFlag 2371

What comes first, the chicken or the egg? What happens first – update statistics or re-compilations?

The Statistics life cycle
As a regular...

Blackout

What more can I say.  I disagree with the kind of legislation that is being presented via SOPA and PIPA. In support of the community, my site will be...