Viewing 15 posts - 8,341 through 8,355 (of 49,552 total)
Eirikur Eiriksson (7/26/2014)
The good thing about SSC is that when I make blunders I am immediately told off:pinch:
:Whistling:
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 25, 2014 at 1:49 pm
Is the full backup you used clean? When did you last successfully run CheckDB?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 25, 2014 at 1:47 pm
Please post new questions in a new thread.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 25, 2014 at 3:53 am
Draconian (7/24/2014)
SELECT DATABASEPROPERTYEX (N'<dbName>', N'STATUS');
I made enough space on server...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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+...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 24, 2014 at 11:00 am
Viewing 15 posts - 8,341 through 8,355 (of 49,552 total)