SQL Server Interview Questions
Questions Answers Views Company eMail

Can Having clause be used without Group by clause?

CSC, CTS, CarrizalSoft Technologies,

6 28893

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

1 2676

Define Check points and End Points?

1 1861




How to know whether our backup is succesfully taken?

1 1629

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

2 2772

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

1 1893

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

Wipro,

2 3371

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

2 2747




What is Schema? and why we use schemas?

4 4989

How do you Implement SSIS Packages in your Project?

834

Explain Different types of Projects?

1 2071

What is data modeling and Reterminal integrity?

668

How to restore performance issues and how to check?

844

Tell about MOM Tool(Microsoft Operator Manager)?

681

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

1 2058


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

How to convert a table data in XML format in sql server?

1399


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

4646


sql database suspect We have a sql database that is showing as suspect. How can we recover?

710


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

1040


What is data modeling and Reterminal integrity?

668






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

1061


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

879


how can u get last observation in an unknown dataset ?

1147


1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?

781


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

4678


How you trouble shoot when any job fails

684


1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

864


Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...

936


How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

881


What is RMS migrations?

954