but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration

525

List the data types available in mssql?

521

Where are stored procedures in sql server?

562

How to include text values in sql statements?

580

Can binary strings be converted into numeric or float data types?

545

How to enable/disable indexes?

588

what is the different types of backups available in sql server? : Sql server database administration

497

Define inner join? Explain with an example?

509

what are constraints? : Sql server database administration

515

Explain system rowset functions?

554

Is it true that rules do not apply to data already existing in a database at the time the rule is created?

557

What is the difference between for auto and for nested?

506

What do you mean by an execution plan? Why is it used? How would you view it?

525

How to get a list of columns using the "sys.columns" view in ms sql server?

556

What is openxml in sql server?

612