What do you know about normalization and de- normalization?
Why union all is faster than union?
How many types of relations are there between dimension and measure group? : sql server analysis services, ssas
What is the osql utility?
Write an sql query to find first weekday of the month?
How to generate create view script on an existing view?
Explain various data region available in ssrs with their use?
Write a program to fetch first 10 records from a file?
can an automatic recovery be initiated by a user? : Sql server administration
List some advantages and disadvantages of stored procedure?
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.
Is there any difference between the primary key and unique key?
What is an etl file?
What is the difference between coalesce() & isnull()?
What is abstracting periodical?