What is Nonclustered Index? How to create Nonclustered Index?

What is Nonclustered Index?

Non-Clustered Index,

1. Non-clustered indexes can be used more than one time per table.

2. Non-clustered indexes store logical structure but clustered indexes store in physical order.

3. Faster for insert and update operations than a clustered index.

4. Improve the performance when select data with index fields.

5. Non-clustered indexes are stored separately.

6. We can add only 249 non-clustered indexes for a table.

7. Non-clustered indexes made on the any key but clustered indexes only on primary keys.

How to create Nonclustered Index?

-- CREATE NONCLUSTERED INDEX

CREATE NONCLUSTERED INDEX Indexname_Employee ON Employee

(

[EmpName] ASC --OR DESC,

[EmpDepartment] ASC --OR DESC

)

-- OR

-- CREATE NONCLUSTERED INDEX

CREATE NONCLUSTERED INDEX [Indexname_Anil1] ON [dbo].[Emply]

(

[EmpName] ASC,-- OR DESC,

[EmpDepartment] ASC-- OR DESC

)

WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF,

IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF,

ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = OFF)

ON [PRIMARY]

I hope you enjoying with this post! Thank you very much!

By Anil Singh | Rating of this article (*****)

React | Encryption and Decryption Data/Text using CryptoJs

To encrypt and decrypt data, simply use encrypt () and decrypt () function from an instance of crypto-js. Node.js (Install) Requirements: 1. Node.js 2. npm (Node.js package manager) 3. npm install crypto-js npm install crypto - js Usage - Step 1 - Import var CryptoJS = require ( "crypto-js" ); Step 2 - Encrypt // Encrypt var ciphertext = CryptoJS . AES . encrypt ( JSON . stringify ( data ), 'my-secret-key@123' ). toString (); Step 3 -Decrypt // Decrypt var bytes = CryptoJS . AES . decrypt ( ciphertext , 'my-secret-key@123' ); var decryptedData = JSON . parse ( bytes . toString ( CryptoJS . enc . Utf8 )); As an Example, import React from 'react' ; import './App.css' ; //Including all libraries, for access to extra methods. var CryptoJS = require ( "crypto-js" ); function App () { var data

List of Countries, Nationalities and their Code In Excel File

Download JSON file for this List - Click on JSON file Countries List, Nationalities and Code Excel ID Country Country Code Nationality Person 1 UNITED KINGDOM GB British a Briton 2 ARGENTINA AR Argentinian an Argentinian 3 AUSTRALIA AU Australian an Australian 4 BAHAMAS BS Bahamian a Bahamian 5 BELGIUM BE Belgian a Belgian 6 BRAZIL BR Brazilian a Brazilian 7 CANADA CA Canadian a Canadian 8 CHINA CN Chinese a Chinese 9 COLOMBIA CO Colombian a Colombian 10 CUBA CU Cuban a Cuban 11 DOMINICAN REPUBLIC DO Dominican a Dominican 12 ECUADOR EC Ecuadorean an Ecuadorean 13 EL SALVADOR

Angular 7 and 8 Validate Two Dates - Start Date & End Date

In this example, I am sharing “ How to compare or validate two dates in Angular? ” using custom validation function in Angular 7 and Angular 8 . Here, I’m validating the two dates - a start date and end date. The end date should be greater than the Start date”. Let’s see the example :- import { Component , OnInit } from '@angular/core' ; import { UserRequest } from '../model/user' ; @ Component ({ selector: 'User_Cal' , templateUrl: './usercal.component.html' , styleUrls: [ './usercal.component.css' ] }) export class UserCalComponent implements OnInit { constructor ( private EncrDecr : EncrDecrService , private http : HttpClient , private datePipe : DatePipe ) { } //model class model = new UserRequest ( null , null , null , null , null ); //Error Display error : any ={ isError: false , errorMessage: '' }; isValid

Encryption and Decryption Data/Password in Angular

You can use crypto.js to encrypt data. We have used 'crypto-js'. Follow the below steps, Steps 1 – Install CryptoJS using below NPM commands in your project directory npm install crypto-js --save npm install @types/crypto-js –save After installing both above commands it looks like – NPM Command 1 -> npm install crypto-js --save NPM Command 2 -> npm install @types/crypto-js --save Steps 2 - Add the script path in “ angular.json ” file. "scripts" : [ "../node_modules/crypto-js/crypto-js.js" ] Steps 3 – Create a service class “ EncrDecrService ” for encrypts and decrypts get/set methods . Import “ CryptoJS ” in the service for using encrypt and decrypt get/set methods . import { Injectable } from '@angular/core' ; import * as CryptoJS from 'crypto-js' ; @ Injectable ({ providedIn: 'root' }) export class EncrDecrS

23 Best Key Features of MVC 6 and MVC 5

What’s new In MVC 6? The Added Key Features as following as, 1. The Microsoft makes a bundle of MVC, Web API, WebPages, SignalR, that bundle we called MVC6 . 2. The MVC 6 added new cloud computing optimization system of MVC, web API, SignalR and entity framework. 3. In MVC 6, Microsoft removed the dependency of system.web.dll from MVC 6 because it's so expensive. Typically it consumes 30K memory per request/response. 4. Right now, in MVC 6 consume 2K memory per request response. It's too small memory consume. 5. Most of the problem solved using the Roslyn Compiler . 6 . It’s added a Start-up class that replaces to global.asax file. 7. The Session state and caching adjusts our behavior depending on your hosting environment. 8. Host agnostic and its true side-by-side deployment 9. The vNext is a cross platform and open source and it's also supported to Mac, Linux, etc. 10. It’s also added to TagHeaplers use to creating an

Anil Singh | Code-sample.com

Search This Blog