You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?
What is a partitioned view?
Differentiate sql server reporting services vs. Crystal reports?
How to create new databases with "create database" statements?
What will happen if a column containing char type data is changed to the nchar data type?
In which files does sql server actually store data?
what is normalization? : Sql server database administration
What is nolock hint in sql server 2008
How will you monitor replication latency in transactional replication? : sql server replication
after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?
What is the difference between sdf and mdf?
What is difference between after and before?
what are the core components of SSRS?
Explain the use of containers in ssis and also their types?
What is normalization? Explain its different types?