SQL Server Interview Questions
Questions Answers Views Company eMail

Can Having clause be used without Group by clause?

CSC, CTS, CarrizalSoft Technologies,

6 29344

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

1 2779

Define Check points and End Points?

1 1921




How to know whether our backup is succesfully taken?

1 1673

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

2 2826

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

1 1932

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

Wipro,

2 3419

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

2 2802




What is Schema? and why we use schemas?

4 5105

How do you Implement SSIS Packages in your Project?

869

Explain Different types of Projects?

1 2119

What is data modeling and Reterminal integrity?

704

How to restore performance issues and how to check?

883

Tell about MOM Tool(Microsoft Operator Manager)?

719

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

1 2110


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

how can you attach more than 20 ldf files in sql server

865


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.

1289


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.

733


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

927


What is the difference between online clustering and Offline clustering?

1259






plss anybody specify tha constrian management system in dbms

856


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

976


code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that

1081


Explain Capacity planning to create a database? and how to monitor it?

2884


How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?

965


How we create SQL Server 2005 Reporting Services ? Give me Sample

947


my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions

907


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

2779


Scalability, Availability, Integration with internet, etc.)?

1685


your distribution database is full what will u do

994