<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="http://sqlblogcasts.com/utility/FeedStylesheets/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>Tony Rogerson&amp;#39;s ramblings on SQL Server - All Comments</title><link>http://sqlblogcasts.com/blogs/tonyrogerson/default.aspx</link><description>&lt;table id="table2" cellspacing="1" cellpadding="7"&gt;
&lt;tr&gt;
	&lt;td valign="top" rowspan="2"&gt;&lt;a href="http://www.sql-server.co.uk"&gt;&lt;img border="0" src="http://sqlserverfaq.com/images/tonyrogerson.jpg" alt="" /&gt;&lt;/a&gt;&lt;/td&gt;
	&lt;td&gt;&lt;p align="center"&gt;&lt;font face="Tahoma" color="#008000"&gt;Tony Rogerson is an 
independent SQL Server specialist based in the UK, this is his blog fed 
from his day to day experience as a consultant and work in the SQL community.&lt;/font&gt;
	&lt;/td&gt;
	&lt;td valign="top" rowspan="2"&gt;&lt;a href="http://www.sql-server.co.uk" target="_blank"&gt;&lt;img border="0" src="http://sqlblogcasts.com/photos/blogimages/images/454/secondarythumb.aspx" alt="" /&gt;&lt;/a&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;&lt;td&gt;
