Viewing 15 posts - 16 through 30 (of 100 total)
coronaride (10/2/2012)
October 3, 2012 at 7:26 am
GilaMonster (9/28/2012)
Depends on the type of inserts (end of index or anywhere), depends on whether updates will grow the row or not. Depends...
September 28, 2012 at 8:59 am
Lexa (9/27/2012)
Evil Kraig F (9/25/2012)
Lexa (9/25/2012)
2. Does REORGANIZE on a table causes any locks?
Can't answer #1, not sure.
Reorganize will take a SCH-S lock to keep the metadata straight. It...
September 28, 2012 at 7:34 am
Evil Kraig F (9/25/2012)
Lexa (9/25/2012)
2. Does REORGANIZE on a table causes any locks?
Can't answer #1, not sure.
Reorganize will take a SCH-S lock to keep the metadata straight. It will...
September 27, 2012 at 3:55 pm
opc.three (8/15/2012)
Grant Fritchey (8/15/2012)
You're experiencing I/O waits during I/O operations... The only way to speed that up is to get faster/more disks.
Are you sure you're not thinking of PAGEIOLATCH_UP? I...
August 15, 2012 at 9:53 am
Grant Fritchey (8/15/2012)
You're experiencing I/O waits during I/O operations... The only way to speed that up is to get faster/more disks.
That's what I thought. Thanks.
August 15, 2012 at 7:28 am
Passed the exam, saw a similar question but still not sure if I answered it correct or not since I didn't get 1000.
June 28, 2012 at 9:10 am
sqlsurfing (6/15/2012)
when i'm on the server, in report manager i'm able to bring up http://servername/ReportServer but not
June 16, 2012 at 7:16 am
derek.colley (6/15/2012)
June 15, 2012 at 1:23 pm
when i'm on the server, in report manager i'm able to bring up http://servername/ReportServer but not http://servername/Reports.
June 13, 2012 at 2:35 pm
SQLKnowItAll (6/13/2012)
June 13, 2012 at 2:31 pm
B or D were the two answers I was torn between before posting the question. But which one is it?
June 8, 2012 at 6:41 am
Jayanth_Kurup (5/24/2012)
Ur most likely facing a memory issue , check your working set as well as the target memory settings.
If you are confident u have...
May 24, 2012 at 4:48 pm
HowardW (5/24/2012)
The resource governor error could be a symptom rather than a cause. Have you seen this article in your Googling?
Very good article, I have not seen it,...
May 24, 2012 at 4:34 pm
Suresh B. (5/23/2012)
Lexa (5/23/2012)
Followed by a bunch of these:
"Error: 10982, Severity: 16, State: 1.
Failed to run resource governor classifier user-defined function. See previous errors in SQL Server error log from...
May 24, 2012 at 4:13 pm
Viewing 15 posts - 16 through 30 (of 100 total)