How do you clear the SQL Server transaction log
Note : You may want to backup first. USE AdventureWorks2008R2;GO– Truncate the log by changing the database recovery model to SIMPLE.ALTER DATABARead More…
Note : You may want to backup first. USE AdventureWorks2008R2;GO– Truncate the log by changing the database recovery model to SIMPLE.ALTER DATABARead More…
What are Versions and Editions? When you read or listen something like SQL Server 2005, 2008, 2008 R2 and 2012, they are Versions of SQL Server.. Read More…
Checking SQL Service Running Status !! SELECT dss.[status_desc],servicename,startup_type_desc,service_accountFROM sys.dm_server_services dssWHERE Read More…
This article explains best practices for system administration in a Microsoft SQL Server 7.0 / 2000 environment, including regular maintenance tasks.Read More…
1) SQL is a Structured Query Language.It is developed by IBM. TSQL is the Transact SQL.It is implementation of SQL Server. Developed by Microsoft.Read More…
This is one of the most frequently asked questions by people who are new to SQL Server. Since they are new to SQL Server, their concern is understandRead More…
When dealing with performance tuning SQL Server, we can broadly classify it into 2 major areas; Physical Server related and SQL Server related. I wilRead More…
System Databases Master: composed of system tables that keep track of server installation as a whole and all other databases that are eventually cRead More…