SQL Server Interview Questions
Questions Answers Views Company eMail

Can Having clause be used without Group by clause?

CSC, CTS, CarrizalSoft Technologies,

6 27428

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

1 2541

Define Check points and End Points?

1 1726

How to know whether our backup is succesfully taken?

1 1515

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

2 2629

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

1 1797

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


2 3234

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

2 2597

What is Schema? and why we use schemas?

4 4756

How do you Implement SSIS Packages in your Project?


Explain Different types of Projects?

1 1945

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 1944

Post New SQL Server Questions

Un-Answered Questions { SQL Server }

your distribution database is full what will u do


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.


What is data modeling and Reterminal integrity?


If the job running very slow what is the action you do


Delete duplicate rows without using rowid.


Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you


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


which backup strategy you are following at ur company


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


You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?


What is the difference between NOROW and LOCKROW?


how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A


what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?


how many no of arguments can be passed in procedures and functions


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