MS SQL Script for table size
When having 200 tables and you sure none of then should really have any data but still the size is 170 MB for a BACPAK file ... Disk size…
Posted on December 15th, 2018
Moving a table to another filegroup
So, how does one move a table to another filegroup. Say I have the following table: Since tables are always stored with the clustered index…
Posted on July 20th, 2010
Find duplicate rows in MS SQL
So, the other day I was reading T-SQL: Why “It Depends” and in the comment section a guy suggested using the “PARTITION BY” in the OVER…
Posted on July 9th, 2010