<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="http://gregmckinley.com/cs/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>SQL Performance Reminders</title><link>http://gregmckinley.com/cs/blog/archive/2006/05/16/6.aspx</link><description>Just a couple of SQL Server reminders to keep your database skills sharp.
1. Use Fully Qualified Names. This allows SQL Server to better access the stored procedures execution plan and speed up its performance.
EXEC pubs.dbo.reptq1
2. Use SET NOCOUNT</description><dc:language>en-US</dc:language><generator>CommunityServer 2.0 (Build: 60217.2664)</generator></channel></rss>