I just want to find out whether anybody has come across any examples of needing to use index hints to prompt MSSQL to use an index that does exist. The only situation I am aware of is if the table is ridiculously large - 3.5 million rows, for example - but I'm interested in whether there are any other situations in which the query ought to make use of the index but does not.
Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.