How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?
3 11790What are the different ways of moving data/databases between servers and databases in SQL Server?
1 4589What is database replicaion? What are the different types of replication you can set up in SQL Server?
3 6748There 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 4318How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?
HCL,
3 11391As a part of your job, what are the DBCC commands that you commonly use for database maintenance?
HCL,
1 8554What are statistics, under what circumstances they go out of date, how do you update them?
HCL,
2 9131What are the different ways of moving data/databases between servers and databases in SQL Server?
HCL,
3 15192Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
HCL,
2 10711
How to name query output columns in ms sql server?
How to test odbc dsn connection settings?
How extra digits are handled with numeric data type literals?
Write a program using SQL queries to find a unique entry in a table.
What are sparse columns?
What is the maximum size of column in sql server?
Explain hostprotectionattribute in sql server 2005?
How check triggers in sql server?
What is a primary index?
How to create a ddl trigger using "create trigger" statements?
What are different types of raid configurations? : SQL Server Architecture
What languages bi uses to achieve the goal?
Can I use sql azure as a backup with log shipping or database mirroring?
Why is replication required on the sql server?
What is sharding?