Viewing 15 posts - 38,416 through 38,430 (of 49,552 total)
Grant Fritchey (6/15/2009)
GilaMonster (6/15/2009)
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
June 15, 2009 at 2:38 pm
GSquared (6/15/2009)
Someone asking for help here. I'm interested in other people's takes on it.
Russian roulette with a 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
June 15, 2009 at 2:28 pm
Ok, as far as I'm aware, Slava's talking about the locked pages feature of pages allocated by AWE. (This one came up on the private newsgroups a while back too)....
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
June 15, 2009 at 10:00 am
AWE has no use on 64 bit. It's used on 32 bit servers to allow access to memory above the directly addressable limit.
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
June 15, 2009 at 9:37 am
Grant Fritchey (6/15/2009)
But, because my DMV one got selected as an alternate, I've still got to come up with the full presentation there. Joy.
I honestly wouldn't bother, unless you want...
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
June 15, 2009 at 9:35 am
No, that's purely got to do with the way management studio's programmed.
In 2005, click on the xml string to bring the xml up in a separate window. Save the xml,...
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
June 15, 2009 at 9:04 am
Please post the query, table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Which column in the table has...
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
June 15, 2009 at 8:42 am
Not sure I understand your question.
The behaviour of the exec plans in management studio is pretty much the same between 2005 and 2008 and, as far as I know, the...
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
June 15, 2009 at 8:41 am
Jas_The_Ace (6/15/2009)
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
June 15, 2009 at 8:26 am
Page verify none means that there's no way for SQL to tell that the page has been damaged by the IO system or by partial writes. It means that any...
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
June 15, 2009 at 8:17 am
Grant Fritchey (6/14/2009)
GilaMonster (6/14/2009)
You submitted 3 in total? Which one's alternate and which one did they say no thanks to?
Actually, I submitted four in total. I had no idea I'd...
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
June 15, 2009 at 8:13 am
Karen Roslund (6/15/2009)
Gail based on your example i would consider that guy as continuous cause there is no gap in between the exp_dt and the new eff_Dt.
Ok, that makes 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
June 15, 2009 at 8:10 am
There's no gap in the one I just posted. That's why I'm asking if that one qualifies or 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
June 15, 2009 at 7:45 am
Alvin Ramard (6/15/2009)
GilaMonster (6/15/2009)
You guys have a football team? 😉
Well, yeah! We've got lots. Wait. You mean that other kind of football. aaaaahhh
😀
Yeah, I meant football...
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
June 15, 2009 at 7:35 am
Ok. What about this, would this one qualify or not?
Insert Into ClientEnrollment (ClientID, eff_dt, exp_dt) Values (4, '2008/01/01', '2009/01/01')
Insert Into ClientEnrollment (ClientID, eff_dt, exp_dt) Values (4, '2009/01/01', '2010/01/01')
or does the...
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
June 15, 2009 at 7:35 am
Viewing 15 posts - 38,416 through 38,430 (of 49,552 total)