SQL Server Interview Questions
Questions Answers Views Company eMail

what is the disadvantage of SQL Loder?

TCS,

1 4091

Write a stored procedure for emplpoyee and department table to get DeptName which having no employee. Table Structure- Emp-Emp_Id,Emp_Name,Dept_id Dept-Dept_Id,Dept_Name

TCS,

7 5865

what is difference between Enterprise Manager and Query Analyer

CTS,

6 4530




WHAT IS THE DIFFERENCE BETWEEN CANDIDATE KEY ,COMPOSITE KEY AND PRIMARY KEY. THAN U.

Synergy,

1 4467

what is DTS what are tasks available

Wipro,

1 1928

Normalization and denormalization

Wipro,

3 3428

Diffrent types of function

Wipro,

1 2323

diffrence between function and procedure

Wipro,

4 3176




diffrence between Cluster Index and non Cluster Index

Wipro,

3 3193

System variable and temporary variables

Wipro,

956

optimization techinques

Wipro,

1276

user defined datatypes

Wipro,

1 2719

How should i optimize the time for execution of stored procedure having single input and many output from the different tables?

789

Magic Tables ?

Thomson Reuters,

2 3464

Diffrences between sql server 2000 vs 2005

Thomson Reuters,

2 2701


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that

1016


what are the Prerequisites for Replication?

8340


Call by value and call by reference in procedure and function, with NOCOPY.

122


What are the dis_advantages of stored procedures, triggers, indexes?

934


hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

1118






What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.

1543


How much memory that we are using in Logshipping Concept?

674


How we create SQL Server 2005 Reporting Services ? Give me Sample

886


You are doing log shipping due to some reasons it is failing. How you will proceed from there

792


Which is the best place or learning center for MS SQL?????In Bangladesh?????

848


System variable and temporary variables

956


I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that

641


can any body tell me how to know the password of current user in sql server

894


How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?

914


Issues related in upgrading SQL Server 2000 to 2005 / 2008

740