Which command using Query Analyzer will give you the version of SQL server and operating system?
3 15951
What are sub reports?
What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?
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
What are page splits? : SQL Server Architecture
What are the operating modes in which database mirroring runs?
How many types of the database links?
Do you know nested transaction?
explain the storage models of olap? : Sql server database administration
You want to use a perspective in an mdx query. How do you select the perspective?
What is the tcp/ip port on which sql server runs?
List the different types of joins?
Tell me what is de-normalization and what are some of the examples of it?
What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration
What is the difference between a clustered index and a non-clustered index?
When is update_statistics command used?