DevSocial Blogs · SQL Server blogs

This blog defines how to get index fragmentation.

Ravi ShekharOct 17, 20137,525250

In this blog I am going to explain how to copy tables form one data base to other database in SQL Server 2008 R2

Kiran Kumar TalikotiOct 16, 20133,854250

Indexes are the most important factor for identifying the relevant data rows quickly.

Gohil JayendrasinhOct 7, 20139,215250

In this blog, You will know difference between Primary key and Unique key.

Ravit ChaudharyOct 3, 20138,252250

Use of “IN” in dynamic SQL query.

Ravi ShekharSep 30, 20134,881250

In this blog you will learn how to enable SQL Server 2008 broker.

Raj KumarSep 27, 201398,823250

Remove duplicate records from a table in SQL Server.

Get all indexes script with table script in SQL Server.

Ravi ShekharSep 23, 2013144,300250

Find required indexes and unused indexes in a sql server table.

Ravi ShekharSep 23, 20139,587250

We will look into different ways to retrieve SQL Server's version, edition using SQL Queries.

Sateesh ArvetiSep 23, 20134,418250

Index Rebuild and Index Reorganize in sql server.

Ravi ShekharSep 18, 201323,048250

This blog defines Join vs Exists in SQL Server.

Ashutosh TripathiSep 11, 20134,356250

In this blog, covers the basics of full backups in SQL Server.

Om AgarwalSep 10, 20133,934250

We can use this option to prevent any DDL operation.

Ravi ShekharSep 6, 201345,418250

Create log of any DDL statement in Database with the help of DDL trigger in SQL Server.

Ravi ShekharSep 5, 20137,354250

This blog shows you to get required Nonclustered index in sql server table

Ravi ShekharSep 4, 20134,493250

In this Blog We can get significant server property which returns all information about the SQL Server instance. Use following script to see all the properties of server instance.

Om AgarwalSep 2, 20135,456250

Database creation without .ldf in SQL Server.

Ratnesh SinghAug 26, 20136,420250

Today, I am going to show you the simplest example of trigger for looking any modification happens in your Table.

Ratnesh SinghAug 26, 20135,590250

I have found some points about table compression side effects.

Ravi ShekharAug 26, 20135,519250

Learn how to use SQL Server Trace tool.

Ratnesh SinghAug 21, 20137,226250

How to split large string separated by comma in SQL Server.

Pankaj KumarAug 21, 20134,111250

Having 2.6 years of experience in SQL DBA . Want to share some of my experience regarding task assigned to me.

Ratnesh SinghAug 19, 201334,602250

How to get column values as comma separated list in SQL Server.

Pankaj KumarAug 18, 20133,465250