What is indexing explain it with an example?

1000

What is sql collation?

1196

Explain features of analysis services?

989

Explain about service Broker functions?

1025

How do you migrate data from mssql server to azure?

165

What are binary string data types in ms sql server?

1275

State the difference between union and union all?

924

How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?

1089

How does normalization work?

912

Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?

945

How to drop an existing schema in ms sql server?

1089

What is #table in sql server?

1037

A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?

953

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

1320

Please differentiate between a local and a global temporary table?

997