My Database team is working on, to find the database traffic on the server. The database is heavily used by the Online appllication and it is 24/7. We would like to see when the database is heavily loaded and see if there are any processes blocking each other which results in slower performance. One...

In this article I would like to give you an overview on various string functions that are available in SQL Server and are widley used at work. In this IT world 50% of the databases consist of CHAR, NCHAR, VARCHAR, and NVARCHAR as data types to store the values. When you are joining the tables bas...

There are several predefined stored procedures are available in SQL Server which we are using in our day-to-day life to resolve some of the issues like below. 1) I want to see the all columns of the tables. 2) I want to see who are all logged into Database. 3) I want to see the Constraint infor...

60 seconds with Pinal Dave: MVP award played an important role in helping me chase my passion to make a difference. VJ caught up with Pinal Dave, MVP in SQL Server, to get his view on the Microsoft Most Valuable Professional Program(MVP).

In this article I would like to show you on how to find the check constraints defined on a table. In my previous articles I explained about on Check Constraint creation at the Table Level and also at the Column Level.

In this article I will talk about Table Level Constraints in SQL Server. These are very useful if you want to have rules based on multiple columns with in a table. Lets say busines says "I want to set is if a person opens check-in account and savings account then minimum balance should not be l...

In this article I would like to explain about “Constraints”. Constrains are one of the key factor in designing a table. Before I explain what is the use of constrains lets take one real world example. When you are opening a bank account bank says, you need to maintain minimum balance of 1000 in your...

In this article I would like to explain about how to rename a table using SQL Server Management Studio (SSMS). This is very simple step. There are several ways to do it but i would like to show very simple process.

This link contains list of SQL Server Beginer Articles to start with. Starting from creating a table to Bulk Insert to copy data from text file.

In my previous section I explained about OUTPUT feature in SQL Server. In this section I will go one step ahead and will tell you, how you can use this feature to implement MERGE in SQL Server 2005.

In this section i would like to give you a small tip about creating a table in SQL Server with out using CREATE TABLE statement.

In this session, I would like to talk about one very interesting feature of SQL Server 2005. Before I say anything about this feature let me ask you some simple question.

Today I will talk about loading a CSV or comma or txt file into SQL Server using BULK INSERT. Using BULK INSERT, in few steps you can load the file into database.

One of common query that we execute on day-to-day to basis is Dropping and re-creating a table when you are as beginner.