SQL Server Interview Questions
Questions Answers Views Company eMail

Can Having clause be used without Group by clause?

CSC, CTS, CarrizalSoft Technologies,

6 29740

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

1 2839

Define Check points and End Points?

1 1976




How to know whether our backup is succesfully taken?

1 1719

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

2 2887

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

1 1969

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

Wipro,

2 3466

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

2 2844




What is Schema? and why we use schemas?

4 5186

How do you Implement SSIS Packages in your Project?

903

Explain Different types of Projects?

1 2163

What is data modeling and Reterminal integrity?

739

How to restore performance issues and how to check?

918

Tell about MOM Tool(Microsoft Operator Manager)?

761

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

1 2153


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

853


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

2947


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

983


How should i optimize the time for execution of stored procedure having single input and many output from the different tables?

894


in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

380






IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do

728


How do you Implement SSIS Packages in your Project?

903


New concepts of sql server 2005 use in your project.

1303


how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

1113


Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?

1380


How can we call UDF(User Define Function) using C# code in ASP.net ?

4823


1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do

1430


application server is slow what may be the problem

1152


If a stored procedure is taking a table data type, how it looks?

4791


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 ?

930