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

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