Viewing 15 posts - 36,511 through 36,525 (of 49,552 total)
Luke L (9/9/2009)
So apparently they might be migratory after all?
The ones down here certainly are. That's why I was asking if it was a Monty Python reference or a factual...
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 9, 2009 at 12:24 pm
CirquedeSQLeil (9/9/2009)
So my curiosity is if you live close to Durban or somewhere else.
Durban? Hell, no. I'm in JHB.
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 9, 2009 at 11:45 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/Topic785174-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
September 9, 2009 at 11:10 am
What's the version of SQL 2005 that you're using?
I'm going to consult with an expert on corruption on this.
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 9, 2009 at 9:52 am
Silverfox (9/9/2009)
No it isnt, Gail made some money by the sounds of it.
No I didn't. No one local was willing to bet that the pigeon would lose.
Let's put it this...
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 9, 2009 at 9:42 am
Generally corruption is an IO subsystem problem. If you're having repeated corruption, I'd take a long, hard look at the drives/SAN that the server uses. Have a look in 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
September 9, 2009 at 9:01 am
GSquared (9/8/2009)
jcrawf02 (9/8/2009)
It's a shame they're not doing this with a laden swallow...Yes, but African swallows are non-migratory.
They are? Or is that a Monty Python reference?
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 9, 2009 at 8:49 am
GilaMonster (9/8/2009)
Only in South Africa - http://pigeonrace2009.co.za/pigeon-race-2009My money's on the pigeon.
The pigeon won. By a significant amount. The download was 4% complete by the time the pigeon arrived
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 9, 2009 at 8:44 am
Silverfox (9/8/2009)
GilaMonster (9/8/2009)There is a backdoor. It's not easy to do. Before we go that far though....
You are not talking about the backdoor using single user are you...:-D
Yup.
I've had to...
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 8, 2009 at 6:17 pm
Florian Reischl (9/7/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
September 8, 2009 at 10:13 am
I'm in a silly mood right now, so...
Silverfox (9/8/2009)
how do you clone a report server
Start with a bounty hunter and a water-covered planet.
when do you use a cursor
As seldom as...
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 8, 2009 at 9:58 am
jimmycjen (9/8/2009)
I noticed that when the server is rebooted, it automatically runs DBCC CHECKDB. Is there a place I can disable it?
It's not running CheckDB. All SQL's doing is adding...
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 8, 2009 at 9:57 am
Might be worth putting a trace in place, from the time you know the table is 0% fragmentation to when it's really high. See exactly what's happening to 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 8, 2009 at 8:16 am
TheSQLGuru (9/8/2009)
2) As the plan gets big, the number of permutations (and the CPU effort and duration it takes to calculate them all) grows . . . hmm, 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 8, 2009 at 8:14 am
PiMané (9/8/2009)
Doesn't CREATE DATABASE FOR ATTACH_REBUILD_LOG do the job in SQL Server 2005 or 2008?
Yes, if the database was shut down cleanly. For the cases where is wasn't, the DB...
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 8, 2009 at 7:28 am
Viewing 15 posts - 36,511 through 36,525 (of 49,552 total)