Do you know what is a with(nolock)?
how many triggers you can have on a table? : Sql server database administration
Can we write ddl in trigger?
Where to find ntwdblib.dll version 2000.80.194.0?
What is scd (slowly changing dimension)? : sql server analysis services, ssas
Explain isolation levels that sql server supports?
What are different type of Collation Sensitivity?
How to count rows with the count(*) function in ms sql server?
How to delete all rows with truncate table statement in ms sql server?
Tell me what is use of except clause? How it differs from not in clause?
What is the difference between row_number and dense_rank?
Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?
What are the benefits and tasks of object explorer? : sql server management studio
How to get a list of all tables with "sys.tables" view in ms sql server?
in the physical file layout, where should the transaction log be stored in relation to the data file?