If you were restoring from a full backup at the time you will need to start the restore again from the beginning, its not possible to just restore from a...

Your welcome, thanks for the update.

Windows authentication is just that, the application is verified when connecting to the SQL server under the security context of the windows login that executes the application.

If the application...

Have a read of this, it looks like the same issue and is due to cluster disk drives being offline:

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/fc983fce-265c-488b-a335-d8fe5ea0586c/sql-2008-sp3-install-failing-on-a-cluster-in-a-biztalk-environment-please-help?forum=sqlsetupandupgrade

The number of reads on the table is irrelevant when it comes to understand why the index is fragmenting. The issue is the number of inserts, updates and deletes...

It will simply be down to the rate of change of data within the index. As a percentage of the rows in the table how much is deleted \...

Here is one way to do it, create this procedure in a suitable DB on your server (its basically a stripped out version of sp_spaceused):

IF EXISTS (SELECT TOP 1...

Can you post up the execution plan?

Personally I would have normalised this design further with separate tables for Employer, student, job, Job Applies, plus others. Is that an option rather than have it designed how...

Basically yes, something is locking the account, most likely a mismatch between the actual password in AD and the credential setup.

You won't only be looking for blocking, for any active queries they may still have been executing, looking at the CPU \ Reads \ Duration of any active queries...

This could be so many things, given that your application server started responding quickly after the restart of the SQL Server, when the problem is occuring you need to start...

Are these the only 4 tables you have in the DB?

The design isn't logical to me, your tables do not appear to be normalized.

Not good news I'm afraid, failed with a score of 690 :crying:

What a very very tough exam, questions were not too bad but the exam format is poor. To...

We have routine password changes every few months which we tie in with when we are doing windows OS patching as more often than not we need to restart the...