SQL Scripts

That Make Your Life Easier

You want to backup or restore a database but you cannot see […]
Let's assume that you have created separate datafile for non-clustered indexes but […]
SELECT NAME,NAME ‘password’FROM sys.sql_loginsWHERE Pwdcompare(NAME, password_hash) = 1UNIONSELECT NAME,‘Blank’ AS ‘password’FROM sys.sql_loginsWHERE […]
This query helps you identify your tables and calculate size/rowcount ratio easily: […]
Assume that all we know why we are using IDENTITY column in […]
SQL Server için tanımlanan memory alanı ne kadar yeterli sorusuna en iyi […]
When any connection starts the value of the SET LOCK_TIMEOUT is -1, which […]