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…
Category: Microsoft SQL
Partitioning
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….
Missed Deadlines
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…
Partition Schemes
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…
Sub-query Modifiers
I’ll be honest, I thought I knew all there was to know about sub-queries. Turns out, there is something new (at least to me). You can modify your sub-query to allow you to pass multiple results. The way you do this is you add (ANY | SOME) or ALL to the query. Let me illustrate….
Microsoft Exam 70-433 (part 7)
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…
Microsoft Exam 70-433 (part 6)
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…
Microsoft Exam 70-433 (part 5)
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…
Microsoft Exam 70-433 (part 4)
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…
Microsoft Exam 70-433 (part 3)
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…