Viewing 15 posts - 406 through 420 (of 629 total)
GilaMonster (3/16/2014)
I have two clients where I'm writing up a performance report which includes an entire section on their use of NoLock. Going to be an interesting week
PHB "I've decided...
March 16, 2014 at 3:55 pm
Jeff Moden (3/16/2014)
andrew gothard (3/15/2014)
GilaMonster (3/15/2014)
If you check index fragmentation, enable locked pages and enable (but don't configure) resource governor, SQL will magically start...
March 16, 2014 at 3:49 pm
GilaMonster (3/15/2014)
If you check index fragmentation, enable locked pages and enable (but don't configure) resource governor, SQL will magically start to use less memory
http://www.sqlservercentral.com/Forums/FindPost1551457.aspx
and...
March 15, 2014 at 6:47 pm
Jeff Moden (3/14/2014)
TomThomson (3/14/2014)
jcrawf02 (3/13/2014)
March 15, 2014 at 5:48 pm
The Dixie Flatline (3/13/2014)
I think my bitbucket is defective. Could that have been the problem with my (former) database?
Your bitbucket being defective is certainly an issue, in many...
March 14, 2014 at 6:52 pm
Jeff Moden (3/13/2014)
March 13, 2014 at 6:03 pm
The Dixie Flatline (3/13/2014)
I think my bitbucket is defective. Could that have been the problem with my (former) database?
Mint - just mint. I'm proud to have played...
March 13, 2014 at 5:57 pm
Greg Edwards-268690 (3/13/2014)
No problem is too big for us.
I hope someone asks me what is a bitbucket in my next interview.
I am prepared...
March 13, 2014 at 5:55 pm
rodjkidd (3/13/2014)
andrew gothard (3/13/2014)
rodjkidd (3/13/2014)
A B A C A B
Just...
March 13, 2014 at 5:50 pm
The Dixie Flatline (3/13/2014)
😛
Reckon I'd get away with posting that for the next "Homework" question?
March 13, 2014 at 5:47 pm
C: drive goes to the Cloud, which can take longer.
Did the previous DBA leave you some envelopes?
Missed that earlier, + several internets :hehe:
March 13, 2014 at 5:42 pm
rodjkidd (3/13/2014)
A B A C A B
Just repeat until you...
March 13, 2014 at 10:45 am
The Dixie Flatline (3/13/2014)
andrew gothard (3/13/2014)
The Dixie Flatline (3/12/2014)
SQLRNNR (3/12/2014)
The Dixie Flatline (3/12/2014)
Thanks in advance.
P.S. Please don't ask for...
March 13, 2014 at 9:32 am
The Dixie Flatline (3/12/2014)
SQLRNNR (3/12/2014)
The Dixie Flatline (3/12/2014)
Thanks in advance.
P.S. Please don't ask for DDL and sample data as...
March 13, 2014 at 7:03 am
Dird (3/11/2014)
OK thanks for the clarity. I guess I'll just add an extra step to fullscan on that particular table after doing an all-round sp_updatestats.
Are you getting bad query plans...
March 11, 2014 at 4:59 am
Viewing 15 posts - 406 through 420 (of 629 total)