1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category


SQL Server Interview Questions
Questions Answers Views Company eMail

Can Having clause be used without Group by clause?

CarrizalSoft Technologies, CSC, CTS,

6 40022

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

 1 3739

Define Check points and End Points?

 1 3032

How to know whether our backup is succesfully taken?

 1 2817

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

 2 4006

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

 1 2948

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

Wipro,

2 4773

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

 2 4010

What is Schema? and why we use schemas?

 4 7309

How do you Implement SSIS Packages in your Project?

 1502

Explain Different types of Projects?

 1 3116

What is data modeling and Reterminal integrity?

 1477

How to restore performance issues and how to check?

 1511

Tell about MOM Tool(Microsoft Operator Manager)?

 1403

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

 1 3125

Un-Answered Questions { SQL Server }

What is named query? : sql server analysis services, ssas

503

How can we remove orphan records from a table?

514

Give me a SQL Query to find out the second largest company?

677

Explain what are the authentication modes in sql server?

492

How do you manipulate data?

480




How to download microsoft sql server 2005 express edition?

567

Determine when to use stored procedure to complete sql server tasks?

527

What do you mean by data manipulation language?

580

Can a database be shrunk with users active?

594

When do you think a developer should use sql server-based cursors?

511

What is row_number () and partition by in sql server?

512

what is the difference between openrowset and openquery?

585

When would you use a before or after trigger?

479

What keyword you will use to get schema appended to the result set of a ‘for xml’ query?

585

What is the difference between the 2 operating modes of database mirroring?

570

For More Un-Answered { SQL Server } Questions Click Here