A stored procedure as system object in SQL SERVER 2008

A stored procedure as system object in SQL SERVER 2008 Today I encountered a situation to use a stored procedure across all objects , so that I could use stored procedure on any database within a given SQL Server instance. After some digging I found that there are few ways to create such a stored procedure: The stored procedure must be created...

Categories: Interview Questions , SQL Server

Primary index and Secondary index In Sql Server

Primary index and Secondary index In SQL Server Primary index: A primary index is an index on a set of fields that includes the unique primary key for the field and is guaranteed not to contain duplicates. This also called as Clustered index. e.g. ID  in Employee can be an example of this. Secondary index: A Secondary index is an index which...

Categories: SQL Server

String.Empty Vs ""

String.Empty vs "" : An Interview Question Use String.Empty rather than "". This is more for speed than memory usage but it is a useful tip. The "" is a literal (A literal is "any notation for representing a value within source code) so will act as a literal: on the first use it is created and for the following uses its reference is returned. Only...

Categories: C# , Interview Questions

Three modes of WCF Instance management

WCF instance management Interview Question An idea  to write this blog to get familiar with 3 modes of WCF instance management , how all does work in context to WCF.   Three modes are given below: InstanceContextMode. PerCall .csharpcode, .csharpcode pre{ font-size: small; color: black; font-family: consolas, "Courier New", courier,...

Categories: WCF and WebAPI