Why we avoid permitting null values

Null means no input is done on the column.It implies that the value is either unknown or undefined.We should avoid permitting null values because Column with NU..

Diffrence between Extents and Page

Extents:Mulitple objects will use the same extent. SQL Server will allow a max of eight objects to use a shared extent.

write a function to Get Lastindex of character and remove that character

function val()

{


var txt ="interview,";

var t=txt.substr(txt.length-1,1);


if (t=',')

{


..

Diffrence between varchar and nvarchar

An nvarchar column can store any Unicode data. A varchar column is restricted to an 8-bit codepage. Some people think that varchar should be used because it tak..

Change Tracking in SQL Server 2008

Change tracking is a lightweight solution.If you have a large ammount of data in your database and you need to extract only the changes of last day.Now you are ..

SQL Server and ASP.NET performance tips

ALways use same connection string to get advantage of Connection pooling.Becuase connection polling is not used for new connection.

Always close user-define..