DevSocial Blogs · SQL Server blogs

Depending on the transaction level there are six types of locks that can be acquired on data and these are briefly explained below:

Nipun TomarApr 27, 20116,284250

The following are the different transaction levels in SQL Server:

Nipun TomarApr 27, 20114,499250

DELETE Table is used to delete the rows from the table, TRUNCATE Table is used to delete the entire rows of the table

Nipun TomarApr 22, 20113,582250

Lets see how soundex property of sql server works

Mayur GujrathiApr 20, 20113,940250

This blog will describe how to set compatibility level in sql server

Mayur GujrathiApr 20, 20115,621250

Microsoft SQL Server family includes free Express edition, that is fully functional, however has some disappointing limitations which prevent from using it in development process. One of them is absence of profiling tools, standard SQL profiler is not included.

Amit ChoudharyApr 14, 201116,168250

This blog will describe differences between delete table command and truncate table command

Mayur GujrathiApr 11, 20115,695250

This blog will describe how to create a table as it is as another table

Mayur GujrathiApr 11, 20114,680250

Difference between Candidate Keys and Primary Key.

This blog shows on how to Get time interval between 2 times in c#.

Karthikeyan AnbarasanMar 31, 20114,671250

This blog shows on how to Retrive DB informations in sql server.

Karthikeyan AnbarasanMar 31, 20113,015250

This blog shows on how to do a differential backup of a database with NoRecovery.

Karthikeyan AnbarasanMar 31, 20113,109250

This blog shows on how to do a full backup of a database with NoRecovery

Karthikeyan AnbarasanMar 31, 20112,844250

This blog shows on how to do a differential backup of a database in sql server.

Karthikeyan AnbarasanMar 31, 20113,225250

This blog shows on how to restore a database in sql server from a network share.

Karthikeyan AnbarasanMar 31, 20113,030250

This blog shows on how to restore a database log in sql server.

Karthikeyan AnbarasanMar 31, 20113,232250

This blog shows on how to restore a database file group in sql server.

Karthikeyan AnbarasanMar 31, 20113,566250

This blog shows on how to Insert a record into the database using C# code.

Karthikeyan AnbarasanMar 31, 20114,086250

This blog shows on how to do a Tail Log backup of a database with NoRecovery

Karthikeyan AnbarasanMar 30, 20113,361250

This blog shows on how to create a snapshot a database in SQL Server.

Karthikeyan AnbarasanMar 30, 20115,914250