What is etl - extraction, transformation, and loading?

913

Difference between Logical Page and Physical Page in SSRS.

474

What is the maximum size of a dimension? : sql server analysis services, ssas

1036

How many types of relations are there between dimension and measure group? : sql server analysis services, ssas

1194

hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.

2923

Explain the relational database management system (rdbms)?

1084

Explain what is the difference between a local and a global temporary table?

989

Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication

976

Explain how you can deploy an SSRS report?

146

How to list all user names in a database?

1047

Why should one not prefix user stored procedures with ‘sp_’?

1036

Explain optimistic and pessimistic concurrency?

986

How to define output parameters in stored procedures?

1019

How to get all stored procedures in sql server?

992

What are the advantages of sql stored procedure?

1061