Posts

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

Jquey with Webservice in asp.net

Image
how to call webservice from JQuery please find following steps Please find following steps for Create one WebService in asp.net project with DummyTest.asmx [WebService(Namespace = "http://tempuri.org/")] [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)] [System.ComponentModel.ToolboxItem(false)] Create one Webmethod with SessionEnable = true [Webmethod(EnableSession=true)] Public string HelloWorld(string name) { //apply your logic here Return “Hello World” + name; } Come to aspx page and add jQuery Library at top of the page <script languge=”javascript” src=”jquery-1.3.2.js” ></script> <script languge=”javascript” src=”jquery-ui-1.7.2.min.js” ></script> ajax method parameters Type: “Post” or “Get” URL : your web service file name /Method name Data : paramert data for webmethod contentType: "application/json; charset=utf-8" dataType: "json" success : function error : function

SQL SERVER – Simple Example of Recursive CTE

Recursive is the process in which the query executes itself. It is used to get results based on the output of base query. We can use CTE as Recursive CTE (Common Table Expression). You can read my previous articles about CTE by searching at http://search.SQLAuthority.com . Here, the result of CTE is repeatedly used to get the final resultset. The following example will explain in detail where I am using AdventureWorks database and try to find hierarchy of Managers and Employees. USE AdventureWorks GO WITH Emp_CTE AS ( SELECT EmployeeID, ContactID, LoginID, ManagerID, Title, BirthDate FROM HumanResources.Employee WHERE ManagerID IS NULL UNION ALL SELECT e.EmployeeID, e.ContactID, e.LoginID, e.ManagerID, e.Title, e.BirthDate FROM HumanResources.Employee e INNER JOIN Emp_CTE ecte ON ecte.EmployeeID = e.ManagerID ) SELECT * FROM Emp_CTE GO In the above example Emp_CTE is a Common Expression Table, the base record for the CTE is derived by the first sql query before UNION A