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,127 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,127 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,326 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,130 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,509 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,628 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,877 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,514 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,471 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,096 reads
Degenerate dimensions, also called fact dimensions, are standard dimensions that are constructed from attribute columns in fact tables instead of...
2011-11-16
4,984 reads
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
Hub Cs:08218154374 Jl. Sudirman No.59, Bukit Cangang Kayu Ramang, Kec. Guguk Panjang, Kota Bukittinggi,...
Hub Cs:08218154374 Jl. H. Agus Salim No.10 A, Sawahan, Kec. Padang Tim., Kota Padang,...
Comments posted to this topic are about the item SSRS Reminded Me of the...
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37 4 NULLWhat is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 4;See possible answers