What do you mean by XAML

Extensible Application Markup Language is a XML based Language for creating a rich graphical user interface XAML was first introduced in 2003 as the language be..

Different ways of moving data from databases

There are different methods of moving data

(1)BACKUP and RESTORE


(2)detaching

(3)Attaching databases


(4)Replication

(5) DTS


(6)BCP
..

What is LOCK escalation

It is the process of converting Low Level Locks to higer Level Locks.Example of LLL(Low Level locks) is row locks and HLL(Higher Level Locks) is table lock.Ever..

How and when to use LIKE statement

The LIKE condition allows us to use wildcards in the where clause of an SQL query.

(1)% allows you to match any string of any length (including zero length..

How to encode a string

string ss="pervej";

string encode=Convert.ToBase64String(System.Text.Encoding.UTF8.GetBytes(ss));


Response.Write(encode);

What are the different index configurations a table can have

(1)No indexes

(2)A clustered index


(3)A clustered index and many nonclustered indexes

(4)A nonclustered index


(5)Many nonclustered indexes