Building (or rebuilding) a Columnstore index can be a resource intensive operation. In this article, Denzil Ribeiro describes the index rebuild process and index maintenance for clustered Columnstore indexes in SQL 2014.
2015-07-31
2,990 reads
Detecting file differences on two different web servers using T-SQL.
2015-07-30
5,840 reads
The latest version of tSQLt is now available with some SQL Prompt snippets to help you get started.
2015-07-30
1,758 reads
Tim Smith looks at what to take into consideration before building a design to archive old data in SQL Server databases.
2015-07-30
2,895 reads
One of the more confusing statistics in Oracle is one called the clustering factor. Associated with an index, it's actually dependent on the table data, more specifically the distance between 'jumps' for a given index key. Commonly, a 'jump' is the number of blocks between rows containing the given index key starting with the first block found containing that key. If that sounds confusing don't despair, David Fitzjarrell explains in detail.
2015-07-29
3,764 reads
MSDB is a system database used by SQL Server. MSDB stores all sorts of data, such as backup history, log shipping monitor history, SSIS packages and Service Broker queue data to name a few. Just like user databases, MSDB needs regular maintenance, including index optimizations and, more importantly, regular purging. In this article, Tim Radney looks at how neglecting your MSDB can negatively impact on your environment.
2015-07-28
6,714 reads
References and links to get you started in backing up your database to the Azure blob storage.
2015-07-27
815 reads
Code must be checked, but how? Phil Factor shares his thoughts on automating SQL code reviews.
2015-07-27
5,104 reads
Discusses the various SAN and NAS protocols (FC, iSCSI, NFS) and how choosing one over the other can impact your SQL Server Performance.
2015-07-24 (first published: 2012-04-24)
18,223 reads
A short explanation and infographic of what SQL is. For the non-SQL people in your life.
2015-07-24
8,743 reads
By Steve Jones
At Redgate, we’re experimenting with how AI can help developers and DBAs become better...
I was messing around performing investigative work on a pod running SQL Server 2025...
By Steve Jones
Redgate recently released SQL Compare v16, which included a new feature to work with...
Comments posted to this topic are about the item What is Page Density
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Looking to confirm my understanding of these three products and how they can be...
In SQL Server, there is a concept of page density. This is determined by how much data is stored on each page. What is a page density of 90%?
See possible answers