What is the difference between writing data to mirrored drives versus raid5 drives
What have included columns when we talk about sql server indexing?
Which virtual table does a trigger use?
How to add a new dsn with the odbc driver for sql server?
Diffrence between DTS vs SSIS
When we are using this query to shrink the log file,what exactly it will execute internally? Do we lose any data when we run this script? which data it will truncate in the log file and where it is saved. Please let me know... USE DatabaseName GO DBCC SHRINKFILE(<TransactionLogName>, 1) BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY DBCC SHRINKFILE(<TransactionLogName>, 1) GO
What is the size of transaction log file?
is there a column to which a default can't be bound? : Sql server database administration
Why I have to use stored procedures?
you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration
How do you delete duplicate rows in sql server?
Define ACID properties in a Database?
Explain active/passive and active/active cluster configurations?