SQL Server Interview Questions
Questions Answers Views Company eMail

what is the disadvantage of SQL Loder?

TCS,

1 4000

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 5781

what is difference between Enterprise Manager and Query Analyer

CTS,

6 4449




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

Synergy,

1 4434

what is DTS what are tasks available

Wipro,

1 1896

Normalization and denormalization

Wipro,

3 3370

Diffrent types of function

Wipro,

1 2274

diffrence between function and procedure

Wipro,

4 3109




diffrence between Cluster Index and non Cluster Index

Wipro,

3 3140

System variable and temporary variables

Wipro,

928

optimization techinques

Wipro,

1236

user defined datatypes

Wipro,

1 2671

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

768

Magic Tables ?

Thomson Reuters,

2 3418

Diffrences between sql server 2000 vs 2005

Thomson Reuters,

2 2663


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

264


1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do

1245


what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?

812


Does any body please help me what question's have asked for SSRS in the interview?

794


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?)

669






what are the critical issues you have resloved in your company

770


How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.

2628


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

4788


Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...

889


Delete duplicate rows without using rowid.

135


plss anybody specify tha constrian management system in dbms

771


Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you

530


How to trouble shoot if unable to connect SQL Server

725


Working with TLogs

640


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

1096