DevSocial Blogs · SQL Server blogs

Different Steps to optimize a stored procedure.

In interviews I find that most are not aware of some of the basic differences between the SQL Server delete and truncate commands as well as whether these operations can be rolled back, so in this blog we will cover some of these aspects.

Naveen KumarAug 4, 202311,294250

Most of us know about JOINS in SQL Server and their types. But do we really know how they are interpreted in SQL Server internally? Let's learn all this in this blog today.

Abhishek ShrivasJul 21, 202339,397250

In this blog, you will learn how to export Blob(BINARY or VARBINARY) From SQL Server Table and save it as a file.

Ashutosh MundJul 19, 202396,649250

SQL partition by. Learn how to use Row_Number function without Partition By in SQL or with Partition By in SQL. SQL Partition By Example.

Rohatash KumarJun 28, 20231,929,831250

In this blog, I will explain how to check a specific word or character in a given statement using CHARINDEX() function in SQL Server. An alternative to CHARINDEX() is using LIKE predicate.

Amit KumarJun 27, 20232,275,127250

The given content provides three techniques for generating unique numbers in SQL Server. The first approach is to use an identity column, which automatically assigns a unique number to each row inserted into a table. The second approach suggests using the NEWID() function to generate universally unique identifiers (UUIDs). Lastly, the third technique demonstrates how to create a user-defined unique code based on a specific format and the current date.

Prakashkumar SahooJun 1, 202367,807250

In this article, you will learn how to convert an integer to a string in SQL Server.

Deepak TewatiaMar 14, 20231,676,199250

In this blog, I am demonstrating running the .sql files form the command prompt.

Rakesh KalluriMar 9, 20237,610250

In this blog, you will learn about sessions in SQL Server.

Raj BhattMar 8, 202337,262250

In this blog I will show you how to swap the values of two columns in SQL Server. Looks difficult.

NitinMar 2, 2023101,112250

In this blog I will show you how to return a comma separated value from a table.

NitinFeb 28, 20235,613250

In this post, we will discuss how to work with join's and explain the concepts with an example in simple way. I hope this is very useful for beginners and intermediate to help them understand the basic concept.

Jitendra WaghaleFeb 24, 202311,568250

In this blog, you will learn about DML commands, using SQL query.

Sujata SinhaFeb 23, 202331,713250

This blog describes how to know database size in SQL SERVER.

Manas MohapatraFeb 7, 2023528,787250

In this blog, you will learn about SQL Database MDF and LDF.

Vishal YelveJan 14, 202373,551250

In this blog, we are going to learn about clauses in SQL Server. Clauses are used with table expressions and help in finding the result.

Farhan AhmedJan 10, 202352,192250

Data Integrity is used to maintain accuracy and consistency of data in a database. This article talks about data integrity in SQL Server.

Sanwar RanwaDec 28, 2022169,857250

How to use of row_number(),rank(),dense_rank() in SQL SERVER

Ravi ShekharDec 22, 202218,270250

This shows us how to invoke SSIS packages by clicking a button in windows form.

Create Stored procedure for Calendar

Dhaval PatelDec 21, 202216,865250

In this blog, we learn to call a Web API from SQL server.

Atul PathrikarDec 21, 2022140,914250

While going through the scripts I found this neat script which would be very handy for SQL DBAs.

In this blog, we can calculate the self-value calculation in SQL.

Atul PathrikarDec 13, 20223,878250