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 4289
What is BCP? When do we use it?2 8081
What should we do to copy the tables, schema and views from one SQL Server to another?3 6086
What are the different types of joins and what does each do?2 5925
What is a sub-query? When would you use one?3 11160
What are three SQL keywords used to change or set someone?s permissions?3 11841
Using query analyzer, name 3 ways you can get an accurate count of the number of records in a table?5 12563
What is a trigger?7 4327
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 10113
What is an execution plan? When would you use it? How would you view the execution plan?1 4272
What does it mean to have quoted_identifier on? What are the implications of having it off?2 8301
What are the different types of replication? How are they used?3 9418
What is the difference between a local and a global variable?5 34311
What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?
What is Lock table in SQL?
can any body tell me how to know the password of current user in sql server
explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?
what is the sql equivaent of the dataset relation object ?
after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?
How can we call UDF(User Define Function) using C# code in ASP.net ?
how to use DTS package in 2000,2005,2008 in sql server
How to restore performance issues and how to check?
on line cluster can we make if yes tell me the procedure
what exactly sql injuction.how to overcome.....
What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.
Issues related in upgrading SQL Server 2000 to 2005 / 2008
ow to bring suspect mode datbase online from scratch
Working with TLogs