Viewing 15 posts - 8,341 through 8,355 (of 49,571 total)
Eirikur Eiriksson (7/26/2014)
The good thing about SSC is that when I make blunders I am immediately told off:pinch:
:Whistling:
July 26, 2014 at 1:14 pm
Before you apply compression to everything, test and make sure that the CPU overhead is acceptable. On page compression it can get nasty. Also don't compress indexes unless you expect...
July 26, 2014 at 1:14 pm
Eirikur Eiriksson (7/26/2014)
First of all you will not see much of a benefit because of the nature of the encrypted data, there will be some but not huge.
Not so.
True...
July 26, 2014 at 1:11 pm
If you're getting that error, you're either trying to insert a row that already exists or there are duplicates in the set you're inserting. There's no other reasons you'd be...
July 26, 2014 at 2:54 am
swoozie (7/25/2014)
Basically I think that For Every fail, i.e., db that doesn not have a log file that I need to have a Log file created.
But you can't have...
July 25, 2014 at 3:21 pm
quackhandle1975 (7/25/2014)
Edit: I would have thought 459 would have been the most challenging exam being the "Expert" one.
None of them are 'expert' level. Not even close.
July 25, 2014 at 1:49 pm
Is the full backup you used clean? When did you last successfully run CheckDB?
July 25, 2014 at 1:47 pm
Please post new questions in a new thread.
July 25, 2014 at 1:45 pm
robert.diley (7/25/2014)
Then I looked at the query plan for the example in the TechNet article at http://technet.microsoft.com/en-us/library/ms187638(v=sql.105).aspx. What it shows (at least in my...
July 25, 2014 at 1:36 pm
Since he didn't post anything useful (error messages, status), no idea. Maybe he freed up space on the wrong drive, maybe there was a secondary problem....
Point is, a suspect database...
July 25, 2014 at 3:53 am
Draconian (7/24/2014)
SELECT DATABASEPROPERTYEX (N'<dbName>', N'STATUS');
I made enough space on server...
July 25, 2014 at 3:05 am
kimmedim (7/23/2014)
By the way, maybe the 70-461 certification is a long shot for a newbie as myself?
To be blunt, yes. The exam's intended candidates are DBAs/database developers with 2+...
July 24, 2014 at 2:26 pm
Benki Chendu (7/24/2014)
I am trying to take a backup of a database on Inst3 to a disk not mapped to the instance in the cluster.
And that (the bolded part) is...
July 24, 2014 at 11:45 am
whitesql (7/24/2014)
Should I test my backup every time it finishes?
Yes.
Until you've tested it, you don't know whether it's restorable. It should not be a manual process (and so lack of...
July 24, 2014 at 11:05 am
Draconian (7/24/2014)
My Production database is in Recovery pending status. I checked and found due to Hard disk space it went into suspect mode.
Suspect or Recovery_Pending? They're two very different statuses....
July 24, 2014 at 11:00 am
Viewing 15 posts - 8,341 through 8,355 (of 49,571 total)