Loading
SQL Query Optimization Technique
Learn practical SQL query optimization techniques, including selecting only needed columns, creating effective indexes, limiting results, and choosing appropriate data types.
Collation In SQL Server
Here I am explaining how to change an existing collation of a database in SQL.
In-Memory OLTP of SQL Server 2014
This article explains how to create Memory-Optimized tables and what I have initiated using this new type of table.
SQL Server Temporary Table With Master and Transaction Tables
This article explains temporary tables with examples in SQL Server.
Understanding Temporary and Transaction Tables in SQL Server
This article explains Temporary and Transaction tables in SQL Server.
Dealing With Timezones in SSRS Reports
In this article you will learn how to deal with timezones in SSRS Reports.
Clustered Tables Vs Heap Tables in SQL Server
This article explains the differences between Clustered Tables and Heap Tables in SQL Server.
OFFSET-FETCH Clause in SQL Server
Learn how to use SQL Server OFFSET-FETCH with ORDER BY to skip rows, fetch result sets, and implement pagination.
Merge Statement Using XML Data in SQL Server
This article explains the use of the merge statement with XML data in SQL Server.
Searching Data in GridView Without Coding Using SQL Server
This article shows how to search data in a GridView using SQL Server without writing code.
Merge Statement Using XML Data in SQL Server
This article explains the Merge statement in SQL Server. With the Merge statement we can merge the data from a source table into a target table.
SQL Query Performance - Functions and Indexes
In this article we will learn why functions should be avoided on indexed columns in where clauses of select statements.
Creating Stored Procedure That Accepts Table as Parameter in C#
This article explains how to create a Stored Procedure in SQL that accepts a data table as parameter.
Table Value Parameter in ASP.Net Using SQL Server
This article shows how to pass a collection of records to a database for processing. In SQL Server 2008 we make a custom data type TABLE to pass a collection of rows to a Stored Procedure.
Automatic Table Generation in Any Database by NHibernate ORM and CodeDom
This article describes how to allow users to build a database automatically from an application via two technologies, code generation (CodeDOM) and NHibernate (Fluent) that let us make a backend regardless of the type of database and without involving complicated concepts.
Identifying Unused Indexes in a SQL Server
In this article you will learn how to identify unused Indexes in a SQL Server database.
Impact of Sp_prefix on Stored Procedure Performance
In this article we will see the impact of sp_prefix on Stored Procedure performance.
Rebuilding SQL Server 2008 R2
In this article you will learn how to rebuild a master database in SQL Server.
Pass the Table Type Data to SQL CLR Object
In this article we will learn how to pass table type data to a SQL object.
Basic Terminology of SQL Server
In this article we learn SQL from the basics. Here I describe all the basic terminology of SQL.
Magic (Virtual) Tables in SQL
This article explains the magic (Virtual) tables in SQL.
Split String Lists Using Multiple Delimiters
This is a small SQL Code snippet for splitting string lists into a table based on one or more delimiters.
Create Clustered Index For Other Than Primary Key Column in SQL Server
Learn how to move a clustered index from a primary key column to another column in SQL Server and recreate the primary key as nonclustered.
String Functions in SQL Server
This article explains some of the most commonly used string functions in SQL Server.
SQL Server: A (0-1 & 1-0) Convert Puzzle to Solve
This article provides a solution to SQL Server: A (0-1 & 1-0) conversion puzzle.
Exception Handling in SQL Server
In this article you will learn about SQL Server Exception Handling.
User Defined Type (UDT) in Microsoft SQL Server
In this article you will learn about User Defined Types (UDTs) in Microsoft SQL Server.
Localization in SSRS Reports
In this article you will learn Localization in SSRS Reports.
Union and Union All Command in SQL Server
In this article you will learn about the Union and Union All commands in SQL Server.
