SQL Server Interview Questions
Questions Answers Views Company eMail

Can Having clause be used without Group by clause?

CSC, CTS, CarrizalSoft Technologies,

6 28052

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

1 2580

Define Check points and End Points?

1 1769




How to know whether our backup is succesfully taken?

1 1546

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

2 2688

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

1 1832

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

Wipro,

2 3299

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

2 2660




What is Schema? and why we use schemas?

4 4849

How do you Implement SSIS Packages in your Project?

790

Explain Different types of Projects?

1 1990

What is data modeling and Reterminal integrity?

619

How to restore performance issues and how to check?

798

Tell about MOM Tool(Microsoft Operator Manager)?

634

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

1 1984


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


optimization techinques

1238


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.

1219


Delete duplicate rows without using rowid.

138


What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

1105






how to do partition in sqlserver

1265


1 01 101 01010

690


1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?

798


What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.

1527


your distribution database is full what will u do

910


Which is the best place or learning center for MS SQL?????In Bangladesh?????

830


System variable and temporary variables

931


How do use Having,Group by,Group function in SQL?

623


how to use DTS package in 2000,2005,2008 in sql server

736


what is isolation level at dead lock?

969