Recently i faced this question, "Where memory for static variables will be allocated?"...

Recently in an interview i faced following questions. Is it possible to call a trigger from another trigger? Is it possible to call a trigger directly?...

Which command is used reseed the identity value?...

Recently i was asked this question in an interview, "When garbage collector will be executed?"...

@Kirti: That's true, as far as is goes, but you can meet situations where is needed to call it manually. It seems that one of the most obvious is when state of application has changed. You may be interested at: http://blogs.msdn.com/b/ricom/archive/2004...

commonly asked C# interview questions and answers...

In SQL Server, on a primary key column, is it possible to create Non-Clustered index?...

Interview questions and answers on various SQL Server areas such as Database Administration, TSQL Development, BI etc....