Category: Sql Server

post
Statistics

Sql Server : How SQL Server Statistics Works

Sql Server : SQL Server statistics are essential for the query optimizer to prepare an optimized and cost-effective execution plan. These statistics provide distribution of column values to the query optimizer, and it helps SQL Server to estimate the number of rows (also known as cardinality). When are SQL Serve...

post
Normalisation

Sql Server : SQL | What Database normalization in Sql Server?

Sql Server : Database normalization is the process of organizing the fields and tables of a relational database to minimize redundancy and dependency. Normalization usually involves dividing large tables into smaller (and less redundant) tables and defining relationships among them.Normalization ResolvesDuplicat...

post
Data Capture

Sql Server : SQL | Change Data Capture (CDC)

Sql Server : What is CDC?Ans: SQL Server CDC (Change Data Capture) is the process of capturing and recording changes made to the Microsoft SQL Server database. CDC records INSERT, UPDATE, and DELETE operations performed on a source table and then publishes this information to a target table. Microsoft S...

post
indexes

Sql Server : SQL | Columnstore Index

Sql Server : A column store index is an index that was designed mainly for improving the query performance for workloads with very large amounts of data.This type of index stores the index data in a column based format rather than row based as is done with traditional indexes. Benifits of columnstore indexMain b...

post
Events Notifications

Sql Server : Sql | Event Notifications

Sql Server : Event Notifications concept introduced in SQL Server 2005, offer a versatile and effective method of capturing and managing internal SQL Server events. Instead of using DDL triggers or SQL Trace to record details about the event being fired, event notifications run for DDL Events and Trace Events in...

post
Function

Sql Server : SQL | User-Defined Functions

Sql Server : User-defined functions (UDFs) are routines that accept parameters, perform complex functions, and return a value or the result set.There are three types of UDFs – user-defined scalar functions, table-valued functions, and system functions.We use UDFs because:- They can be created, stored, and called...

post
Function

Sql Server : SQL | COALESCE Function

Sql Server : The Coalesce function of the SQL server is used to manage Null values. During the expression evaluation process, user-defined values are used to replace the null values. This method always returns the first non-null value after evaluating arguments from the supplied arguments list in a speci...

post
Stored Procedure

Sql Server : SQL | Types of Stored Procedures

Sql Server : SQL Server categorizes the stored procedures mainly in two types:User-defined Stored ProceduresSystem Stored ProceduresUser-defined Stored ProceduresDatabase developers or database administrators build user-defined stored procedures.A stored procedure specified by the user accepts input parameters a...

post
Stored Procedure

Sql Server : SQL | Stored Procedure

Sql Server : A SQL Server Stored Procedure is a database object which contains pre-compiled queries (a group of T-SQL Statements), designed to perform a task whenever we called.By default, a stored procedure compiles when it gets executed for the first time. It also creates an execution plan that is reused for s...

post
indexes

Sql Server : SQL | Full Text Index

Sql Server : A special type of index that provides index access for full-text queries against character or binary column data.A full-text index breaks the column into tokens and these tokens make up the index data.This feature lets users and application run character-based lookups efficiently by creating a parti...

Sql Server: & More

About Us

Community of IT Professionals

A Complete IT knowledgebase for any kind of Software Language, Development, Programming, Coding, Designing, Networking, Hardware and Digital Marketing.

Instagram