What are sub reports?

188

What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?

851

Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many

895

What are page splits? : SQL Server Architecture

940

What are the operating modes in which database mirroring runs?

1036

How many types of the database links?

1027

Do you know nested transaction?

910

explain the storage models of olap? : Sql server database administration

891

You want to use a perspective in an mdx query. How do you select the perspective?

235

What is the tcp/ip port on which sql server runs?

1067

List the different types of joins?

934

Tell me what is de-normalization and what are some of the examples of it?

964

What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration

949

What is the difference between a clustered index and a non-clustered index?

931

When is update_statistics command used?

1002