Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...



SQL Server Interview Questions
Questions Answers Views Company eMail

Can anyone explain difference between Database, Data warehouse and Data mart with some example?````

4 4134

how to get max salary with employee number by using one select query and max function ??

Genpact,

3 5146

What are the difference between data length and length in SQL Server-2008?

Scio Healthcare,

3 3790

Why foreign key column allowing null values even a parent tables reference key column not having null value..

IBM,

2 4243

Can someone suggest me the best institute to learn SQL Server... I want to gain in depth knowledge on SQL Server Development. I have been to naresh, peers, sql school,mind q systems... Any idea about best faculty....

3 2675

Write a query to get all details of employee who has maximum salary from employee table

AON, Genpact,

8 11100

Ek lifafa 10 noto se bhara hai usme 2 or 5 ke note nahi hai aur usme total 50Rs hai, to batao lifafe me kon se not kitne hia it’s a challenge thank’s

Broadridge,

6 8293

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.

HCL,

1514

Suppose i have one sql query that contains 2 minute to execute.After one weekly i am executing same query that is taking 5 minute.Why our same query is taking more time.what would be my approach to reduce execution time.Please help.

Cognizant, HCL, Value Labs,

1 6066

how many non clustered index in sql server 2008,2010,2012

Accenture,

2 5305

what is the difference between table and view

1 1922

plss anybody specify tha constrian management system in dbms

Police Constable,

1093

How to genrate automaticlly empid like gt001

4 3194

Can I recover a damaged SQL Server 2008 database with the undamaged .mdb and .ldf files?

Apple,

3 4730

Can we create SP inside SP ? If no Y ? If yes Y ? Explain with an example ?

IBM, L&T,

3 4378







Un-Answered Questions { SQL Server }

Can I run multiple instances of sql server 2000 at the same time on one computer?

163


What are the authentication modes in sql server? How can it be changed?

170


can you instantiate a com object by using t-sql? : Sql server database administration

117


Write an sql query to find first weekday of the month?

125


What is difference between index seek vs. Index scan?

175






What are ddl (data definition language) statements for tables in ms sql server?

150


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.

980


What is a trigger in sql server?

132


what is normalization? : Sql server database administration

123


How to create new tables with "create table" statements in ms sql server?

149


What are the rendering extensions of ssrs?

23


Explain what is analysis service repository?

132


What is the name of reporting services config file and what’s it’s used for?

36


Where do you find the default Index fill factor and how to change it?

174


Why transaction is important?

136