DevSocial Blogs · SQL Server blogs

In this blog we learn Role of log file in Transaction Management in SQL server database 2008.

Abhijit PatilDec 22, 20149,081250

In this blog we learn Transaction Management in SQL server database 2008.

Abhijit PatilDec 22, 20144,106250

In this blog we are learning what is a "Group by" query, how a "Group by" query works and the advantages and disadvantages of a "Group by".

Joginder BangerDec 20, 20143,662250

Fix the issue “The specified report server URL could not be found”.

Abhay ShankerDec 20, 201481,654250

This Blog will show the physical location of all the database file in SQL Server.

Manish Kumar ChoudharyDec 20, 201413,342250

This blog describe about SQL Error Concurrency Violation while Firing Update Command.

Shweta LodhaDec 13, 20144,543250

This Blog will explain how to get the last back up data of all databases in SQL server.

Manish Kumar ChoudharyDec 12, 20143,989250

This Blog will enplane about how to convert second into hours: Minute: seconds format by using function in sql server.

Manish Kumar ChoudharyDec 12, 201445,710250

In this blog you will learn how to use the CHARINDEX function in SQL Server.

Rakesh KalluriDec 11, 201419,502250

In this blog you will learn how to find Foreign Keys and the Primary Key in a table in SQL.

Vamshi KrishnaDec 3, 2014108,565250

This blog could solve your problem as I was faced this type of problem. So I share this code with you.

Joginder BangerDec 3, 20144,823250

This blog will teach you that making a primary key column has a limit in SQL-server and what can happen when user will exceed that limit.

Vamshi KrishnaNov 26, 201421,612250

Cannot drop the database because it is being used for replication from one server to another in SQL server 2008.

Sachin KaliaNov 20, 201419,820250

In this blog, I will explain what is transaction, how to transaction work ,why we need transaction function and solve some basic error in Transaction.

Joginder BangerNov 18, 20148,411250

This blog calculate the distance between two latitude and longitude.

Blocked AccountNov 12, 201494,872250

Here I will explain how to convert table data to xml format in sql server or get table data in xml format in sql server. We can convert sql server table data in xml format by using XML PATH.

Digvijay RaghavOct 28, 201457,038250

This article will demonstrate how to use multi-value paramter in sql without using dynamic SQL.

Punit JainOct 28, 20145,358250

In this blog we will explore how to get comma delimited values in SQL Server

In this Blog I will tell you about how you can sort data in sql except some certain Row.

Anubhav ChaudharySep 11, 20145,844250

This article describes how to get column values in one comma separated value in SQL Server.

Manish Kumar ChoudharySep 9, 201488,480250

In this blog you will learn about how to join table in SQL server.

Dipankar BiswasSep 8, 20144,931250

Count not null null and empty records.

Dipankar BiswasAug 27, 20146,996250

This is a SQL script of get all Databases Backup in particular folder.

In this blog you will learn about Stored Procedure VS Function.

Abhishek JaiswalJul 26, 20144,686250