Which sql server table is used to hold the stored procedure script?
What is shared lock?
Is it ok to shrink transaction log?
What do you mean by COLLATION?
can an order by clause be used in a creation of a view?
What are security principals used in sql server 2005?
What are “lock” hints?
Explain the relational database management system (rdbms)?
What is normalization? Describe its different types.
4 Please write a querry to find repeated numbers in the following table. Table Name: Table1 Field1 10 15 20 15 10
How do we know if any query is retrieving a large amount of data or very little data?
Explain what are partitioned views and distributed partitioned views?
What should we do to copy the tables, schema and views from one SQL Server to another?