I guess the objective to test the subjective knowledge hence T-SQL should be well formated and easy to understand.

You need to rebuild the indexes where the scan density is lower. Also do not bother if the table is small i.e. pages are less. Refer following link for further...

Interesting question, thank you Steve.

It would be good to have one instance instead of multiple instance as allocation of the resource might be challange. You can think of seperate instance if you would like...

check this out...

http://www.sqlservercentral.com/blogs/sqlrnnr/2010/04/27/blob-index-columns/

HTH

Information is not sufficient to provide any conclusion. You need to have web based front end to input data. What about the backend? How is your database design? How users...

Easy one. Thank you!

Thank you! for question on new feature of SQL 2014.

Easy one.

Thanks!

Agreed with Gail. You are using SQL login and want the info of windows login? There is no logic.

What kind of System File?

Looks like permission issue. Do you have permission to access this database?

Do you have sysadmin privilages on the server?

If yes enable option 'Ad Hoc Distributed Queries' in configuration by executing 'sp_configure' (with enabling advance option on).

NO. There is no relation between server restart and index.

You mean due to SSIS package database size is growing on C:?