What is a SQL Server Cursor? A SQL Server CURSOR is a set of T-SQL logic to loop over a pre-determined number of rows one at a time and ...
Read More
How to Sort a Varchar Column Storing Integers with Order By? SQL Server
Recently I faced a very interesting issue during the column sorting in SQL Server. I have a VARCHAR column in a SQL Server database that c...
Read More
SQL Server Page Life Expectancy (PLE)
SQL Server Page Life Expectancy (PLE) Counter key performance indicator for those DBAs looking at the overall health of their database inst...
Read More
Delete the top 10 rows from a table using SQL Server
The CTE most efficient ways to delete rows from table as per your need. Example 1, ; WITH CTE AS ( SELECT TOP 10 * ...
Read More
How To Find Column dependency in SQL Server Store procedure
We can use following queries to find the column dependency in SQL Serve r Store Procedures i.e. Example1, -- THIS QUERY WILL SEARCH I...
Read More
Encrypt Decrypt a string in C# dotnet core 3.x - Data Security!
Encryption is the process that converting normal message Plain-text into Cipher-text . It is a process of converting normal data into an u...
Read More
Subscribe to:
Posts
(
Atom
)