DevSocial Blogs · SQL Server blogs

In this blog, the user can find out in which table records are deleted or inserted.

Talaviya BhavdipSep 26, 201713,577250

ACID properties are atomicity, consistency, isolation, and durability.

Hamid KhanSep 19, 201740,704250

This blog will list different ways to use GETDATE() funtion in SQL Server 2008 R2. The major changes in the new SQL Server 2008 are the DateTime function and the introduction of new data types.

Saravanan PonnusamySep 6, 201715,224250

SQL Server 2008 R2 setup failed with “Error 1406. Could not write value to key \SOFTWARE. System error. Verify that you have sufficient access to that key, or contact your support personnel”.

Anil AvulaSep 6, 20176,916250

SQL Server uses a process called parameter sniffing when it executes a stored procedure that has parameters. When the procedure is compile or recompiled, the value passed in the parameter is evaluated and used to create an execution plan and the same plan will be stored in plan cache.

Nisarg UpadhyayAug 23, 20177,127250

In this blog, we will learn how we can merge the table data using merging statement.

Junaid SyedAug 23, 20177,125250

Usually, we use * to select all the columns but if we have to select all the columns except one column, then we have to write all the required columns one by one. Here I am going to show how we can achieve it without writing all the columns one by one.

Anil JhaAug 9, 201747,493250

In this blog, we will learn how to setup AdventureWorks Database in Microsoft SQL Server 2014.

Anoop Kumar SharmaAug 8, 201746,011250

In this blog we will learn a basic description about DDL, DML, DQL, DCL, TCL in Sql Server.

Jaipal ReddyAug 4, 2017273,840250

This script will perform bulk insert of images, documents in table.

Nisarg UpadhyayJul 30, 201710,066250

Bitwise operators in SQL server. Bitwise AND (&) and Bitwise Exclusive OR(^)(Caret symbol use in MS SQL server)

Ravi Kiran ChanduriJul 30, 201775,585250

The delete query should delete all duplicate rows except one. The output should be as shown below, after the delete query is executed.

Ajeet MalviyaJul 25, 201713,121250

Most of the time, if we have to rename a table or rename a column, we usually drop table and create table again, but with this approach we lose data. This approach may work in a development environment but in production we may not want to lose data. So how to achieve this? In SQL Server we can achieve it easily.

Anil JhaJul 14, 201720,789250

This blogs talks about Indexed Views in SQL Server and the pros and cons of using them.

Saravanan VJul 6, 201719,767250

This script will create table definition along with unique key, primary key and indexes.

Nisarg UpadhyayJul 4, 201715,861250

In this blog, I will demonstrate how to convert a table column in C# model class, using stored procedure.

Thiruppathi RJun 27, 201799,586250

In this blog, you will learn how to fix the error - "The Instance ID 'MSSQLSERVER' Is Already In Use By SQL Server Instance 'MSSQLSERVER.INACTIVE'.

Nisarg UpadhyayJun 27, 201777,745250

Using this function, we can get a list of all transactions performed in the database. Function name is fn_dblog() (Formally known as DBCC command).

Nisarg UpadhyayJun 27, 201715,566250

Time data type is a one of the new data type introduced in SQL Server 2008. It provided you the time with the accuracy of 100 nanoseconds.

Venkatesan JayakanthamJun 26, 201710,851250

In this blogI am going to write a function which returns the word count in sql server.

Pramod ThakurJun 22, 201749,683250

This blog helps to understand how we can do MS-SQL to JD Edwards date conversion.

Thiruppathi RJun 20, 20178,750250

This post provides some guidance on improving the slow performance stored procedures.

Saravanan VMay 30, 2017148,555250

This blog exhibits Columnstore Index in SQL Server.

Pravat KumarMay 16, 20176,546250

This blog show you how to use the nhibernate connection and transaction instead of opening a new ado connection.

Asad AliMay 16, 201711,640250