Skip to content

Hive

  • Programming
    • Interview Questions
    • JavaScript
      • Angular
      • AngularJS
      • jQuery
    • Microsoft
      • .Net Framework
      • C#
      • ASP.Net
      • ASP.Net MVC
      • MSSQL Server
      • Entity Framework
    • Database
      • MSSQL Server
      • MongoDB
    • Software Engineering
      • Design Patterns
      • Software Architecture
  • Technology
  • Electronics
  • Media
    • Films
    • Television
      • Game of Thrones
  • Home

Tag: MSSQL Server

rinoymjosephJuly 4, 2017July 4, 2017

SQL Optimization

1) The sql query becomes faster if you use the actual column names in SELECT statement instead of ‘*’. 2) Having clause is used to filter the rows after all…

Continue reading
rinoymjosephJuly 4, 2017July 4, 2017

Temporary Tables in SQL Server

-> In SQL Server, temporary tables are created at run-time and you can do all the operations which you can do on a normal table. These tables are created inside…

Continue reading
rinoymjosephJuly 4, 2017July 4, 2017

Cursor in SQL Server

-> Cursor is a database object used by applications to manipulate data in a set on a row-by-row basis, instead of the typical SQL commands that operate on all the…

Continue reading
rinoymjosephJuly 4, 2017July 4, 2017

Index in SQL Server

-> An index is a physical structure containing pointers to the data. Indices are created in an existing table to locate rows more quickly and efficiently. It is possible to…

Continue reading
rinoymjosephJuly 4, 2017July 4, 2017

View

-> A simple view can be thought of a as a subset of a table. It can be used to retrieving data, as well as updating or deleting rows. Rows…

Continue reading
rinoymjosephJuly 4, 2017July 4, 2017

Trigger

-> A trigger is an SQL procedure that initiates an action when an event (INSERT, DELETE or UPDATE) occurs. Triggers are used to maintain the referential integrity of data by…

Continue reading

Random Quote

Talk is cheap. Show me the code.

— Linus Torvalds

Categories

  • .Net Framework
  • Angular
  • AngularJS
  • ASP.Net
  • ASP.Net Core
  • ASP.Net MVC
  • C#
  • Design Patterns
  • EntiryFramework
  • EntityFramework
  • Game of Thrones
  • Games
  • JavaScript
  • Linux
  • MongoDB
  • MSSQL Server
  • Security
  • TypeORM
  • TypeScript
  • Uncategorized

Tags

.Net Core 2.0 Angular Angular2 AngularJS ASP.Net ASP.Net Core ASP.Net MVC Authentication C# Database Design Patterns EF Core 2 EntityFramework Game of Thrones games JavaScript Microsoft MongoDB MSSQL Server NodeJS OAuth 2.0 Security Single Sign-On TypeORM TypeScript

Recent Posts

  • TypeORM Express Application Using Repository Pattern – Part 4 – How to do Cascade Save
  • TypeORM Express Application Using Repository Pattern – Part 3 – How to perform InnerJoin
  • TypeORM Express Application Using Repository Pattern – Part 2 – Persist Data into Tables
  • How to Integrate Angular 6/7 application with TypeORM and Express
  • TypeORM Express Application Using Repository Pattern – Part 1 – Create Tables with Relationships

Archives

  • December 2018
  • October 2018
  • September 2018
  • August 2018
  • April 2018
  • March 2018
  • February 2018
  • September 2017
  • July 2017
  • June 2017
  • Programming
  • Technology
  • Electronics
  • Media
  • Home
Proudly powered by WordPress | Theme: Gently by MusterThemes.