Viewing 15 posts - 36,031 through 36,045 (of 49,552 total)
shanu.hoosen (11/3/2009)
the shrinkfile will not help for this.it will reduce size if the log is full.
shrinkfile will reduce the size if the log is NOT full. If the log 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 4, 2009 at 12:18 am
Execution plan?
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 4, 2009 at 12:16 am
farax_x (11/3/2009)
yes it helps but does not answer my question.
There is no one, single, always right answer to your question. Without knowing the queries that run against that table, there...
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 4, 2009 at 12:15 am
For monitoring space usage yes.
Fill factor is reduced to alleviate page splits and fragmentation.
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 3, 2009 at 5:00 pm
All data modifications take an exclusive lock.
Locks can be at the row, page, extent or table. Never part of a row.
Exclusive locks are held until the end of a transaction....
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 3, 2009 at 4:59 pm
Please don't cross post. it just wastes people's time and fragments replies.
No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic813034-1632-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
November 3, 2009 at 4:55 pm
Please post table, index definitions and execution plans. Take a look through this article: http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Also, take a look at that article, about narrowing down exactly where the performance problems speciofically...
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 3, 2009 at 4:52 pm
Jon.Morisi (11/3/2009)
My end goal is to trend this growth in order to come up with an appropriate fill factor for index rebuilds.
It's not growth that affects the fill factor. It's...
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 3, 2009 at 4:47 pm
omkarred (11/3/2009)
waiting fr post
What are you waiting for?
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 3, 2009 at 4:44 pm
stephenmbell (11/3/2009)
and from what I have read, when using Dynamic SQL, it is inefficient because a cached execution plan can not be used.
Absolutely false. Dynamic SQL has its plans cached...
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 3, 2009 at 4:42 pm
farax_x (11/3/2009)
my question is :its better put all columns together in one index or this situation is the best.
As I said, it depends. It depends purely on the queries...
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 3, 2009 at 4:40 pm
It depends.
http://sqlinthewild.co.za/index.php/2009/01/19/index-columns-selectivity-and-equality-predicates/
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 3, 2009 at 8:28 am
Please don't cross post. It just wastes people's time and fragments replies.
No replies to this thread please. Replies to: http://www.sqlservercentral.com/Forums/Topic812740-266-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
November 3, 2009 at 8:25 am
Please run the following and post the full results:
DBCC CheckDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS
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 3, 2009 at 8:15 am
HowardW (11/3/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 3, 2009 at 8:11 am
Viewing 15 posts - 36,031 through 36,045 (of 49,552 total)