SQL Server Blogs

Post

SQL Server

Welcome to SQL Server section of C# Corner. In this section, you will find various SQL Server related source code samples, articles, tutorials, and tips.

Blogs

SQL Query to Find Required Indexes and Unused Indexes

Find required indexes and unused indexes in a sql server table.
Ravi Shekhar Sep 21, 2013
DIfference Between Index Rebuild and Index Reorganize

Index Rebuild and Index Reorganize in sql server.
Ravi Shekhar Sep 18, 2013
Join vs Exists in SQL Server

This blog defines Join vs Exists in SQL Server.
Ashutosh Tripathi Sep 11, 2013
SQL Server Full Backups using T-SQL and SSMS

In this blog, covers the basics of full backups in SQL Server.
Om Agarwal Sep 10, 2013
How to Enable/Disable CLR in SQL Server

We can use this option to prevent any DDL operation.
Ravi Shekhar Sep 06, 2013
Use of DDL Trigger in SQL Server

Create log of any DDL statement in Database with the help of DDL trigger in SQL Server.
Ravi Shekhar Sep 05, 2013
How to get required index in SQL Server table

This blog shows you to get required Nonclustered index in sql server table
Ravi Shekhar Sep 04, 2013
Important Server Property in SQL Server

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 Agarwal Sep 02, 2013
Simple Trigger for any Update and Delete

Today, I am going to show you the simplest example of trigger for looking any modification happens in your Table.
Ratnesh Singh Aug 26, 2013
How to Restore Database or Create Database without .LDF

Database creation without .ldf in SQL Server.
Ratnesh Singh Aug 26, 2013
Side effects of table compression in sql server(Enterprise edition)

I have found some points about table compression side effects.
Ravi Shekhar Aug 26, 2013
Split large string in SQL Server

How to split large string separated by comma in SQL Server.
Pankaj Kumar Aug 19, 2013
Sql Server comma separated(,)

How to get column values as comma separated list in SQL Server.
Pankaj Kumar Aug 17, 2013
How to Create Log Table in Ms SQL Server with the Help of Triggers

Having 2.6 years of experience in SQL DBA . Want to share some of my experience regarding task assigned to me.
Ratnesh Singh Aug 14, 2013
SQL Server Profiler Trace Tutorial

Learn how to use SQL Server Trace tool.
Ratnesh Singh Aug 13, 2013
Create a Comma Separated List from Column using Select Statement

In this blog I am explaining two methods for a comma separated list from column using COALESCE and STUFF function in select statement.
Om Agarwal Aug 01, 2013
Create Linked Server for Remote SQL Server

I'll show you how to create linked server for remote access in sql server 2008 r2.
Muhammad younas Jul 31, 2013
Get Schema of a Objects and How to Change the Schema of a Objects in SQL Server

In this blog I am determining the Schema of a objects and How to change the schema of a objects in SQL Server using below given Query. This query show all Schema of a objects in Existing database...
Om Agarwal Jul 26, 2013
Stop SQL Server Directly using T-SQL

If you want to directly stops SQL Server by T-SQL (without execution Checkpoint Databases).
Om Agarwal Jul 22, 2013
Get all Database Files (data, logs) in SQL Server

In this blog, Today I am determining all database files (data, logs) size and growth in SQL Server below given Query.
Om Agarwal Jul 22, 2013

781 - 800 of 1267

Learn SSRS In 11 Hours

Challenge yourself

SQL Server

E-Book Download

Get Certified

MongoDB