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 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
Explain Different types of Projects?1 1945
Please tell me some knowledge about Clustering and how to add clustering?1 1944
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?