SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Querying Microsoft SQL Server

I am a technology enthusiast and software developer by profession. I am developing .Net/database based enterprise applications from past 3 years.

My skills includes C# ,ASP.NET,SQL Server 2008 and MVC . My areas of interests are database development and application software development using Microsoft Technologies.

Archives: January 2013

SQL Server

What is SQL Server?
Microsoft SQL Server is Relational database management system (RDBMS) developed and owned by Microsoft. It is a software product whose primary function is to store and retrieve data as requested by other software applications, be it those on the same computer or those running on another…

Read more

0 comments, 403 reads

Posted in Querying Microsoft SQL Server on 28 January 2013

DBCC Commands for SQL Server

DBCC Commands:
DBCC commands are most useful for performance and troubleshooting.
The DBCC Commands are used in Maintenance, Informational use, Validation on a database, index, or file group. Theses commands are helpful to check physical and logical consistency of database. Some DBCC statements fix errors automatically. Here I am showing…

Read more

0 comments, 1,113 reads

Posted in Querying Microsoft SQL Server on 28 January 2013

Frequently asked Scripts during Interviews

1. Select no of Months between two dates:

    DATEDIFF(MONTH, '4/1/2011', '01/23/2013') +
        WHEN DAY('4/1/2011') < DAY('01/23/2013')
        THEN 1
        ELSE 0

2. What will be the output of…

Read more

1 comments, 488 reads

Posted in Querying Microsoft SQL Server on 24 January 2013