Flags enumerations are used for masking bit fields and doing bitwise comparisons. They are the correct design to use when multiple enumeration values can be specified at the same time. [code] If we are using flag enumerations there are few consideratio

The Dictionary(Of TKey, TValue) and ConcurrentDictionary(Of TKey, TValue) provides same functionality like Hashtable. But a Dictionary(Of TKey, TValue) of a specific type (other than Object) provides better performance than a Hashtable for value types. Thi

SET PARSEONLY ON Examines the syntax of each Transact-SQL statement and returns any error messages without compiling or executing the statement. [code] SET PARSEONLY { ON | OFF } [/code] When SET PARSEONLY is ON, SQL Server only parses the statement.

String length is an int so the its size is 2,147,483,647...but you will hit other problems such as memory issues before loading up that string. Roughly the max string could be 2 gig, but the real issue is getting enough memory from the heap as an allocatio

When you use StringBuilder, don't also use +. The plus operator creates a bunch of temporary strings. We can eliminate these for better performance. We eliminate the plus on the strings, and simply pass the strings directly to Append on StringBuilder. It c

Now AjaxControlToolkit includes ToolkitScriptManager also along with ScriptManager. Both these controls differ in the way they render JavaScript files for the client side, ToolkitScriptManager uses a technique called Script Combining to download the script

From a user control, you must call the GetCurrent static method and pass in a reference to the page. [code] ScriptManager sm = ScriptManager.GetCurrent(this.Page); [/code]

There are certain cases where holding a state value in ViewState is not the best option. The most commonly used alternative is Session state, which is generally better suited for: Large amounts of data. [code]Since ViewState increases the size of b

I had a tough time due to this issue while working on transaction, searching searching...(Mean while "Did you fixed the lock issue?" , I used reply "No".."You got any solution?"..."Nope, possibly today!!!(Regular dragging method)). After a long time I got

[code] The maximum number of parameters in a stored procedure is 2100. The maximum number of local variables in a stored procedure is limited only by available memory. Depending on available memory, the maximum size of a stored procedure is 128 megabyte