2020-03-23
967 reads
Partitioned Tables
Creating a table with horizontal partitioning in SQL Server
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
Partitioned Table and Index Strategies Using SQL Server 2008
The Microsoft SQL Server 2008 database software provides table partitioning to make such operations more manageable.
2009-07-10
3,009 reads
Configuring Replication for Partitioned Tables Using T-SQL
New author Michelle Ufford brings us an article that shows how you can replicate those partitioned tables in your environment.
2009-01-29
6,484 reads
Blogs
Fabric as a Data Mesh Enabler: Rethinking Enterprise Data Distribution
By Chris Yates
For decades, enterprises have approached data management with the same mindset as someone stuffing...
Truncate Table Pitfalls
Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....
dataMinds Connect 2025 – Slides & Scripts
You can find all the session materials for the presentation “Indexing for Dummies” that...
Forums
Technological Dinosaurs or Social Dinosaurs?
Comments posted to this topic are about the item Technological Dinosaurs or Social Dinosaurs?
DBCC CHECKIDENT
Comments posted to this topic are about the item DBCC CHECKIDENT
Question of the Day
DBCC CHECKIDENT
What is returned as a result set when I run this command without a new seed value?
See possible answers