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…
Category: MS SQL Server
What are Versions and Editions in SQL Server?
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…
SQL Server Tips and Tricks
Checking SQL Service Running Status !! SELECT dss.[status_desc],servicename,startup_type_desc,service_accountFROM sys.dm_server_services dssWHERE Read More…
SQL Server administration best practices
This article explains best practices for system administration in a Microsoft SQL Server 7.0 / 2000 environment, including regular maintenance tasks.Read More…
What is Difference Between SQL and T-SQL
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…
What are SQL Server DBA Responsibilities?
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…
SQL Server Performance Tuning
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…
SQL Server: Database Basics
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…