How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?3 8222
What are the different ways of moving data/databases between servers and databases in SQL Server?1 2657
What is database replicaion? What are the different types of replication you can set up in SQL Server?3 3481
There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?1 2336
What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?1 2657
How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?
As a part of your job, what are the DBCC commands that you commonly use for database maintenance?
What are statistics, under what circumstances they go out of date, how do you update them?
What are the different ways of moving data/databases between servers and databases in SQL Server?
Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
You are doing log shipping due to some reasons it is failing. How you will proceed from there
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?
which backup strategy you are following at ur company
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’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?
How to restore performance issues and how to check?
1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do
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?
What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?
what are the critical issues you have resloved in your company
How much memory that we are using in Logshipping Concept?
How retrieve field names from the table in SQL through JAVA code?
your distribution database is full what will u do
whats the maximum size of view state??