&lt;a href="http://en-gb.facebook.com/people/Tony-Rogerson/1078364749" title="Tony Rogerson&amp;#039;s Facebook Profile" target="_TOP"&gt;&lt;img src="http://badge.facebook.com/badge/1078364749.401.1765505178.png" alt="Tony Rogerson&amp;#039;s Facebook Profile" style="border:0px;" /&gt;&lt;/a&gt;
&lt;/td&gt;&lt;/tr&gt;
&lt;/table&gt;
</description><dc:language>en</dc:language><generator>CommunityServer 2007.1 (Build: 20917.1142)</generator><item><title>Scalar UDFs wrapped in CHECK constraints are very slow and may fail for multirow updates</title><link>http://sqlblogcasts.com/blogs/tonyrogerson/archive/2008/02/07/using-a-udf-in-a-check-constraint-to-check-validity-of-history-windows-start-end-date-windows.aspx#11913</link><pubDate>Fri, 26 Jun 2009 03:01:02 GMT</pubDate><guid isPermaLink="false">fa8c4e8e-46a3-4193-8264-2c1a9cb3475d:11913</guid><dc:creator>Alexander Kuznetsov</dc:creator><description>&lt;p&gt;Surely this sounds like common knowledge, yet I decided to post a simple benchmark demonstrating how&lt;/p&gt;
&lt;img src="http://sqlblogcasts.com/aggbug.aspx?PostID=11913" width="1" height="1"&gt;</description></item><item><title>How to Find Overlapping Date Ranges in a Table | keyongtech</title><link>http://sqlblogcasts.com/blogs/tonyrogerson/archive/2008/02/07/using-a-udf-in-a-check-constraint-to-check-validity-of-history-windows-start-end-date-windows.aspx#11834</link><pubDate>Wed, 10 Jun 2009 06:05:33 GMT</pubDate><guid isPermaLink="false">fa8c4e8e-46a3-4193-8264-2c1a9cb3475d:11834</guid><dc:creator>How to Find Overlapping Date Ranges in a Table | keyongtech</dc:creator><description>&lt;p&gt;Pingback from &amp;nbsp;How to Find Overlapping Date Ranges in a Table | keyongtech&lt;/p&gt;
&lt;img src="http://sqlblogcasts.com/aggbug.aspx?PostID=11834" width="1" height="1"&gt;</description></item><item><title>Wot no SCOPE_GUID() function??</title><link>http://sqlblogcasts.com/blogs/tonyrogerson/archive/2008/05/05/using-the-output-clause-on-insert-when-loading-data-using-openrowset-and-bulk-operator.aspx#11829</link><pubDate>Mon, 08 Jun 2009 23:06:12 GMT</pubDate><guid isPermaLink="false">fa8c4e8e-46a3-4193-8264-2c1a9cb3475d:11829</guid><dc:creator>Martin Bell UK SQL Server MVP</dc:creator><description>&lt;p&gt;When you have a database generated GUID value how do you find out what it is?&lt;/p&gt;
&lt;img src="http://sqlblogcasts.com/aggbug.aspx?PostID=11829" width="1" height="1"&gt;</description></item><item><title>Wot no SCOPE_GUID() function??</title><link>http://sqlblogcasts.com/blogs/tonyrogerson/archive/2008/05/05/using-the-output-clause-on-insert-when-loading-data-using-openrowset-and-bulk-operator.aspx#11827</link><pubDate>Mon, 08 Jun 2009 15:05:27 GMT</pubDate><guid isPermaLink="false">fa8c4e8e-46a3-4193-8264-2c1a9cb3475d:11827</guid><dc:creator>Martin Bell UK SQL Server MVP</dc:creator><description>&lt;p&gt;I’ve talked about the problems of using GUIDs as key values, and some of the issues that you may come&lt;/p&gt;
&lt;img src="http://sqlblogcasts.com/aggbug.aspx?PostID=11827" width="1" height="1"&gt;</description></item><item><title>TempDB full | keyongtech</title><link>http://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/08/24/958.aspx#11824</link><pubDate>Mon, 08 Jun 2009 09:05:21 GMT</pubDate><guid isPermaLink="false">fa8c4e8e-46a3-4193-8264-2c1a9cb3475d:11824</guid><dc:creator>TempDB full | keyongtech</dc:creator><description>&lt;p&gt;Pingback from &amp;nbsp;TempDB full | keyongtech&lt;/p&gt;
&lt;img src="http://sqlblogcasts.com/aggbug.aspx?PostID=11824" width="1" height="1"&gt;</description></item><item><title>SQL Server Blog by Jason Massie</title><link>http://sqlblogcasts.com/blogs/tonyrogerson/archive/2008/03/20/taking-stock-on-the-success-of-sqlblogcasts-com.aspx#11819</link><pubDate>Mon, 08 Jun 2009 00:26:37 GMT</pubDate><guid isPermaLink="false">fa8c4e8e-46a3-4193-8264-2c1a9cb3475d:11819</guid><dc:creator>SQL Server Blog by Jason Massie</dc:creator><description>&lt;p&gt;Pingback from &amp;nbsp;SQL Server Blog by Jason Massie&lt;/p&gt;
&lt;img src="http://sqlblogcasts.com/aggbug.aspx?PostID=11819" width="1" height="1"&gt;</description></item><item><title>SELECT / INSERT Concurrency &amp;amp; Collisions | keyongtech</title><link>http://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/06/30/855.aspx#11806</link><pubDate>Thu, 04 Jun 2009 06:08:42 GMT</pubDate><guid isPermaLink="false">fa8c4e8e-46a3-4193-8264-2c1a9cb3475d:11806</guid><dc:creator>SELECT / INSERT Concurrency &amp; Collisions | keyongtech</dc:creator><description>&lt;p&gt;Pingback from &amp;nbsp;SELECT / INSERT Concurrency &amp;amp;amp; Collisions | keyongtech&lt;/p&gt;
&lt;img src="http://sqlblogcasts.com/aggbug.aspx?PostID=11806" width="1" height="1"&gt;</description></item><item><title>UK SQL Server User Group - Weekly LiveMeetings sorted; Leeds Perf Troubleshooting tomorrow night + BI LiveMeeting Thursday</title><link>http://sqlblogcasts.com/blogs/tonyrogerson/archive/2009/05/28/livemeeting-recording-for-my-sql-server-toolset-intro-part-1-is-now-available.aspx#11791</link><pubDate>Tue, 02 Jun 2009 06:57:51 GMT</pubDate><guid isPermaLink="false">fa8c4e8e-46a3-4193-8264-2c1a9cb3475d:11791</guid><dc:creator>Tony Rogerson's ramblings on SQL Server</dc:creator><description>&lt;p&gt;We have weekly LiveMeetings on every Thursday in June, plus a range of physical events, also don&amp;amp;#39;t&lt;/p&gt;
&lt;img src="http://sqlblogcasts.com/aggbug.aspx?PostID=11791" width="1" height="1"&gt;</description></item><item><title>Taking low dose of hydrocodone while pregnant.</title><link>http://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/05/18/449.aspx#11789</link><pubDate>Tue, 02 Jun 2009 00:09:52 GMT</pubDate><guid isPermaLink="false">fa8c4e8e-46a3-4193-8264-2c1a9cb3475d:11789</guid><dc:creator>Hydrocodone.</dc:creator><description>&lt;p&gt;Hydrocodone detection period. Is oxycodone or hydrocodone stronger. Hydrocodone. Hydrocodone apap. Hydrocodone prescription. Hydrocodone m357. Buy hydrocodone without a prescription.&lt;/p&gt;
&lt;img src="http://sqlblogcasts.com/aggbug.aspx?PostID=11789" width="1" height="1"&gt;</description></item><item><title>Adderall and migraines.</title><link>http://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/05/18/449.aspx#11779</link><pubDate>Sat, 30 May 2009 22:41:44 GMT</pubDate><guid isPermaLink="false">fa8c4e8e-46a3-4193-8264-2c1a9cb3475d:11779</guid><dc:creator>Adderall.</dc:creator><description>&lt;p&gt;Adderall xr. Adderall treating anxiety in adults. Adderall.&lt;/p&gt;
&lt;img src="http://sqlblogcasts.com/aggbug.aspx?PostID=11779" width="1" height="1"&gt;</description></item><item><title>Long term use of percocet.</title><link>http://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/05/18/449.aspx#11778</link><pubDate>Fri, 29 May 2009 22:16:12 GMT</pubDate><guid isPermaLink="false">fa8c4e8e-46a3-4193-8264-2c1a9cb3475d:11778</guid><dc:creator>Percocet shipped cod no prior.</dc:creator><description>&lt;p&gt;Percocet high blood pressure. Percocet.&lt;/p&gt;
&lt;img src="http://sqlblogcasts.com/aggbug.aspx?PostID=11778" width="1" height="1"&gt;</description></item><item><title>Event Notifications</title><link>http://sqlblogcasts.com/blogs/tonyrogerson/archive/2007/04/06/event-notifications-monitoring-blocked-processes-and-other-events-end-to-end-how-to-set-it-up-and-make-it-work.aspx#11718</link><pubDate>Fri, 22 May 2009 09:49:51 GMT</pubDate><guid isPermaLink="false">fa8c4e8e-46a3-4193-8264-2c1a9cb3475d:11718</guid><dc:creator>Martin Bell UK SQL Server MVP</dc:creator><description>&lt;p&gt;Using Event Notifications to save deadlock graphs or blocking will help you to diagnose some of those tricky problems&lt;/p&gt;
&lt;img src="http://sqlblogcasts.com/aggbug.aspx?PostID=11718" width="1" height="1"&gt;</description></item><item><title>Table-valued parameters in SQL Server 2008 (Part 1)</title><link>http://sqlblogcasts.com/blogs/tonyrogerson/archive/2009/03/26/slides-for-martin-bell-and-tony-rogerson-presentations-manchester-26-feb-09.aspx#11646</link><pubDate>Mon, 11 May 2009 14:48:02 GMT</pubDate><guid isPermaLink="false">fa8c4e8e-46a3-4193-8264-2c1a9cb3475d:11646</guid><dc:creator>Martin Bell UK SQL Server MVP</dc:creator><description>&lt;p&gt;Table-valued parameters are a new feature in SQL Server 2008. This series of posts is inspired by a talk I gave at the inaugral meeting of the Manchester SQL Server User Group in March.&lt;/p&gt;
&lt;img src="http://sqlblogcasts.com/aggbug.aspx?PostID=11646" width="1" height="1"&gt;</description></item><item><title>Table-valued parameters in SQL Server 2008 (Part 1)</title><link>http://sqlblogcasts.com/blogs/tonyrogerson/archive/2009/03/26/slides-for-martin-bell-and-tony-rogerson-presentations-manchester-26-feb-09.aspx#11633</link><pubDate>Sun, 10 May 2009 21:25:10 GMT</pubDate><guid isPermaLink="false">fa8c4e8e-46a3-4193-8264-2c1a9cb3475d:11633</guid><dc:creator>Martin Bell UK SQL Server MVP</dc:creator><description>&lt;p&gt;Table-valued parameters are a new feature in SQL Server 2008. This series of posts is inspired by a talk I gave at the inaugral meeting of the Manchester SQL Server User Group in March.&lt;/p&gt;
&lt;img src="http://sqlblogcasts.com/aggbug.aspx?PostID=11633" width="1" height="1"&gt;</description></item><item><title>Websites tagged "max" on Postsaver</title><link>http://sqlblogcasts.com/blogs/tonyrogerson/archive/2008/10/24/format-query-output-into-an-html-table-the-easy-way.aspx#11586</link><pubDate>Tue, 28 Apr 2009 15:17:20 GMT</pubDate><guid isPermaLink="false">fa8c4e8e-46a3-4193-8264-2c1a9cb3475d:11586</guid><dc:creator>Websites tagged "max" on Postsaver</dc:creator><description>&lt;p&gt;Pingback from &amp;nbsp;Websites tagged &amp;quot;max&amp;quot; on Postsaver&lt;/p&gt;
&lt;img src="http://sqlblogcasts.com/aggbug.aspx?PostID=11586" width="1" height="1"&gt;</description></item></channel></rss>