SQL Server Interview Questions
Questions Answers Views Company eMail

Find 2nd Highest salery in emp table Select* from emp where &n= select * count from emp where (salery >=emp.salery) Enter n value 2 These query is correct or not. Tell me any other methods.

6 3783

What is the maximun sixes of .mdf in sql server 2005

1 2096

If any possiable to use 2 primary key in single table? How many primary key & foreign key used in each table(min & max)?

3 2483




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

781

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?

Verizon,

1022

what is isolation level at dead lock?

Verizon,

1082

what r steps to we need to fallow b4 kill the process?

Verizon,

1 2932

If the job running very slow what is the action you do

780




IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do

728

What is blocking in SQL Server? If this situation occurs how to troubleshoot this issue

IBM,

2 3063

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

900

Working with TLogs

750

How you trouble shoot when any job fails

774

How to trouble shoot if unable to connect SQL Server

853

If user is owning any SQL Objects, can we drop that user

920


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

1003


query processing

1078


How can we call UDF(User Define Function) using C# code in ASP.net ?

4823


How to convert a table data in XML format in sql server?

1480


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

380






What is RMS migrations?

1035


Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

887


Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.

1319


wat wil hapn if we give the both read and deny read permission to user?

1030


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

935


what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?

4881


how can you attach more than 20 ldf files in sql server

899


Any one plz send me SQL Server Developer/DBA resume for 4 years experience

1559


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

230


How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?

690