Viewing 15 posts - 35,656 through 35,670 (of 49,552 total)
Atul DBA (11/25/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
November 25, 2009 at 8:12 am
Alvin Ramard (11/25/2009)
I'll give the poster of the first item one point for saying: "(only if this is allowed in your business case)"
No points from me for that. That...
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
November 25, 2009 at 8:08 am
roelofsleroux (11/25/2009)
Gila you sound like Doomsday Prophet. This is South Africa.
Jy ook? So baie mense van Suid-Afrika op hierdie forums.
The only natural disaster we know of so far...
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
November 25, 2009 at 8:02 am
btw, I used to work with a DBA team that managed a mission critical stock market trading system. We had a windows cluster, the SAN mirrored to a secondary site...
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
November 25, 2009 at 7:50 am
Ok, I vote this as one of the more ... 'questionable' recommendations I've read here recently.
As your log file is very huge, and it is required to Truncate the log...
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
November 25, 2009 at 7:48 am
roelofsleroux (11/25/2009)
If the database fails for some reason, the mirror kick in. If there 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
November 25, 2009 at 7:42 am
nadersam (11/25/2009)
I prefer to remove those duplicate indexes but i am afraid it causes any performance degradation.
So do some tests (in a dev or test environment), see how queries perform,...
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
November 25, 2009 at 7:33 am
Please post SQL 2000-related questions in the SQL 2000 forums in the future. If you post in the 2005 forums, you're very likely to get 2005-specific solutions.
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
November 25, 2009 at 7:31 am
Jack_Thiru from chennai (11/25/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
November 25, 2009 at 7:30 am
Atul DBA (11/25/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
November 25, 2009 at 7:18 am
roelofsleroux (11/25/2009)
Is it really necessary to make Transaction Log Backups every 30min/hour?
There are two things that affect the frequency of log backups.
1) How big you are willing to let 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
November 25, 2009 at 7:16 am
Personally for a Y/N column, I'd use CHAR(1). Yes, it could be a BIT, but that requires additional logic in every query and unless there are other bit columns in...
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
November 25, 2009 at 7:11 am
Unless you have a really good reason for wanting a duplicate index, or there's a major performance degradation when you remove it, take it out. SQL will use the cheapest...
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
November 25, 2009 at 12:32 am
What do you mean by 'rotated'?
Restart won't do anything to the database transaction logs, they'll be read when the server restarts in order to do restart recovery, but a shutdown...
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
November 25, 2009 at 12:17 am
SQL Server Error log.
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
November 25, 2009 at 12:15 am
Viewing 15 posts - 35,656 through 35,670 (of 49,552 total)