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 3468

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

1 1973

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

3 2308




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

683

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,

928

what is isolation level at dead lock?

Verizon,

988

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

Verizon,

1 2808

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

687




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

630

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

IBM,

2 2913

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

792

Working with TLogs

663

How you trouble shoot when any job fails

652

How to trouble shoot if unable to connect SQL Server

743

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

830


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

How much memory that we are using in Logshipping Concept?

674


1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

835


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

4889


Why do you want to join software field as you have done your BE in Electronics?

996


SQL Server Architecture ?

1103






explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?

1226


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

899


how many no of arguments can be passed in procedures and functions

3451


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


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 ...

911


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

790


Delete duplicate rows without using rowid.

157


Explain Capacity planning to create a database? and how to monitor it?

2742


How do use Having,Group by,Group function in SQL?

648


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.

1544