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 […]
You can get information about your operating system ,cpu and versions that your SQL is running on: SELECT @@SERVERNAME AS […]
PLE UnfortRAMs are limited Unfortunately, RAMs are limited and SQL Server needs memory. If you wonder that you have any […]
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ı […]