<?xml version="1.0" encoding="UTF-8"?><rss version="0.92">
<channel>
	<title>ToyboxCreations</title>
	<link>http://toyboxcreations.net</link>
	<description>SELECT * FROM [My Life]</description>
	<lastBuildDate>Wed, 25 Aug 2010 14:59:21 +0000</lastBuildDate>
	<docs>http://backend.userland.com/rss092</docs>
	<language>en</language>
	<!-- generator="WordPress/3.0.1" -->

	<item>
		<title>Modifying Data in Partitioned Views</title>
		<description><![CDATA[Yesterday I covered the basics of partitioned views.  I also mentioned there were some gotchas when it comes to modifying the data in those partitioned views.  I'd like to go into more detail about that today.  The first big gotcha on updating data in a partitioned view is making sure you can update the data [...]


Related posts:<ol><li><a href='http://toyboxcreations.net/2010/08/partitioned-views/' rel='bookmark' title='Permanent Link: Partitioned Views'>Partitioned Views</a></li>
<li><a href='http://toyboxcreations.net/2008/12/sql-301-views/' rel='bookmark' title='Permanent Link: SQL 301 &#8211; Views'>SQL 301 &#8211; Views</a></li>
<li><a href='http://toyboxcreations.net/2010/08/partitioned-tables-and-indexes/' rel='bookmark' title='Permanent Link: Partitioned Tables and Indexes'>Partitioned Tables and Indexes</a></li>
</ol>]]></description>
		<link>http://toyboxcreations.net/2010/08/modifying-data-in-partitioned-views/</link>
			</item>
	<item>
		<title>Partitioned Views</title>
		<description><![CDATA[Last week I covered partitioning.  I explained how you could set up filegroups in your database, and then split data from a single table or index across those filegroups.  That way you can reduce blocking in your objects by physically separating the data into parts.  I even covered how you could use partitioning to speed [...]


Related posts:<ol><li><a href='http://toyboxcreations.net/2010/08/modifying-data-in-partitioned-views/' rel='bookmark' title='Permanent Link: Modifying Data in Partitioned Views'>Modifying Data in Partitioned Views</a></li>
<li><a href='http://toyboxcreations.net/2008/12/sql-301-views/' rel='bookmark' title='Permanent Link: SQL 301 &#8211; Views'>SQL 301 &#8211; Views</a></li>
<li><a href='http://toyboxcreations.net/2006/08/sql-201-views/' rel='bookmark' title='Permanent Link: SQL 201 &#8211; Views'>SQL 201 &#8211; Views</a></li>
</ol>]]></description>
		<link>http://toyboxcreations.net/2010/08/partitioned-views/</link>
			</item>
	<item>
		<title>Partitioning: MERGE, SPLIT, and SWITCH</title>
		<description><![CDATA[OK, you know how to set up partitioning for a table and an index, and now you think you've solved your deadlocking, and your I/O issues forever, right? Hardly. Once you've been in SQL long enough you learn that no answer is forever.  Inevitably you'll have to revisit your old queries and see if their [...]


Related posts:<ol><li><a href='http://toyboxcreations.net/2010/08/partitioning/' rel='bookmark' title='Permanent Link: Partitioning'>Partitioning</a></li>
<li><a href='http://toyboxcreations.net/2010/08/partition-schemes/' rel='bookmark' title='Permanent Link: Partition Schemes'>Partition Schemes</a></li>
<li><a href='http://toyboxcreations.net/2010/08/partitioned-tables-and-indexes/' rel='bookmark' title='Permanent Link: Partitioned Tables and Indexes'>Partitioned Tables and Indexes</a></li>
</ol>]]></description>
		<link>http://toyboxcreations.net/2010/08/partitioning-merge-split-and-switch/</link>
			</item>
	<item>
		<title>Partitioned Tables and Indexes</title>
		<description><![CDATA[Ok, at this point you should know how to set up a PARTITION FUNCTION and a PARTITION SCHEME.  Now, we're going to move on and apply this SCHEME (and in turn the FUNCTION) to a table and an Index.  I'm going to include a little recap, just in case you've missed anything so far.  All [...]


Related posts:<ol><li><a href='http://toyboxcreations.net/2010/08/partition-schemes/' rel='bookmark' title='Permanent Link: Partition Schemes'>Partition Schemes</a></li>
<li><a href='http://toyboxcreations.net/2010/08/partitioned-views/' rel='bookmark' title='Permanent Link: Partitioned Views'>Partitioned Views</a></li>
<li><a href='http://toyboxcreations.net/2010/08/partitioning-merge-split-and-switch/' rel='bookmark' title='Permanent Link: Partitioning: MERGE, SPLIT, and SWITCH'>Partitioning: MERGE, SPLIT, and SWITCH</a></li>
</ol>]]></description>
		<link>http://toyboxcreations.net/2010/08/partitioned-tables-and-indexes/</link>
			</item>
	<item>
		<title>Partition Schemes</title>
		<description><![CDATA[In my last article I started covering partitioning.  I'm going to pick that up and continue with how to create your database to use multiple filegroups.  Without multiple filegroups, you aren't going to see how partitioning can really improve your database's performance.  Let's set up the database that's going to house our table of items [...]


Related posts:<ol><li><a href='http://toyboxcreations.net/2010/08/partitioning-merge-split-and-switch/' rel='bookmark' title='Permanent Link: Partitioning: MERGE, SPLIT, and SWITCH'>Partitioning: MERGE, SPLIT, and SWITCH</a></li>
<li><a href='http://toyboxcreations.net/2010/08/partitioned-tables-and-indexes/' rel='bookmark' title='Permanent Link: Partitioned Tables and Indexes'>Partitioned Tables and Indexes</a></li>
<li><a href='http://toyboxcreations.net/2009/06/index-on-partition_scheme_name-filegroup_name-and-default/' rel='bookmark' title='Permanent Link: INDEX ON partition_scheme_name, filegroup_name, and default'>INDEX ON partition_scheme_name, filegroup_name, and default</a></li>
</ol>]]></description>
		<link>http://toyboxcreations.net/2010/08/partition-schemes/</link>
			</item>
	<item>
		<title>Partitioning</title>
		<description><![CDATA[Partitioning was a feature added with Microsoft SQL 2005 to allow users to split up large tables across multiple storage locations.  Partitioning can be applied to tables, indexes and indexed views.  By partitioning the data across multiple locations you can speed up query times, reduce contention between queries, and improve overall performance under certain conditions. [...]


Related posts:<ol><li><a href='http://toyboxcreations.net/2010/08/partitioning-merge-split-and-switch/' rel='bookmark' title='Permanent Link: Partitioning: MERGE, SPLIT, and SWITCH'>Partitioning: MERGE, SPLIT, and SWITCH</a></li>
<li><a href='http://toyboxcreations.net/2010/08/partition-schemes/' rel='bookmark' title='Permanent Link: Partition Schemes'>Partition Schemes</a></li>
<li><a href='http://toyboxcreations.net/2010/08/partitioned-tables-and-indexes/' rel='bookmark' title='Permanent Link: Partitioned Tables and Indexes'>Partitioned Tables and Indexes</a></li>
</ol>]]></description>
		<link>http://toyboxcreations.net/2010/08/partitioning/</link>
			</item>
	<item>
		<title>Missed Deadlines</title>
		<description><![CDATA[Looks like I missed my personal deadline to take my 70-433 last month.  I let myself get wrapped up in the final phases of development on a conversion I've built for Wachovia/Wells Fargo.  The good news is the extra effort has paid off in testing.  We've worked through the first round of testing with only [...]


Related posts:<ol><li><a href='http://toyboxcreations.net/2006/07/a-series-for-database-administration/' rel='bookmark' title='Permanent Link: A Series for Database Administration'>A Series for Database Administration</a></li>
<li><a href='http://toyboxcreations.net/2007/05/renaming-a-database/' rel='bookmark' title='Permanent Link: Renaming a Database'>Renaming a Database</a></li>
<li><a href='http://toyboxcreations.net/2006/08/sql-201-views/' rel='bookmark' title='Permanent Link: SQL 201 &#8211; Views'>SQL 201 &#8211; Views</a></li>
</ol>]]></description>
		<link>http://toyboxcreations.net/2010/08/missed-deadlines/</link>
			</item>
	<item>
		<title>Quick Update</title>
		<description><![CDATA[I'm currently working on a batch of 12 articles that will fill in details on the study guides I've published over the last week.  These articles are all a part of the training I've being putting myself through to take the 70-433 at the end of this month. Heh. Considering how busy I've been between [...]


Related posts:<ol><li><a href='http://toyboxcreations.net/2006/02/sql-101-update/' rel='bookmark' title='Permanent Link: SQL 101 &#8211; UPDATE'>SQL 101 &#8211; UPDATE</a></li>
<li><a href='http://toyboxcreations.net/2008/06/update-triggers/' rel='bookmark' title='Permanent Link: UPDATE Triggers'>UPDATE Triggers</a></li>
<li><a href='http://toyboxcreations.net/2005/01/project-1/' rel='bookmark' title='Permanent Link: Project 1'>Project 1</a></li>
</ol>]]></description>
		<link>http://toyboxcreations.net/2010/07/quick-update/</link>
			</item>
	<item>
		<title>Microsoft Exam 70-433 (part 7)</title>
		<description><![CDATA[I'm putting together a new series to cover the materials you'll need to know in order to pass the 70-433.  Microsoft's exam that covers Database Development using Microsoft SQL Server 2008.  I'm going to list the topics covered in several posts, each one will include links to details to those topics.  If you have any [...]


Related posts:<ol><li><a href='http://toyboxcreations.net/2010/06/microsoft-exam-70-433-part-4/' rel='bookmark' title='Permanent Link: Microsoft Exam 70-433 (part 4)'>Microsoft Exam 70-433 (part 4)</a></li>
<li><a href='http://toyboxcreations.net/2010/07/microsoft-exam-70-433-part-5/' rel='bookmark' title='Permanent Link: Microsoft Exam 70-433 (part 5)'>Microsoft Exam 70-433 (part 5)</a></li>
<li><a href='http://toyboxcreations.net/2010/07/microsoft-exam-70-433-part-6/' rel='bookmark' title='Permanent Link: Microsoft Exam 70-433 (part 6)'>Microsoft Exam 70-433 (part 6)</a></li>
</ol>]]></description>
		<link>http://toyboxcreations.net/2010/07/microsoft-exam-70-433-part-7/</link>
			</item>
	<item>
		<title>Microsoft Exam 70-433 (part 6)</title>
		<description><![CDATA[I'm putting together a new series to cover the materials you'll need to know in order to pass the 70-433.  Microsoft's exam that covers Database Development using Microsoft SQL Server 2008.  I'm going to list the topics covered in several posts, each one will include links to details to those topics.  If you have any [...]


Related posts:<ol><li><a href='http://toyboxcreations.net/2010/06/microsoft-exam-70-433-part-4/' rel='bookmark' title='Permanent Link: Microsoft Exam 70-433 (part 4)'>Microsoft Exam 70-433 (part 4)</a></li>
<li><a href='http://toyboxcreations.net/2010/07/microsoft-exam-70-433-part-5/' rel='bookmark' title='Permanent Link: Microsoft Exam 70-433 (part 5)'>Microsoft Exam 70-433 (part 5)</a></li>
<li><a href='http://toyboxcreations.net/2010/07/microsoft-exam-70-433-part-7/' rel='bookmark' title='Permanent Link: Microsoft Exam 70-433 (part 7)'>Microsoft Exam 70-433 (part 7)</a></li>
</ol>]]></description>
		<link>http://toyboxcreations.net/2010/07/microsoft-exam-70-433-part-6/</link>
			</item>
</channel>
</rss>
