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 3551

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

1 2006

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

3 2373




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

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,

949

what is isolation level at dead lock?

Verizon,

1009

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

Verizon,

1 2850

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

715




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

657

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

IBM,

2 2953

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

819

Working with TLogs

683

How you trouble shoot when any job fails

684

How to trouble shoot if unable to connect SQL Server

767

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

853


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

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

831


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


Tell about MOM Tool(Microsoft Operator Manager)?

682


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

3493


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

1501






How do you Implement SSIS Packages in your Project?

834


What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks

904


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

920


What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

2677


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

969


What is data modeling and Reterminal integrity?

668


hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

773


what is package and it uses and how can u call a package

886


whats the maximum size of view state??

949


How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

881