<?xml version="1.0" encoding="UTF-8"?><rss version="2.0"
	xmlns:content="http://purl.org/rss/1.0/modules/content/"
	xmlns:wfw="http://wellformedweb.org/CommentAPI/"
	xmlns:dc="http://purl.org/dc/elements/1.1/"
	xmlns:atom="http://www.w3.org/2005/Atom"
	xmlns:sy="http://purl.org/rss/1.0/modules/syndication/"
	xmlns:slash="http://purl.org/rss/1.0/modules/slash/"
	xmlns:georss="http://www.georss.org/georss" xmlns:geo="http://www.w3.org/2003/01/geo/wgs84_pos#" xmlns:media="http://search.yahoo.com/mrss/"
	>

<channel>
	<title>SQLServerPedia Syndication &#8211; Stanley Johns&#039;s Database Blog</title>
	<atom:link href="https://stanleyjohns.wordpress.com/category/sqlserverpedia-syndication/feed/" rel="self" type="application/rss+xml" />
	<link>https://stanleyjohns.wordpress.com</link>
	<description>SQL server and MySQL tips</description>
	<lastBuildDate>Thu, 03 Apr 2014 02:22:03 +0000</lastBuildDate>
	<language>en</language>
	<sy:updatePeriod>
	hourly	</sy:updatePeriod>
	<sy:updateFrequency>
	1	</sy:updateFrequency>
	<generator>http://wordpress.com/</generator>
