Let us say master db itself has no backup. Now you have to rebuild the db so what kind of action do you take?1 4466
What is BCP? When do we use it?2 8183
What should we do to copy the tables, schema and views from one SQL Server to another?3 6232
What are the different types of joins and what does each do?2 6041
What is a sub-query? When would you use one?3 11406
What are three SQL keywords used to change or set someone?s permissions?3 12216
Using query analyzer, name 3 ways you can get an accurate count of the number of records in a table?5 12809
What is a trigger?7 4499
What is one of the first things you would do to increase performance of a query? For example, a boss tells you that ?a query that ran yesterday took 30 seconds, but today it takes 6 minutes?2 10447
What is an execution plan? When would you use it? How would you view the execution plan?1 4535
What does it mean to have quoted_identifier on? What are the implications of having it off?2 8573
What are the different types of replication? How are they used?3 9758
What is the difference between a local and a global variable?5 34902
Why do you want to join software field as you have done your BE in Electronics?
What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?
Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)
How to restore performance issues and how to check?
How to trouble shoot if unable to connect SQL Server
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 checksum in sql server.........???
what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?
1 01 101 01010
How can we call UDF(User Define Function) using C# code in ASP.net ?
whats the maximum size of view state??
What is the difference between online clustering and Offline clustering?
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 much memory that we are using in Logshipping Concept?