SQL Server Interview Questions
Questions Answers Views Company eMail

how to copy sysdatabase file from c: Drive to D: Drive in SQL Server.

IBM,

6 5279

create index a on employee(dno) In this,which index was created?

2 2584

How will u get 5 years back record?

5 5562




What is a materialized view?

3 5433

What is MSDE?

2 2311

How can you see what type of locks used?

1 2891

What is transcation?Plz give One example?

2 2615

Plz tell about backup&recovery?

3 2412




How to find the date and time of last updated table?

3 13910

What is WITH CHECK OPTION

Karur Vysya Bank KVB,

3 6839

create procedure proc1 (@a int) as begin if @a=1 create table #temp(a1 int) else create table #temp(a1 int) end while executeing the above code it shows error like '#temp already exist' .why it shows an error?

IBM,

8 5284

how to write the query to select the rows are in the order of either 1,3,5,7... or 2,4,6,8,...

Satyam, ADP, Tech Mahindra,

7 7499

which query u can write to sql server doesn't work inbetween 7.00PM to nextday 9.00AM

Wipro,

5 6943

can you anybody tell me the how can you restore the master database. while migraion(one server to onther server)?

1 2532

can you any body tell me why are go for the rebuild the master database.what is the reason?

2 2230


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.

658


your distribution database is full what will u do

907


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

972


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

100


What is the query optimization statistics?

1178






what is checksum in sql server.........???

339


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

4686


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

876


can any body tell me how to know the password of current user in sql server

878


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

1192


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?

817


If a stored procedure is taking a table data type, how it looks?

4561


1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?

737


System variable and temporary variables

929


how to overcome kernel isssues

435