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 1…

Read this article

Moving a table to another filegroup

So, how does one move a table to another filegroup.Say I have the following table:CREATE TABLE [dbo].[Tests]( [TestID] [int] NOT NULL, [TestInt] [int] NOT NULL, [TestBigInt] [bigint] NOT…

Read this article

Find duplicate rows in MS SQL

So, the other day I was reading T-SQL: Why “It Depends” and in the comments section a guys suggested using the “PARTITION BY” in the OVER clause.I thought was the heck does that do … so i searched the…

Read this article