Reduce heap table fragmentation
A table that does not have a clustered index is referred to as a Heap. While a lot has been...
2011-12-09
7,190 reads
A table that does not have a clustered index is referred to as a Heap. While a lot has been...
2011-12-09
7,190 reads
If you are using Visio 2010 and creating tables via the Database Model Diagram template, you may be surprised to...
2011-12-07
2,339 reads
The SQL Server 2012 Developer Training Kit has been updated with a bunch of new content (download it here). This...
2011-12-05
1,133 reads
Microsoft has posted the licensing for SQL Server 2012. It has simplified licensing: SQL Server 2012 will offer two licensing...
2011-12-02
1,512 reads
Behind the scenes in SSIS, the data flow engine uses a buffer-oriented architecture to efficiently load and manipulate datasets in...
2011-11-30
16,640 reads
Dimensions are often recycled for multiple purposes within the same database. For instance, a “Date” dimension can be used for...
2011-11-28
4,888 reads
A conformed dimension is a dimension that has the same meaning to every fact with which it relates. Conformed dimensions allow...
2011-11-21
3,527 reads
A reference dimension occurs when the key column for the dimension is joined indirectly to the fact table through a...
2011-11-18
1,478 reads
SQL Server 2012 RC0 (Release Candidate 0), formerly known as SQL Server Denali, is now available for download. SQL Server 2012...
2011-11-17
1,099 reads
Degenerate dimensions, also called fact dimensions, are standard dimensions that are constructed from attribute columns in fact tables instead of...
2011-11-16
5,004 reads
You can find the slides and SQL scripts for my session “Spice up your...
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
Hi, to all of you who are using CA certs on SQL Server boxes...
Comments posted to this topic are about the item It's Never Just One Thing
Comments posted to this topic are about the item Calculating Min-Max Normalization in PowerBI
If I want to run sp_readerrorlog on SQL Server 2025, what permissions do I need?
See possible answers