DevSocial Blogs · SQL Server blogs

In this article Sagar Jaybhay explains how to write Subqueries and Correlated Subqueries in SQL Server and what to choose for performance -- Subquery or Join?

Sagar JaybhayApr 13, 202025,325250

This post will cover the differences between Max Degree of Parallelism and Cost Threshold for Parallelism. These are two server settings that have a less the ideal default value. All DBAs should review these settings to determine if they should be changed.

This post will go over how you can use the DEADLOCK_PRIORITY to prioritize your processes so that the most important ones aren't chosen as victims of a deadlock.

Learn the difference between SQL Union and Union All. Code example Union vs Union All in SQL.

Anu VMar 5, 2020412,125250

In this blog, I will explain to you how to apply a script or a query to multiple databases in a single execution using a database name.

Archit ShrivastavaMar 4, 202013,192250

This post will go very a few of the methods that can be used to capture failed logins to your SQL Servers.

This post will focus on how to find what logins are mapped to database user accounts in a SQL Server database.

This blog explains the Select statement in SQL.

Sagar JaybhayJan 29, 20206,080250

In this blog, I will discuss the collate clause and also discuss how the expression type 'int' is invalid for collate clause error in the SQL server.

Salman BegDec 17, 20192,423250

In this blog, I will explain the SQL Transaction.

Mageshwaran RDec 14, 20197,016250

There are many issues when we work with SQL server. This blog will introduce a tool which we can use to repair corrupted SQL Server DBS

Destin JoyDec 14, 201914,534250

This blog post is for advanced T-SQL developers interested in implementing custom sequences. Customizing the sequence gives more flexibility while implementing a solution.

This post explains static and dynamic pivot query in SQL Server

In this blog, you will learn how to delete all duplicate rows or records from a table in SQL Server

In this blog, I will explain the SQL Cursor.

Mageshwaran RNov 27, 201910,175250

The commands in this blog will help you to understand the way a table structure can be changed or altered. In this blog, one can find examples related to adding new columns, removing unwanted columns, increasing and decreasing the width of the columns, etc.

This blog post is related to the ALTER command. Whenever we want to change the structure of the table we can use the following commands as mentioned in this blog.

In this blog, I will explain indexes in SQL Server.

Mageshwaran RNov 20, 201917,078250

In this blog, I will explain SQL View

Mageshwaran RNov 20, 201911,977250

In this blog, I will explain SQL Triggers.

Mageshwaran RNov 20, 201916,882250

Basics about Data Integrity Constraints. Why and when to use a constraint is explained in this document with respect to Entity Integrity Constraint using Primary Key and Unique constraints.

In this blog, I will explain the SQL Stored Procedure

Mageshwaran RNov 18, 201912,517250

In this blog, I will explain SQL JOIN Statements. These are used to relate one or more tables in SQL Server

Mageshwaran RNov 18, 201911,881250

In this blog, I will explain SQL user-defined functions

Mageshwaran RNov 18, 201930,362250