How do I view a script in sql server?
How would you add a section to a table?
Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?
What is the size of transaction log file?
Explain the phases a transaction has to undergo?
Explain different types of locks in sql server.
Why do we use trigger?
How to search for a string in all stored procedure in sql server?
What is difference between line feed ( ) and carriage return ( )?
Define magic tables in sql server?
How do I change my passwords (database, LDAP, and so on) without causing an outage?
In clustered and non clustered indexes which one is faster while executing a query ?
Tell me the difference between clustered and non-clustered index?