Ways to Improve SQL Query Performance

1-Avoid Multiple Joins in a Single QueryTry to avoid writing a SQL query using multiple joins that includes outer joins, cross apply, outer apply and other complex sub queries. It reduces the choices for Optimizer to decide the join order and join type. Sometime, Optimizer is forced to use nested loop joins, irrespective of the performance consequences for queries with excessively complex cross apply...

Continue Reading →

Import MS Excel data to SQL Server table using C#

If you already have data in MS Excel file, and want to migrate your MS Excel data to SQL Server table, follow the below steps: MY xls file. CREATE a SQL Table CREATE TABLE [dbo].[tblProduct]( [PID] [int] NULL, [ProdName] [varchar](50) NULL, [ProdDesc] [varchar](50) NULL, [ProdCost]...

Continue Reading →

CTE and Temp Table and Table Variable - SQL SERVER

Temp tablesBehave just like normal tables, but are created in the TempDB database. They persist until dropped, or until the connection that created them disappears. They are visible in the procedure that created them and any procedures that that proc calls.Just like normal tables, they can have primary keys, constraints and indexes, and column statistics are kept for the table. Temp tables,...

Continue Reading →

AngularJS : Service vs factory vs provider

Introduction AngularJS Service, Factory or Provider all are used for the same purpose of creating utility function that can be used throughout the page with inject-able object. However, the way it is created and the way it is used are different. Here we'll try to understand them clearly. AngularJS...

Continue Reading →

AngularJS AJAX - $http

AngularJS AJAX - $http $http is an AngularJS service for reading data from remote servers. AngularJS $http The AngularJS $http service makes a request to the server, and returns a response. <div ng-app="myApp" ng-controller="myCtrl"> <p>Today's welcome message is:</p> <h1>{{myWelcome}}</h1> </div> <script> var app = angular.module('myApp',...

Continue Reading →

AngularJS Authentication

AngularJS Authentication with JWT(JSON web tokens) JWTs provide a way for clients to authenticate every request without having to maintain a session or repeatedly pass login credentials to the server. A JWT consists of three main components: a header object, a claims object, and a signature. These three properties are encoded using base64, then concatenated with periods as separators. Some important...

Continue Reading →

EmailId Validation IN Sql Server

Create a User defined function to Validate EmailID in Sql Server Create FUNCTION UDFValidateEmail (@email varChar(255)) RETURNS bit AS begin return ( select  Case  When  @Email is null then 0                  --NULL Email is invalid ...

Continue Reading →

Windows Azure and Cloud Computing - A Glance

Windows Azure, which was later renamed as Microsoft Azure in 2014, is a cloud computing platform, designed by Microsoft to successfully build, deploy, and manage applications and services through a global network of datacenters.  The popular trend in today's technology driven world is ‘Cloud...

Continue Reading →