select @@Servername Use this command to get the exact name of the instance.

· Go to RUN –> Type sqlservermanager.msc · Right click on SQL Server(instance name) service and click on properties · Click on Advanced tab · In the start up parameters…

Answer is a straight No,however there are some 3rd party add-ins which you can try and by no way we can say its bug free T-SQL can be used easily…

Release to Manufacturing (RTM) is a milestone where the product will be available for users to download.

  Right click on the database and choose ‘Tasks’ and go for the option ‘Generate Scripts’. This is wonderful tool which allows you to generate scripts for all the objects…

SELECT INTO command helps you to do this : SELECT  * INTO Test_Datafrom HumanResources.Employee Test_Data will be a  new permanent table and data from Employee will be transferred as it…

There are two types of sub queries : 1. Non correlated 2. Correlated Correlated – This is a situation where the Sub Query uses a Col or more Col’s from…

There are 7 types of data types which are native for SQL,they are : 1. Exact numeric – bigint,int,smallint,tinyint,decimal,numeric.2. Approximate numeric – float,real.3. Monetary – money,smallmoney.4. Date and Time –…

1. Permanent Table2. Temporary Table3.Table Variable Permanent table is our normal table which we create from Create Table Table Name command,however Temp are of two types : a) Local Temp…

You can use the clause called TableSample for this purpose. Select * from DatabaseLogTableSample(10 percent) TABLESAMPLE was introduced in SQL Server 2005.