Follow Our FB Page << >> 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 ??


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


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


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.



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


2 5305

what is the difference between table and view

1 1922

plss anybody specify tha constrian management system in dbms

Police Constable,


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?


3 4730

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


3 4378

Un-Answered Questions { SQL Server }

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


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


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


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


What is difference between index seek vs. Index scan?


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


i have made a project i 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.


What is a trigger in sql server?


what is normalization? : Sql server database administration


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


What are the rendering extensions of ssrs?


Explain what is analysis service repository?


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


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


Why transaction is important?