C# Corner

Stuff is a function in SQL Server used to perform special operations on a string value.

In this article, we will learn how to create CLR Triggers in C# and install & uninstall CLR assembly in MSSQL Server.

This post contains SQL Server tips for applying paging in SQL that can be used in real-world applications for long-running processing with better performance

In this article, we will learn how to create a CLR Stored Procedure with & without namespace in C# and install & uninstall CLR assembly in MSSQL Server.

In this session, we are going discuss how to create the SQL JOB, how to connect the Job with SSIS package and how to schedule the job on server.

In any application persistence of data is required. Database plays a very important role to fill this gap. Microsoft SQL server is one such database. We all know database contains multiple tables t...

Let’s discuss how to connect the database to SSIS package and how to load the table record(s) from database to notepad file. We can pull it into notepad, excel, csv or any other extension that you ...

In this article we will learn how to display records in custom given order except ascending & descending in MSSQL Server.

In SQL Server, the query optimizer uses a cardinality estimator to answer data SELECTIVITY questions like the ones below. The optimizer uses this cardinality data, which relies heavy on statistics ...

In this blog, I will demonstrate how to find the highest number of employees in a particular department using SQL server 2014.

This blog shows some primary issue which puts a serious limitation on SQL Server MONEY data type.

In this blog, we will discuss the way to submit the data of a model list to SQL Server to save all records of the list at once. We can do this by converting the model list to XML and then that XML ...

Recently, SQL Server team has launched service pack 2 of SQL server 2016.

Ever had users come to you and request another version of a report just to add another field and group data differently? Today, was such the day for me. I really don’t like having multiple versions...

When applying a new SQL Server cumulative update, hot fix, or upgrade to SQL Server, it doesn’t always apply all the fixes in the patch. When you upgrade the database engine in-place, databases you...

In this blog we will discuss how to find the highest salary, the second highest salary and N number of highest salaries with different examples.

In this video , we will learn how to create dynamic pivot table in SQL server in just 10 minutes

In this article, you will learn how to remove duplicate rows in SQL Server using CTE.

In this blog, we are going to learn how to get a stored procedure encrypted.

I had a SSAS Tabular Model project and I had few developers making changes on the fly without telling me. My biggest problem was I couldn't track the changes and my client had lots of requireme...

It's been a long time and I see that everyone is still using old SSIS packages from 2005 up to 2012, but I generally don't see new techniques or approaches being used. So, I decided to writ...

In SQL Server, we usually come across queries, tables, views, stored procedures and functions. People often wonder what are the real differences between User Defined Functions (UDF) or simply funct...

This blog is about temporary tables in SQL, their types, and differences between them.

Every once in a while, I like to take a moment and learn something new about the latest SQL Server gizmos and gadgets. Today I came across system-versioned temporal tables and it piqued my interest...

This article helps you to understand how to use the SQL Profiler, and how to trace a particular table.