SQL Server Interview Questions
Questions Answers Views Company eMail

What is Check point? Explain in Brief what it will do?

Wipro,

1 3828

What is DAC? what is the use of it?

Wipro,

1 4077

what is Buffer cash and Log Cache? Can you Explain it?

Wipro,

1 6021




hi i am having .mdf file and .ldf file ..how can i get the all table in my .mdf..plz give solution

2 2310

does physical index sort data

1 2070

what type of indexes physically sort data?

3 4292

what is differencial backup?how to work?Anybody explai it?

HCL,

2 2731

what is sql injection in sql server?

TATA,

2 3599




what is node in sql server?

Google, NIIT, TATA, CarrizalSoft Technologies, Nittany,

2 20218

How to store pdf file in sql server?

TATA, CarrizalSoft Technologies, College School Exams Tests,

1 4611

What is difference between stored procedure & function?

TATA, CarrizalSoft Technologies, Concept Infoway,

3 4352

How to Rebuild Master database in sql server 2005.

Wipro,

2 3212

please bar with my english i having a database called tblhallreservation in which res_date is date field has to select all the fields in table deponding on month either has to display all details for the month jan or feb and so on

1 1701

create table with fields ID, reserved_by,res_date res_date is datefield like 2010-03-09 00:00:00.000 from 2005 to 2006 any date assume based on res_date need to slect table and display based on month (full jan details in database irrespective of date and year

3 2300

what is trigger . hw will it use them

TCS,

2 3599


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

OPTIMIZATION OF SP,CURSOR,TRIGGERS

1479


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

935


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

792


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?

588


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.

2648






SQL Server Architecture ?

1101


What are the dis_advantages of stored procedures, triggers, indexes?

934


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

828


Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?

1271


application server is slow what may be the problem

1065


How much memory that we are using in Logshipping Concept?

674


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

1226


Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .

813


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

851


You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?

1018