SQL Server Interview Questions
Questions Answers Views Company eMail

what is the disadvantage of SQL Loder?

TCS,

1 4183

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 5960

what is difference between Enterprise Manager and Query Analyer

CTS,

6 4615




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

Synergy,

1 4511

what is DTS what are tasks available

Wipro,

1 1963

Normalization and denormalization

Wipro,

3 3499

Diffrent types of function

Wipro,

1 2386

diffrence between function and procedure

Wipro,

4 3254




diffrence between Cluster Index and non Cluster Index

Wipro,

3 3262

System variable and temporary variables

Wipro,

980

optimization techinques

Wipro,

1330

user defined datatypes

Wipro,

1 2768

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

817

Magic Tables ?

Thomson Reuters,

2 3530

Diffrences between sql server 2000 vs 2005

Thomson Reuters,

2 2758


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

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

817


What is data modeling and Reterminal integrity?

668


what is difference between view and Dip.

1206


Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

712


hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.

1618






how to use DTS package in 2000,2005,2008 in sql server

779


my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions

877


ow to bring suspect mode datbase online from scratch

685


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

1145


where the connection string store in the database

819


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

940


after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?

949


whats the maximum size of view state??

948


What is best institute to Learn DotNET And SQL in chennai?

969


what is the Ticketing tool used in Wipro technologies at Bangalore...???

5019