Showing posts with label Partitioning. Show all posts
Showing posts with label Partitioning. Show all posts
Monday, September 11, 2017

SQL Server - Merging Partitions - Does it physically move data from a data file to another?

›
Partitioning is a common practice when maintaining large number of records in tables regardless of the database type: whether the database...
Sunday, December 18, 2016

Moving a table with millions of records to another within a second - SQL Server Brain Basher of the Week #061

›
This is a very common Interview Question and many come with different solutions but most forget some easy ways of doing it. Sometime we ne...
Thursday, September 1, 2016

SQL Server Lock Escalation and handling it at partition level

›
SQL Server locking mechanism makes sure that database is consistence during a transaction and it makes the database available for as much ...
Friday, July 29, 2016

Fact Loading: Switching a loaded temporary table into an empty partition of the fact table

›
Fact table in data warehouses are always partitioned and with most of solutions, it is partitioned on a date key. Generally, we use SSIS f...
Thursday, May 19, 2016

Truncating Partitions - SQL Server 2016 TSQL Enhancements

›
For a speedy delete or cleaning the table and resetting some of the properties of the table, we use TRUNCATE TABLE statement. This was rea...
1 comment:
Saturday, May 23, 2015

Fact Table: Clustered index on date key is enough or partitioning should be done with it?

›
Fact table in a data warehouse (or a large table in an OLTP database) always holds millions of records and we keep on adding records large...
Sunday, May 17, 2015

SQL Server Brain Basher of the Week #012 - Partitions

›
While I was discussing Partitioning with one of my discussions in this week, one enthusiast asked whether how many partitions can be crea...