<site xmlns="com-wordpress:feed-additions:1">7187679</site><cloud domain='stanleyjohns.wordpress.com' port='80' path='/?rsscloud=notify' registerProcedure='' protocol='http-post' />
<image>
		<url>https://secure.gravatar.com/blavatar/0f080882635ec1f0ff915a5cd60994b06d3e7f37902bff488c8e9cbb74341505?s=96&#038;d=https%3A%2F%2Fs2.wp.com%2Fi%2Fwebclip.png</url>
		<title>SQLServerPedia Syndication &#8211; Stanley Johns&#039;s Database Blog</title>
		<link>https://stanleyjohns.wordpress.com</link>
	</image>
	<atom:link rel="search" type="application/opensearchdescription+xml" href="https://stanleyjohns.wordpress.com/osd.xml" title="Stanley Johns&#039;s Database Blog" />
	<atom:link rel='hub' href='https://stanleyjohns.wordpress.com/?pushpress=hub'/>
	<item>
		<title>SQLCAT whitepapers.</title>
		<link>https://stanleyjohns.wordpress.com/2014/04/02/sqlcat-whitepapers/</link>
					<comments>https://stanleyjohns.wordpress.com/2014/04/02/sqlcat-whitepapers/#respond</comments>
		
		<dc:creator><![CDATA[stanleyjohns]]></dc:creator>
		<pubDate>Thu, 03 Apr 2014 02:22:03 +0000</pubDate>
				<category><![CDATA[SQL server]]></category>
		<category><![CDATA[SQLServerPedia Syndication]]></category>
		<category><![CDATA[architecture and internals]]></category>
		<category><![CDATA[performance]]></category>
		<category><![CDATA[tips]]></category>
		<category><![CDATA[tuning]]></category>
		<guid isPermaLink="false">http://stanleyjohns.wordpress.com/?p=559</guid>

					<description><![CDATA[SQLCAT stands for SQL Customer Advisory Team. The SQLCAT blog contains amazing posts by Microsoft&#8217;s SQL engineers back at Redmond. Reading this blog will give you a lot of  intrinsic information about SQL server. One thing I love reading in particular is the whitepapers released by the team. They contain best practices and real life [&#8230;]]]></description>
		
					<wfw:commentRss>https://stanleyjohns.wordpress.com/2014/04/02/sqlcat-whitepapers/feed/</wfw:commentRss>
			<slash:comments>0</slash:comments>
		
		
		<post-id xmlns="com-wordpress:feed-additions:1">559</post-id>
		<media:content url="https://0.gravatar.com/avatar/fd9213b3112b1f8bb129657b460f75e9d51add22e5960fc68bd1cb408131ec93?s=96&#38;d=https%3A%2F%2F0.gravatar.com%2Favatar%2Fad516503a11cd5ca435acc9bb6523536%3Fs%3D96&#38;r=G" medium="image">
			<media:title type="html">stanleyjohns</media:title>
		</media:content>
	</item>
		<item>
		<title>SQL 2005 installation oddity on multicore processors.</title>
		<link>https://stanleyjohns.wordpress.com/2013/06/07/sql-2005-installation-oddity-on-multicore-processors/</link>
					<comments>https://stanleyjohns.wordpress.com/2013/06/07/sql-2005-installation-oddity-on-multicore-processors/#comments</comments>
		
		<dc:creator><![CDATA[stanleyjohns]]></dc:creator>
		<pubDate>Fri, 07 Jun 2013 16:08:20 +0000</pubDate>
				<category><![CDATA[SQL server]]></category>
		<category><![CDATA[SQLServerPedia Syndication]]></category>
		<category><![CDATA[architecture and internals]]></category>
		<category><![CDATA[cpu]]></category>
		<category><![CDATA[install]]></category>
		<category><![CDATA[tips]]></category>
		<guid isPermaLink="false">http://stanleyjohns.wordpress.com/?p=555</guid>

					<description><![CDATA[There is an issue with installing SQL 2005 on systems that have an odd (as in not even) number of cores/processors.  The conditions are as follows: The ratio between logical processors and physical sockets is not a power of 2. For example, the computer has a single socket together with a triple-core processor. The number [&#8230;]]]></description>
		
					<wfw:commentRss>https://stanleyjohns.wordpress.com/2013/06/07/sql-2005-installation-oddity-on-multicore-processors/feed/</wfw:commentRss>
			<slash:comments>1</slash:comments>
		
		
		<post-id xmlns="com-wordpress:feed-additions:1">555</post-id>
		<media:content url="https://0.gravatar.com/avatar/fd9213b3112b1f8bb129657b460f75e9d51add22e5960fc68bd1cb408131ec93?s=96&#38;d=https%3A%2F%2F0.gravatar.com%2Favatar%2Fad516503a11cd5ca435acc9bb6523536%3Fs%3D96&#38;r=G" medium="image">
			<media:title type="html">stanleyjohns</media:title>
		</media:content>
	</item>
		<item>
		<title>SQL backup mirroring (and splitting).</title>
		<link>https://stanleyjohns.wordpress.com/2013/04/19/sql-backup-mirroring-and-splitting/</link>
					<comments>https://stanleyjohns.wordpress.com/2013/04/19/sql-backup-mirroring-and-splitting/#comments</comments>
		
		<dc:creator><![CDATA[stanleyjohns]]></dc:creator>
		<pubDate>Fri, 19 Apr 2013 21:32:45 +0000</pubDate>
				<category><![CDATA[SQL server]]></category>
		<category><![CDATA[SQLServerPedia Syndication]]></category>
		<category><![CDATA[backup]]></category>
		<category><![CDATA[performance]]></category>
		<guid isPermaLink="false">http://stanleyjohns.wordpress.com/?p=544</guid>

					<description><![CDATA[Did you know that you can mirror your SQL backups? This is good for those times when you need multiple backup copies. Like one local copy and another one on a network share. You can even split backups over multiple files. If you have an IO bottleneck during backup, or if you are low on [&#8230;]]]></description>
		
					<wfw:commentRss>https://stanleyjohns.wordpress.com/2013/04/19/sql-backup-mirroring-and-splitting/feed/</wfw:commentRss>
			<slash:comments>2</slash:comments>
		
		
		<post-id xmlns="com-wordpress:feed-additions:1">544</post-id>
		<media:content url="https://0.gravatar.com/avatar/fd9213b3112b1f8bb129657b460f75e9d51add22e5960fc68bd1cb408131ec93?s=96&#38;d=https%3A%2F%2F0.gravatar.com%2Favatar%2Fad516503a11cd5ca435acc9bb6523536%3Fs%3D96&#38;r=G" medium="image">
			<media:title type="html">stanleyjohns</media:title>
		</media:content>
	</item>
		<item>
		<title>SQL server edition comparisions.</title>
		<link>https://stanleyjohns.wordpress.com/2013/04/18/sql-server-edition-comparisions/</link>
					<comments>https://stanleyjohns.wordpress.com/2013/04/18/sql-server-edition-comparisions/#respond</comments>
		
		<dc:creator><![CDATA[stanleyjohns]]></dc:creator>
		<pubDate>Thu, 18 Apr 2013 21:24:19 +0000</pubDate>
				<category><![CDATA[SQL server]]></category>
		<category><![CDATA[SQLServerPedia Syndication]]></category>
		<category><![CDATA[architecture and internals]]></category>
		<category><![CDATA[performance]]></category>
		<category><![CDATA[scaling]]></category>
		<category><![CDATA[settings]]></category>
		<category><![CDATA[tips]]></category>
		<guid isPermaLink="false">http://stanleyjohns.wordpress.com/?p=540</guid>

					<description><![CDATA[I had created an old post about Enterprise only features of SQL server. As I found out interesting features, I added it to that old post. Today, I found out an MSDN link that has a feature comparison table which summarizes everything I was trying to capture in that post. The link above is for [&#8230;]]]></description>
		
					<wfw:commentRss>https://stanleyjohns.wordpress.com/2013/04/18/sql-server-edition-comparisions/feed/</wfw:commentRss>
			<slash:comments>0</slash:comments>
		
		
		<post-id xmlns="com-wordpress:feed-additions:1">540</post-id>
		<media:content url="https://0.gravatar.com/avatar/fd9213b3112b1f8bb129657b460f75e9d51add22e5960fc68bd1cb408131ec93?s=96&#38;d=https%3A%2F%2F0.gravatar.com%2Favatar%2Fad516503a11cd5ca435acc9bb6523536%3Fs%3D96&#38;r=G" medium="image">
			<media:title type="html">stanleyjohns</media:title>
		</media:content>
	</item>
		<item>
		<title>Implicit and explicit transactions.</title>
		<link>https://stanleyjohns.wordpress.com/2013/03/01/implicit-and-explicit-transactions/</link>
					<comments>https://stanleyjohns.wordpress.com/2013/03/01/implicit-and-explicit-transactions/#comments</comments>
		
		<dc:creator><![CDATA[stanleyjohns]]></dc:creator>
		<pubDate>Fri, 01 Mar 2013 19:48:45 +0000</pubDate>
				<category><![CDATA[SQL server]]></category>
		<category><![CDATA[SQLServerPedia Syndication]]></category>
		<category><![CDATA[data and log files]]></category>
		<category><![CDATA[performance]]></category>
		<category><![CDATA[tsql]]></category>
		<guid isPermaLink="false">http://stanleyjohns.wordpress.com/?p=528</guid>

					<description><![CDATA[There are two ways a query can be committed in SQL. Implicitly and explicitly. Queries that have use the begin tran/commit statements are performing explicit transactions. Queries without the begin tran/commit statements are implicitly committed. There are some performance implications when not explicitly commiting a transaction. Example below: &#8212; Create the table CREATE table testins [&#8230;]]]></description>
		
					<wfw:commentRss>https://stanleyjohns.wordpress.com/2013/03/01/implicit-and-explicit-transactions/feed/</wfw:commentRss>
			<slash:comments>1</slash:comments>
		
		
		<post-id xmlns="com-wordpress:feed-additions:1">528</post-id>
		<media:content url="https://0.gravatar.com/avatar/fd9213b3112b1f8bb129657b460f75e9d51add22e5960fc68bd1cb408131ec93?s=96&#38;d=https%3A%2F%2F0.gravatar.com%2Favatar%2Fad516503a11cd5ca435acc9bb6523536%3Fs%3D96&#38;r=G" medium="image">
			<media:title type="html">stanleyjohns</media:title>
		</media:content>
	</item>
		<item>
		<title>Finding the size of a data type.</title>
		<link>https://stanleyjohns.wordpress.com/2013/03/01/finding-the-size-of-a-data-type/</link>
					<comments>https://stanleyjohns.wordpress.com/2013/03/01/finding-the-size-of-a-data-type/#respond</comments>
		
		<dc:creator><![CDATA[stanleyjohns]]></dc:creator>
		<pubDate>Fri, 01 Mar 2013 17:44:14 +0000</pubDate>
				<category><![CDATA[SQL server]]></category>
		<category><![CDATA[SQLServerPedia Syndication]]></category>
		<category><![CDATA[performance]]></category>
		<category><![CDATA[tsql]]></category>
		<guid isPermaLink="false">http://stanleyjohns.wordpress.com/?p=526</guid>

					<description><![CDATA[When doing capacity planning, it is important to know the space that will be required for a row of data. This will also help with performance because if you can change your schema to pull in more rows into a buffer page (without degrading other aspects), then you will have better performance. One function you [&#8230;]]]></description>
		
					<wfw:commentRss>https://stanleyjohns.wordpress.com/2013/03/01/finding-the-size-of-a-data-type/feed/</wfw:commentRss>
			<slash:comments>0</slash:comments>
		
		
		<post-id xmlns="com-wordpress:feed-additions:1">526</post-id>
		<media:content url="https://0.gravatar.com/avatar/fd9213b3112b1f8bb129657b460f75e9d51add22e5960fc68bd1cb408131ec93?s=96&#38;d=https%3A%2F%2F0.gravatar.com%2Favatar%2Fad516503a11cd5ca435acc9bb6523536%3Fs%3D96&#38;r=G" medium="image">
			<media:title type="html">stanleyjohns</media:title>
		</media:content>
	</item>
		<item>
		<title>Breaking down dates using DATEPART.</title>
		<link>https://stanleyjohns.wordpress.com/2013/03/01/breaking-down-dates-using-datepart/</link>
					<comments>https://stanleyjohns.wordpress.com/2013/03/01/breaking-down-dates-using-datepart/#respond</comments>
		
		<dc:creator><![CDATA[stanleyjohns]]></dc:creator>
		<pubDate>Fri, 01 Mar 2013 17:14:23 +0000</pubDate>
				<category><![CDATA[SQL server]]></category>
		<category><![CDATA[SQLServerPedia Syndication]]></category>
		<category><![CDATA[ssrs]]></category>
		<category><![CDATA[tsql]]></category>
		<guid isPermaLink="false">http://stanleyjohns.wordpress.com/?p=523</guid>

					<description><![CDATA[You may have written ad-hoc queries to pull data for a certain date range. As this report gets popular over time and the date range expands, you may be asked to do a break down of the report. For example: per month or querter. The magical function that helps with this purpose is the DATEPART [&#8230;]]]></description>
		
					<wfw:commentRss>https://stanleyjohns.wordpress.com/2013/03/01/breaking-down-dates-using-datepart/feed/</wfw:commentRss>
			<slash:comments>0</slash:comments>
		
		
		<post-id xmlns="com-wordpress:feed-additions:1">523</post-id>
		<media:content url="https://0.gravatar.com/avatar/fd9213b3112b1f8bb129657b460f75e9d51add22e5960fc68bd1cb408131ec93?s=96&#38;d=https%3A%2F%2F0.gravatar.com%2Favatar%2Fad516503a11cd5ca435acc9bb6523536%3Fs%3D96&#38;r=G" medium="image">
			<media:title type="html">stanleyjohns</media:title>
		</media:content>
	</item>
		<item>
		<title>AppDomain 2 (dbname.dbo[runtime].745) created message in error log.</title>
		<link>https://stanleyjohns.wordpress.com/2013/02/26/appdomain-2-dbname-dboruntime-745-created-message-in-error-log/</link>
					<comments>https://stanleyjohns.wordpress.com/2013/02/26/appdomain-2-dbname-dboruntime-745-created-message-in-error-log/#respond</comments>
		
		<dc:creator><![CDATA[stanleyjohns]]></dc:creator>
		<pubDate>Tue, 26 Feb 2013 20:17:14 +0000</pubDate>
				<category><![CDATA[SQL server]]></category>
		<category><![CDATA[SQLServerPedia Syndication]]></category>
		<category><![CDATA[clr]]></category>
		<category><![CDATA[error logs]]></category>
		<category><![CDATA[memory]]></category>
		<guid isPermaLink="false">http://stanleyjohns.wordpress.com/?p=519</guid>

					<description><![CDATA[This message is related to the CLRs created in the DB. The message will usually be: AppDomain some_number (dbname.dbo[runtime].some_number) created. To see the AppDomains currently online in the DB, run the command: select * from sys.dm_clr_appdomains. This will show you the DB and user id under which these CLRs are running. Other related DMVs are: [&#8230;]]]></description>
		
					<wfw:commentRss>https://stanleyjohns.wordpress.com/2013/02/26/appdomain-2-dbname-dboruntime-745-created-message-in-error-log/feed/</wfw:commentRss>
			<slash:comments>0</slash:comments>
		
		
		<post-id xmlns="com-wordpress:feed-additions:1">519</post-id>
		<media:content url="https://0.gravatar.com/avatar/fd9213b3112b1f8bb129657b460f75e9d51add22e5960fc68bd1cb408131ec93?s=96&#38;d=https%3A%2F%2F0.gravatar.com%2Favatar%2Fad516503a11cd5ca435acc9bb6523536%3Fs%3D96&#38;r=G" medium="image">
			<media:title type="html">stanleyjohns</media:title>
		</media:content>
	</item>
		<item>
		<title>CTE (Common Table Expressions) and sub queries.</title>
		<link>https://stanleyjohns.wordpress.com/2013/02/20/cte-common-table-expressions-and-sub-queries/</link>
					<comments>https://stanleyjohns.wordpress.com/2013/02/20/cte-common-table-expressions-and-sub-queries/#respond</comments>
		
		<dc:creator><![CDATA[stanleyjohns]]></dc:creator>
		<pubDate>Wed, 20 Feb 2013 22:17:30 +0000</pubDate>
				<category><![CDATA[SQL server]]></category>
		<category><![CDATA[SQLServerPedia Syndication]]></category>
		<category><![CDATA[tips]]></category>
		<category><![CDATA[tsql]]></category>
		<guid isPermaLink="false">http://stanleyjohns.wordpress.com/?p=511</guid>

					<description><![CDATA[Common Table Expressions or CTEs can be used to create temporary result sets based on another query. The CTE is not saved as a DB object and has the same lifetime of the query. CTEs come in handy when a recursive query is required, or when you need to aggregate on top of another select [&#8230;]]]></description>
		
					<wfw:commentRss>https://stanleyjohns.wordpress.com/2013/02/20/cte-common-table-expressions-and-sub-queries/feed/</wfw:commentRss>
			<slash:comments>0</slash:comments>
		
		
		<post-id xmlns="com-wordpress:feed-additions:1">511</post-id>
		<media:content url="https://0.gravatar.com/avatar/fd9213b3112b1f8bb129657b460f75e9d51add22e5960fc68bd1cb408131ec93?s=96&#38;d=https%3A%2F%2F0.gravatar.com%2Favatar%2Fad516503a11cd5ca435acc9bb6523536%3Fs%3D96&#38;r=G" medium="image">
			<media:title type="html">stanleyjohns</media:title>
		</media:content>
	</item>
		<item>
		<title>Changing the name of the SQL server (@@servername)</title>
		<link>https://stanleyjohns.wordpress.com/2013/01/21/changing-the-name-of-the-sql-server-servername/</link>
					<comments>https://stanleyjohns.wordpress.com/2013/01/21/changing-the-name-of-the-sql-server-servername/#comments</comments>
		
		<dc:creator><![CDATA[stanleyjohns]]></dc:creator>
		<pubDate>Mon, 21 Jan 2013 15:38:28 +0000</pubDate>
				<category><![CDATA[SQL server]]></category>
		<category><![CDATA[SQLServerPedia Syndication]]></category>
		<category><![CDATA[install]]></category>
		<category><![CDATA[settings]]></category>
		<category><![CDATA[tsql]]></category>
		<guid isPermaLink="false">http://stanleyjohns.wordpress.com/?p=508</guid>

					<description><![CDATA[I was in the process of installing SCOM2012 and came to the part where I had to specify the SQL server name. I quickly logged onto the SQL server and ran SELECT @@servername to double check the SQL server name. Surprisingly, the server name was wrong. The OS server name was sqlcloud, but the SQL [&#8230;]]]></description>
		
					<wfw:commentRss>https://stanleyjohns.wordpress.com/2013/01/21/changing-the-name-of-the-sql-server-servername/feed/</wfw:commentRss>
			<slash:comments>2</slash:comments>
		
		
		<post-id xmlns="com-wordpress:feed-additions:1">508</post-id>
		<media:content url="https://0.gravatar.com/avatar/fd9213b3112b1f8bb129657b460f75e9d51add22e5960fc68bd1cb408131ec93?s=96&#38;d=https%3A%2F%2F0.gravatar.com%2Favatar%2Fad516503a11cd5ca435acc9bb6523536%3Fs%3D96&#38;r=G" medium="image">
			<media:title type="html">stanleyjohns</media:title>
		</media:content>
	</item>
	</channel>
</rss>
