What are the ways of fine tuning the SQL SERVER procedure ?

fine tuning SQL SERVER stored procedure

  1. Implementing NOLOCK keyword
  2. Implementing the Clustered and Non Clustered index at appropriate places.
  3. Reducing the Joins and possibly avoid redundancy
  4. Study Execution Plan – Cost Estimate Calculation – Ensure individual operations taking less cost
  5. Avoid cursors and implement correlated sub query.
What are the ways of fine tuning the SQL SERVER procedure ? was last modified: October 1st, 2017 by Justin Antony

What is a Dead lock in SQL ?

Dead Lock occurs if more than one process shares the same resource(Table). we can avoid it by using NOLOCK keyword after the table name. The Nolock should be used only for select statement and it should not be used for Update or delete statements.

What is a Dead lock in SQL ? was last modified: October 1st, 2017 by Justin Antony

What is POWER BI ?

It is Microsoft cloud based Business intelligence Tool. It works with Excel and Office365 to analyze and visualize the data.

Power Query : Enables users to easily search and access their organization data within Excel. It works like a data explorer. Transform the raw data into a tabular form dataset that can be used with Excel or Power Pivot.
Power Map : The Power Map is used for creating 3D data visualization tool for mapping, exploring and interacting with geographic data.
Power Pivot : For creating and customizing flexible data models within Excel. It’s the engine that runs all the calculations, hosts all your data and creates the analytical model
Power View : For creating interactive charts, graphs and other visual representations of data.

It can be grouped under three major category
1.The BI add-on for Excel
2.The actual cloud service or BI Site (SharePoint Online)
3.The new REST API (for development) This is the latest addition to the family. The ability to interact with Power BI using a REST API in order to create some custom applications. You can create your own connectors or even create applications that will interact with a dataset in order to add new rows or alter such dataset

What is POWER BI ? was last modified: October 1st, 2017 by Justin Antony

What is a Column Store Index in SQL Server ?

This is a new type of index introduced in sql server 2012. This is a non clustered index based on a column. This will increase the query performance when involving in a huge volume of data in the data warehouse face tables.

Usually the requested columns in a query will be returned after all the pages fetched in to memory. In this approach Whatever columns we include as column index, all of them are stored as columns within the index and data no longer stored by row. Only the requested column fetched in to memory. When we use the columnstore indexes it can reduce disk I/O and utilize memory more efficiently.

What is a Column Store Index in SQL Server ? was last modified: November 7th, 2016 by Justin Antony

What is an Attunity Connector?

Attunity Connector

Attunity is a third party Tool used for majorly in extracting data from Oracle source system to sql server. This tool will manage and monitor all the SCD changes and will keep the data up to date with the source system.

What is an Attunity Connector? was last modified: October 1st, 2017 by Justin Antony

What is a trigger in sql server?

Trigger is a special kind of stored procedure which will get executed on events like insert, delete or update operation happens on a specific object of the database.

Types of Trigger

  1. Insert Trigger
  2. Delete Trigger
  3. Update Trigger
  4. Combination of above Triggers
What is a trigger in sql server? was last modified: October 1st, 2017 by Justin Antony