Monthly Archives: September 2010

Delete duplicate rows in sql server

Fist way: Second way from sqlauthority.com:

Posted in Joy of T-SQL, T-SQL Tips & Tricks | Leave a comment

Determing SQL Server Table Size

First create bellow sp : Then, just execute and enjoy:

Posted in Database Administration, T-SQL Tips & Tricks | Leave a comment

How to identify Installed SQL Server version and edition

Posted in Database Administration, T-SQL Tips & Tricks | Leave a comment

Free sql server buffer cache

Posted in Database Administration, T-SQL Tips & Tricks | Leave a comment

select distinct row_number

As you see in above query, when we want use DISTINCT with ROW_NUMBER, we get strange result.This is because the ROW_NUMBER is processed before the DISTINCT clause.So we can use this one:

Posted in Joy of T-SQL, T-SQL Tips & Tricks | 1 Comment