What do you mean by the term 'normalization'?

1209

how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration

1064

Explain forward - only cursors?

1069

Where do we use trace frag?

1015

What is the purpose of indexing?

1044

What is importing utility?

984

What is an identity column in insert statements?

1022

How can we rewrite sub-queries into simple select statements or with joins?

981

Explain about temporary stored procedure?

1017

What are the different sql server versions?

980

how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

2344

What is indexed view? How to create it?

1007

What are the different Authentication modes in SQL Server and how can you change authentication mode?

1086

what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration

979

How will you add a dimension to cube? : sql server analysis services, ssas

1086