Viewing 15 posts - 11,851 through 11,865 (of 49,552 total)
Please don't cross post. It just wastes people's time and fragments replies.
No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1490583-2799-1.aspx
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
September 2, 2013 at 6:01 am
HanShi (9/2/2013)
Look on the internet for exam testing questions.
Problem is, a lot of those are braindumps (actual questions from the actual exams).
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
September 2, 2013 at 3:38 am
Braindumps are cheating. They are the actual questions from the exams posted in violation of the NDA that anyone writing the exams accepts. Using or distributing braindumps can result in...
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
September 2, 2013 at 3:31 am
It's not a unit and you cannot tell just from the missing index DMV that an index should or should not be created. It's just a place to start.
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
September 2, 2013 at 2:49 am
saravanakumar.G (9/1/2013)
You might get this error ...
So much for trying to get someone to figure out their homework for themselves.... He learns nothing by being given the answer.
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
September 2, 2013 at 2:47 am
Here's an idea. Try it yourself. If you get stuck, ask for help. You learn nothing by having someone give you the answer.
Hint: Sum and Group By
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
September 1, 2013 at 4:26 pm
No, that's not an error message (and it's not the one that query will throw)
What error does that query throw?
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
September 1, 2013 at 4:26 pm
What error?
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
September 1, 2013 at 4:16 pm
Homework? What have you tried so far? Where are you stuck?
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
September 1, 2013 at 4:09 pm
Homework?
Have you tested the query? What is wrong with it?
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
September 1, 2013 at 4:09 pm
SQLRNNR (8/31/2013)
Grant Fritchey (8/31/2013)
Cool. That relieves a lot of pressure. I haven't taken a single Microsoft certification. Now, since the only one I respect is gone, I don't have to.
Can...
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
September 1, 2013 at 3:56 am
MyDoggieJessie (8/31/2013)
Ps. Write cache was already disabled (guessing this should always be enabled?) - the replacement battery should be installed in the next few days as well
Once the battery 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
September 1, 2013 at 3:54 am
Combined with a hard shutdown it can cause problems (pages SQL assumes written to disk never got there).
If the RAID array's battery is faulty, you must disable the write cache...
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
August 31, 2013 at 2:49 pm
A single drive failure in a RAID 1, 5 or 10 should not have caused this. Those raid levels have redundancy, so you can lose an entire drive and not...
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
August 31, 2013 at 2:15 pm
Run a full checkDB, if there are any errors I'd recommend dropping the database and reinitialising the subscription.
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
August 31, 2013 at 1:07 pm
Viewing 15 posts - 11,851 through 11,865 (of 49,552 total)