Skip to main content

Posts

Showing posts from March, 2017

Profiling with SQL Server Management Studio

On the Query menu, click on ‘Include Advance Execution Plan’ or click the toolbar button. Now open a new query window, type the following queries and execute them. use Northwind ; set statistics io on ; set statistics time on ;  Select top 5 * from Customers   You should be now able to see additional information in the message tab and execution plan tab (along with result tab in lower window pane)

Using the InvariantCulture Property

It is associated with the English language but not with a country or region.    The   CultureInfo.InvariantCulture   property is neither a neutral nor a specific culture. It is a third type of culture that is culture-insensitive. You can use   InvariantCulture   in almost any method in the   System.Globalization   namespace that requires a culture.  When should we use it? You should use the invariant culture only for processes that require culture-independent results, such as system services. In other cases, it produces results that might be linguistically incorrect or culturally inappropriate. You should also use   InvariantCulture   when a security decision will be made based on the result of a string comparison or case change.  The default implementations of methods such as   String.Compare ,   String.ToUpper , and   String.ToLower   use the   CultureInfo.CurrentCulture   property.  When we shouldn't use it? Code that performs culture-se