dba
Partitioning: MERGE, SPLIT, and SWITCH
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.
Latest
microsoft sql
Partitioned Tables and Indexes
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
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
training
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
dba
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
SQL301
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
Posted in: Microsoft SQL
Quick Update
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
Posted in: Microsoft SQL
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...
Posted in: Microsoft SQL
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...
microsoft sql
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
microsoft sql
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
microsoft sql
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