To see how much memory SQL server is using, instead of relying on the task manager, it would be better to rely on the total server memory and target server...

xtype is what should be used. type is included for backward compatability.

When a deadlock happens, usually there is no need to reboot the server. Since in this case the server became inactive, you might want to check all the logs(application log,...

If you set the fill factor at 70%, you would have to scan more pages each time you have to read because the page denisity would be less. It will...

you could try reindexing the tables, few at a time by opening a cursor. the problem is that there is not enough space on the disk. Few tables can be...

The above response indicated the exact scenario you might be running into. However, to check which one of these conditions you are encountering, you could open a cursor and check...

You cannot tell SQL Server to choose an intelligent statistics other than specifying a percentage to scan. Unfortunately, there have been a few bugs associated with the computation of statistics....