What is buffer cash and log cache in sql server?
Do you know what is similarity and difference between truncate and delete in sql?
Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.
Explain fundamentals of Data ware housing & OLAP?
How many types of schemas are there?
How to find Duplicate Records In table?
Find nth lowest salary or get nth lowest salary?
How to determine the service pack currently installed on SQL Server?
Explain syntax for viewing, dropping and disabling triggers?
What is the difference between Normalization and De-normalization?
Explain the types of indexes.
What are the purpose of Normalisation?
How do I find query history in sql server?