During the planning phase I found out about the new partitioning feature in SQL Server 2005 and later editions of SQL Server. It is a vast topic with several associated operations and configurations involved. In this tip I will share what I learned about partitioning, show an example to implement horizontal table partitioning along with a comprehensive list of related benefits and considerations.
2009-07-23
4,028 reads
The Microsoft SQL Server 2008 database software provides table partitioning to make such operations more manageable.
2009-07-10
3,009 reads
New author Michelle Ufford brings us an article that shows how you can replicate those partitioned tables in your environment.
2009-01-29
5,638 reads
Lynn Pettis gives us a look at a new way to solve a T-SQL problem.
2009-01-27
12,101 reads
Let us look at another means to increase the availability of your highly critical databases. We will extend the concept of filegroups as highlighted in a previous tip on Disaster Recovery Procedures in SQL Server 2005 Part 2 (Isolating Critical Objects) wherein we can use filegroups to isolate and store a critical object.
2008-11-20
3,127 reads
This article shows how to implement an automatic sliding window in a partitioned table on Microsoft SQL Server 2005.
2008-04-11
3,976 reads
Continuing on with his series on table partitioning, Andy Warren takes a look at some fo the advanced features available in SQL Server Enterprise Edition.
2008-01-17
7,236 reads
I think you must install again, but that's not too dificult a process, just time consuming. Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones www.dkranch.net
2003-06-20
Thank you for answering. Can this be done using linked servers within one SQL Server? Eg. Server linked to itself. Currently we have one production SQL Server. Production databases and control database reside in this server. In the future we have multiple production SQL Servers, but still one Control DB in one SQL Server. We […]
2003-06-17
2 reads
2003-06-12
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers