Author Archives: Gaurav



Syntax: SET SHOWPLAN_ALL { ON OFF }The setting of SET SHOWPLAN_ALL is set at execute or run time and not at parse time. Run folowing SqlUSE pubsGOSET SHOWPLAN_ALL ONGO— First query.SELECT au_idFROM authorsWHERE au_id = ‘409-56-7008’GO— Second query.SELECT cityFROM authorsWHERE city LIKE ‘San%’GOSET SHOWPLAN_ALL OFFGO Query plan for above is as followed


Understanding SQL Server Indexing

A very good Article written by : Edgewood Solutions Engineers Problem: With so many aspects of SQL Server to cover and to write about, some of the basic principals are often overlooked. There have been several people that have asked questions about indexing along with a general overview of the differences of clustered and non

Read More

Working with Stored procedures

Stored procedure helps to make your work easy. With the help of these you just have to supply some parameters only. The Code snippet using storedprocedures describes a way to use stored procedures.

Working with Transactions

Whenever you have to update more than one table or destinations then it must have to sure that the operation done successfully because some time it has been seen that one table updated but due to some error another(s) not. To overcome this problem you have Transactions. In ADO.Net transactions are initiated by calling BeginTransaction()

Read More

Difference between abstract classes and interfaces

Very basic question but important to point out. Abstract classes can have concrete methods while interfaces have no methods implemented. Interfaces do not come in inheriting chain, while abstract classes come in inheriting chain. Interfaces have only pure virtual abstract method, while abstract classes may have non-abstract methods. All members are public [by default] in

Read More

How to locate names of all columns in a table?

I found the following query is very much worth-full when you are looking for names of all columns in a table SELECT ( AS [Table Name], o.type, AS [Col Name], AS [Col Type], c.prec, c.scale, c.isnullableFROM dbo.sysobjects AS o INNER JOIN dbo.syscolumns AS c ON = INNER JOIN dbo.systypes AS s

Read More

Testing a Private Assembly

Lets start to create a client application for privateassembly, Open a notepad and write following code [till now you have not created any client application using visual studio, you will do the same very soon in ASP.Net section]. For this example lets create a client application using Console application from templates pane [windows applications are

Read More