Posts

Showing posts from November, 2010

Sql StoredProcedure Optimization Tips

We will go over how to optimize Stored Procedure with making simple changes in the code. Please note there are many more other tips, which we will cover in future articles. Include SET NOCOUNT ON statement: With every SELECT and DML statement, the SQL server returns a message that indicates the number of affected rows by that statement. This information is mostly helpful in debugging the code, but it is useless after that. By setting SET NOCOUNT ON, we can disable the feature of returning this extra information. For stored procedures that contain several statements or contain Transact-SQL loops, setting SET NOCOUNT to ON can provide a significant performance boost because network traffic is greatly reduced. CREATE PROC dbo.ProcName AS SET NOCOUNT ON; --Procedure code here SELECT column1 FROM dbo.TblTable1 -- Reset SET NOCOUNT to OFF SET NOCOUNT OFF; GO 

Command-line Building With csc.exe

Command-line Building With csc.exe You can invoke the C# compiler by typing the name of its executable file (csc.exe) on the command line. If you use the Visual Studio Command Prompt (available as a shortcut on the start menu under Visual Studio Tools), all the necessary environment variables are set for you. Otherwise, you must adjust your path in order to enable csc.exe to be invoked from any subdirectory on your computer. If you do not use the Visual Studio Command Prompt, you must run vsvars32.bat to set the appropriate environment variables to support command line builds. For more information about vsvars32.bat, see How to: Set Environment Variables. If you are working on a computer that only has the Windows Software Development Kit (SDK), you can use the C# compiler at the command line if you use the SDK Command Prompt , which is available from the Microsoft .NET Framework SDK menu option. You can also use MSBuild to programmatically build C# programs. For more informat

Differences Between C# Compiler and C++ Compiler Output

Differences Between C# Compiler and C++ Compiler Output -------------------------------------------------------------------------------- There are no object (.obj) files created as a result of invoking the C# compiler; output files are created directly. As a result of this, the C# compiler does not need a linker.

how to enable instance using sp_configure

hi friends, i find too many issues while attaching any database file in asp..net project so for that use the below command for enable instance configuration in your sqlExpress sp_configure  'user instances enabled', 1; RECONFIGURE

Computer on rent in Gandhinagar

sunrise computer sec-24 Reference by Vikaram Sagar Candid computer contact number sivrambhai 9427055568, nanjibhai 9408474313 P-3 on 400Rs. P-4 on 600Rs. Core 2 dual on 800 laxmi info sec-21 Reference by Mr.Drumil Kanani (Niral's old room mate ) hareshbhai 9825332949 P-4 on 1200 P-3 on 800