Viewing 15 posts - 37,081 through 37,095 (of 49,552 total)
Run repair with allow_data_loss (it won't actually lost any data in this case). Those may be errors left over from before the service pack was applied.
If, after repairing you...
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 13, 2009 at 4:22 am
Paul White (8/13/2009)
Kalen made a similar error: http://sqlblog.com/blogs/kalen_delaney/archive/2006/10/23/328.aspx. Perhaps you were thinking along the same lines.
Reading carefully, she hasn't made an error, but it's easy to draw an incorrect...
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 13, 2009 at 4:15 am
Jeff Moden (8/12/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
August 13, 2009 at 4:07 am
RBarryYoung (8/12/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
August 13, 2009 at 3:49 am
Paul White (8/13/2009)
GilaMonster (8/13/2009)
Normally SQL allocates the first few pages for a table (8 in 2000, 24 in 2005) from mixed extents before switching to uniform (dedicated) extents.
No that 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
August 13, 2009 at 3:47 am
Jeff Moden (8/12/2009)
I have discovered the second lowest form of life on the planet Earth. Check out the following URL... does the article look familiar to anyone?http://balavardhanreddy.over-blog.com/article-29918397-6.html
It's not just yours....
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 13, 2009 at 2:33 am
pwatson (8/13/2009)
I know suer_sname() works in SQL 2005 but does this work in 2000?
Have you tried suser_sname on 2000 to see if it works?
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 13, 2009 at 2:31 am
David Burrows (8/13/2009)
GilaMonster (8/13/2009)
Can anyone help this poor chap create some ' recommmendations'?http://www.sqlservercentral.com/Forums/Topic769924-146-1.aspx
How about recommmending the recommmendation's recommmendation is to recommmend the recommmendation of supplying recommmendations for us to recommmend...
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 13, 2009 at 2:30 am
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 13, 2009 at 2:06 am
Can anyone help this poor chap create some ' recommmendations'?
http://www.sqlservercentral.com/Forums/Topic769924-146-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
August 13, 2009 at 2:05 am
How about you go and buy them instead of asking for free copies of copyrighted material. Look at it as an investment in your career.
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 13, 2009 at 2:05 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic769904-148-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
August 13, 2009 at 2:03 am
Sorry, don't understand what you're asking. There's no database object called 'recommendation'
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 13, 2009 at 2:02 am
Lynn Pettis (8/12/2009)
Gail, here's one for you😉
No thanks. I've already 'helped' him out with backup and restore options.
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 13, 2009 at 1:59 am
Jeff Moden (8/12/2009)
Here's the link to the infringing article...http://www.yourcomputerconsultant.com.au/support/default.asp?W276
I don't think that's Fog Creek (Joel Spolsky) themselves. They sell FogBugz software for customers to host on their own servers.
A whois...
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 13, 2009 at 1:56 am
Viewing 15 posts - 37,081 through 37,095 (of 49,552 total)