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?


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?


Explain Different types of Projects?

1 2163

What is data modeling and Reterminal integrity?


How to restore performance issues and how to check?


Tell about MOM Tool(Microsoft Operator Manager)?


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.


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


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


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


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


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


How do you Implement SSIS Packages in your Project?


New concepts of sql server 2005 use in your project.


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., }


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


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


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


application server is slow what may be the problem


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


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 ?