Tag Archives: 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. 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 [...]

Comments ( 2 )

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 [...]

 

Comments ( 4 )

Introduction to Master Data Services

You find yourself sitting in front of your machine late one evening. Everyone has gone home for the night except for you. You’ve left a scan running to identify all the SQL Servers on your network, and two new ones appear. accountingSQL and humanResourceSQL. You begin to document these two new servers, and notice the [...]

Comments ( 0 )