This query helps you identify your tables and calculate size/rowcount ratio easily: USE [DatabaseName] -- replace your GO SELECTs.NameASSchemaName,t.NameASTableName,p.rowsASRowCounts,CAST(ROUND((SUM(a.used_pages) / […]
Assume that all we know why we are using IDENTITY column in a table. It you are inserting any row […]
Tüm Relational Database’lerde olduğu gibi SQL Server’da performans artışının en büyük destekçisi Index’lerdir. Index nedir? Ne işe yarar? Gibi sorulara […]
SQL Server için tanımlanan memory alanı ne kadar yeterli sorusuna en iyi cevabı verecek olan sorgudur. PLE özetle, cache üzerinde […]
Tüm veritabanı sistemlerinde olduğu gibi SQL Server’da da memory 2 farklı amaç  için kullanılır: Kendi iç sistemleri (plan cache, bazı […]
When any connection starts the value of the SET LOCK_TIMEOUT is -1, which means that the query has to wait for […]
If disk space on your SECONDARY side is full and  you want to move one of your databasefile to other […]
You need to add new datafile to your SQL SERVER that has LOGSHIPPING. So automatically same datafile will be created […]
1-     Not based on Table design, based on load As soon as creating table, you don’t need to create whole […]
You can list all errors getting from SQL Mail and than perform troubleshooting : select * from sysmail_allitemsorder by sent_date […]