SQL Server Interview Questions
Questions Answers Views Company eMail

Can Having clause be used without Group by clause?

CSC, CTS, CarrizalSoft Technologies,

6 28477

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

1 2610

Define Check points and End Points?

1 1808




How to know whether our backup is succesfully taken?

1 1573

What is a Lock and let me know Different types of locks?

2 2716

What is a Trace frag?Where can we use this?

1 1855

How many .ndf files can we create in Sql server 2005?

Wipro,

2 3323

How to Create Login and User through query in Sql server 2005.and also how to delete Login and User through query?

2 2691




What is Schema? and why we use schemas?

4 4922

How do you Implement SSIS Packages in your Project?

809

Explain Different types of Projects?

1 2012

What is data modeling and Reterminal integrity?

633

How to restore performance issues and how to check?

813

Tell about MOM Tool(Microsoft Operator Manager)?

653

Please tell me some knowledge about Clustering and how to add clustering?

1 2008


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

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

871


How to trouble shoot if unable to connect SQL Server

744


what exactly sql injuction.how to overcome.....

1286


System variable and temporary variables

957


tell me the disaster recovery plan

1261






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

937


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.

684


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

687


How you trouble shoot when any job fails

652


1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.

338


what is the sql equivaent of the dataset relation object ?

808


wat wil hapn if we give the both read and deny read permission to user?

907


What is the difference between online clustering and Offline clustering?

1197


How to convert a table data in XML format in sql server?

1370


sql database suspect We have a sql database that is showing as suspect. How can we recover?

688