Viewing 15 posts - 30,106 through 30,120 (of 49,552 total)
Kwisatz78 (10/8/2010)
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
October 8, 2010 at 4:20 am
Jeff Moden (10/8/2010)
Why wouldn't "Federated Servers" in SQL Server do the same thing?
That's when you split a database across multiple servers so that each holds a piece.
RAC has multiple instances...
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
October 8, 2010 at 4:12 am
grahamc (10/8/2010)
how on earth are you South African :hehe:
I'm British (birth and descent). I live in South Africa (and have for quite some time)
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
October 8, 2010 at 4:10 am
The closest SQL has to RAC is scalable shared databases which is ONE set of data files that multiple instances can all read at the same time. However it's read-only...
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
October 8, 2010 at 4:09 am
liewsb (10/8/2010)
-You means only need to run checkpoint for one time?
Yes.
-what you means by "Checkpoints run regularly"?
-Will it have impact to the database?
-How would I know that 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
October 8, 2010 at 4:00 am
No idea. Not enough information
Please check the SQL error log, look for any and all messages relating to that database.
Did anything happen before that error? (bringing DB online, starting up...
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
October 8, 2010 at 3:58 am
That's still of no use. That number is not a SQL error number (which are between 1 and 50000). You haven't said what you're doing exactly? A maint plan? A...
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
October 8, 2010 at 3:57 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/Topic1000994-359-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
October 8, 2010 at 2:22 am
jimmy.liew (10/8/2010)
I was requested by user to shrink the database transaction log files in order to free up more space in the drives.
That's like building a wall made of...
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
October 8, 2010 at 2:21 am
Backup ... with norecovery will take a backup and then take the database into the restoring state. Typically used if taking a log backup prior to starting a restore.
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
October 8, 2010 at 2:20 am
First.Why are you running shrink?
Second. Please check the SQL error log, look for any and all messages relating to that database.
What state is the DB in at the moment? (look...
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
October 8, 2010 at 2:19 am
Why do you want to shrink? Databases tend to grow as more data gets put in them. It's in their nature.
Shrinking causes massive fragmentation and will just result 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
October 8, 2010 at 2:16 am
liewsb (10/8/2010)
By switching it to simple recovery model, a checkpoint can be run. All inactive log records are removed from the transaction log.
Checkpoints run in all recovery models. In simple...
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
October 8, 2010 at 2:13 am
MostInterestingMan (10/7/2010)
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
October 7, 2010 at 2:32 pm
Alvin Ramard (10/7/2010)
I thought the next version of SQL was going to be 2011.
Not necessarily. No release date or name has been announced. The reason people have been...
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
October 7, 2010 at 2:32 pm
Viewing 15 posts - 30,106 through 30,120 (of 49,552 total)