Category: DatabaseAdministration
DatabaseAdministration
SQL Server – OUTPUT CLAUSE – SIMPLE –EXAMPLE
Output clause will return information from or...
Varun R
SQL Server – What are Synonyms in SQL Server?
From the name itself we can guess that SYNONYMS...
Varun R
SQL SERVER – SQL SERVER 2008 R2 Installation – Enterprise/Developer Edition
Installation of SQL Server 2008 R2...
Varun R
SQL SERVER – DBCC SHRINK FILE – Truncate T-Log
Today afternoon one our database T-Log was full...
Varun R
SQL SERVER –SP_HELPDB – How to find the size of the databases?
Reference: An i-book for SQL Server by Varun R
Varun R
SQL SERVER-FILESTREAM- What is FILESTREAM in SQL Server?
Why file stream Generally we will not store...
Varun R
SQL SERVER – CLEAN CACHE(Stored Procedure) AND BUFFER-DBCC FREEPROCACHE,DBCC DROPCLEANBUFFERS
While I am working on terabyte database...
Varun R