How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?
3 11614What are the different ways of moving data/databases between servers and databases in SQL Server?
1 4499What is database replicaion? What are the different types of replication you can set up in SQL Server?
3 6603There 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 4205How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?
HCL,
3 11206As a part of your job, what are the DBCC commands that you commonly use for database maintenance?
HCL,
1 8442What are statistics, under what circumstances they go out of date, how do you update them?
HCL,
2 8990What are the different ways of moving data/databases between servers and databases in SQL Server?
HCL,
3 15050Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
HCL,
2 10581
How to execute the cursor queries with "open" statements?
New concepts of sql server 2005 use in your project.
Why people hate cursor?
How to achieve Paging of records in SQL SERVER?
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
What is a virtual table in sql?
Explain how you can configure a running aggregate in SSRS?
What is temporal table?
explain different types of constraints? : Sql server database administration
Why we use functions in sql server?
How to update muliple row in single query?
How to convert numeric expression data types using the cast() function?
How do I view a stored procedure in sql server?
Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?
What are the advantages of having an index on the sql server?