Why we avoid permitting null values

Posted on June 23rd , 2009 by Admin

Diffrence between Extents and Page

Posted on June 23rd , 2009 by Admin

Diffrence between varchar and nvarchar

Posted on June 23rd , 2009 by Admin

Change Tracking in SQL Server 2008

Posted on June 22nd , 2009 by Admin

Why we use SET ROWCOUNT in Sql

Posted on June 18th , 2009 by Admin

Why we use Unicode In Sql server

Posted on May 30th , 2009 by Admin

What is a join and List different types of joins

Posted on May 30th , 2009 by Admin

Difference between Triggers and Storedprocedures

Posted on May 30th , 2009 by Admin

How does .NET and SQL SERVER thread is work

Posted on May 30th , 2009 by Admin

Diffrence between temp table and table variable

Posted on May 30th , 2009 by Admin

How many types of local table in sql define with syntax

Posted on May 30th , 2009 by Admin

What is Store Procedure

Posted on May 30th , 2009 by Admin

How to get all the parameter of store procedure through query

Posted on May 30th , 2009 by Admin

What is SQL tuning

Posted on May 30th , 2009 by Admin

What is SQL injection

Posted on May 30th , 2009 by Admin

What is SET operator in SQL SERVER

Posted on May 29th , 2009 by Admin

How ROW_NUMBER function helps and what is its functioning

Posted on May 29th , 2009 by Admin

Can you define ROLLUP in SQL SERVER 2005

Posted on May 29th , 2009 by Admin

What about the SQL SERVER 2008

Posted on May 28th , 2009 by Admin

How many records can take clustured index in sql

Posted on May 25th , 2009 by Admin

What is Cascade and Restrict when we use DROP table in SQL SERVER

Posted on May 22nd , 2009 by Admin

Some Tips when Optimizing Sql Server 2005 Query

Posted on May 22nd , 2009 by Admin

What is SQL whats its uses and its component

Posted on May 22nd , 2009 by Admin

What is heap table in SQL SERVER

Posted on May 22nd , 2009 by Admin

What is SQL Cache Dependency in ASP.NET 2.0

Posted on May 22nd , 2009 by Admin

How many types of local tables in SQL SERVER

Posted on May 22nd , 2009 by Admin

How to load .NET code in SQL SERVER 2005

Posted on May 22nd , 2009 by Admin

Where .NET CLR and SQL SERVER run

Posted on May 22nd , 2009 by Admin

What are Checkpoint in SQL Server

Posted on May 22nd , 2009 by Admin

Can You explain integration between SQL Server 2005 and Visual Studio 2005

Posted on May 22nd , 2009 by Admin

What is the diffrence between SQL and Pl Sql

Posted on May 22nd , 2009 by Admin

What is the difference between UNION ALL Statement and UNION

Posted on May 22nd , 2009 by Admin

Write some disadvantage of Cursor

Posted on May 22nd , 2009 by Admin

What is Log Shipping and its purpose

Posted on May 22nd , 2009 by Admin

What are the null values in SQL SERVER

Posted on May 22nd , 2009 by Admin

Write a Role of Sql Server 2005 in XML Web Services

Posted on May 22nd , 2009 by Admin

What are the different types of Locks

Posted on May 22nd , 2009 by Admin

Explain some SQL Server 2000 Query

Posted on May 22nd , 2009 by Admin

What is Write ahead log in Sql Server 2000

Posted on May 22nd , 2009 by Admin

What do u mean by Extents and types of Extends

Posted on May 22nd , 2009 by Admin

What is different in Rules and Constraints

Posted on May 22nd , 2009 by Admin

What is defaults in Sql Server and types of Defaults

Posted on May 22nd , 2009 by Admin

What Is Database

Posted on May 22nd , 2009 by Admin

what is Relational Database

Posted on May 22nd , 2009 by Admin

What is COMMIT and ROLLBACK statement in SQL

Posted on May 22nd , 2009 by Admin

What is diffrence between OSQL and Query Analyzer

Posted on May 22nd , 2009 by Admin

What is Data Integrity and its categories

Posted on May 22nd , 2009 by Admin

SQL Server runs on which TCP IP port and From where can you change the default port

Posted on May 22nd , 2009 by Admin

What is the use of DBCC commands

Posted on May 22nd , 2009 by Admin

What is the difference between a HAVING CLAUSE and a WHERE CLAUSE

Posted on May 22nd , 2009 by Admin

When do you use SQL Profiler

Posted on May 22nd , 2009 by Admin

Can you explain the role of each service

Posted on May 22nd , 2009 by Admin

What is Normalization

Posted on May 22nd , 2009 by Admin

Can you explain what View is in SQL

Posted on May 22nd , 2009 by Admin

How to get which Process is Blocked in SQL SERVER

Posted on May 22nd , 2009 by Admin

Can you tell me the difference between DELETE and TRUNCATE commands

Posted on May 22nd , 2009 by Admin

What are the Global Temporary Tables

Posted on May 22nd , 2009 by Admin

What are the advantage of User Defined function over store procedure

Posted on May 22nd , 2009 by Admin

Define basic functions for master and msdb and tempdb databases in Sql Server

Posted on May 19th , 2009 by Admin

What is Cursor

Posted on May 19th , 2009 by Admin

What is Collate in SQL SERVER2000

Posted on May 18th , 2009 by Admin

What is difference between OSQL and Query Analyzer

Posted on May 2nd , 2009 by Admin