Viewing 15 posts - 151 through 165 (of 486 total)
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...
May 13, 2015 at 6:01 am
Your welcome, thanks for the update.
May 12, 2015 at 7:19 am
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...
May 12, 2015 at 5:02 am
Have a read of this, it looks like the same issue and is due to cluster disk drives being offline:
May 12, 2015 at 4:54 am
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...
May 12, 2015 at 4:00 am
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 \...
May 11, 2015 at 9:51 am
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...
May 5, 2015 at 7:23 am
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...
April 29, 2015 at 9:08 am
Basically yes, something is locking the account, most likely a mismatch between the actual password in AD and the credential setup.
April 29, 2015 at 8:27 am
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...
April 29, 2015 at 4:58 am
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...
April 29, 2015 at 4:21 am
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.
April 29, 2015 at 4:14 am
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...
April 27, 2015 at 7:27 am
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...
April 23, 2015 at 9:16 am
Viewing 15 posts - 151 through 165 (of 486 total)