How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?3 10004
What are the different ways of moving data/databases between servers and databases in SQL Server?1 3634
What is database replicaion? What are the different types of replication you can set up in SQL Server?3 5201
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 3490
What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?1 3741
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?
How to create a simple user defined function in ms sql server?
How to generate create function script on an existing function?
What are the options which must be set to allow the usage of optimistic models?
Can you please explain the difference between primary keys and foreign keys?
How many full-text indexes can a table have?
How do I manually uninstall an instance of sql server 2016?
How to insert stored procedure result into temporary table?
How to verify the port number of the sql server?
Explain the purpose of indexes?
How to create sub reports?
What method is used by the Command classes to execute SQL statements that return single values?
Which one is faster delete/truncate? Why?
How to insert new line characters into strings?
What are sub reports?
In how many ways you can invoke ssrs reports?