Browsing the blog archives for January, 2010

Escaping a Quote

I was on my way out the door when a respected colleague bounded over with a quick question.  He needed to query a column in a table that had a single quote embedded in the string. This is one of those little SQL tricks that can really slow you down.  I don’t know when or […]


Side Effects / Benefits of Indexed Views

Indexed views, also known as materialized views, can offer significant performance benefits when properly implemented.  SQL Server BoL certainly highlights the benefits in great detail. A co-worker, whom I have the highest regard for his technical / SQL abilities recently asked me to take a look at a query he was running that was behaving […]