Viewing 15 posts - 26,446 through 26,460 (of 49,552 total)
http://www.google.com/search?q=wait+type+SQL+Server
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
April 28, 2011 at 11:43 pm
Steve Jones - SSC Editor (4/28/2011)
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
April 28, 2011 at 12:25 pm
Sounds like a long way around. Can't offer any better option though, since you haven't given details of what you are/were doing.
Do note that new filegroups may not improve performance....
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
April 28, 2011 at 9:38 am
No further replies please. Thread continues http://www.sqlservercentral.com/Forums/Topic1100316-392-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
April 28, 2011 at 9:33 am
[Jim].[dba].[Murphy] (4/28/2011)
Also, make sure you update your statistics on the columns and indexes that participate in the relocation.
Rebuilding the indexes will update the statistics, so no need to do 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
April 28, 2011 at 9:33 am
Do note that Notifications Services was released with SQL 2005 and was removed from SQL 2008. It's not something that you probably should be considering using.
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
April 28, 2011 at 9:30 am
Being in TempDb doesn't mean not being in memory. TempDB is treated like any other database, in memory where possible, written to disk when not.
That said, stuff certainly gets written...
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
April 28, 2011 at 8:14 am
A big index can be fragmented, yes. Rebuilds should reduce fragmentation of bigger indexes, it's very small indexes that it often doesn't.
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
April 28, 2011 at 5:54 am
Gangadhara MS (4/28/2011)
3. Temp Variable instead of Temp table
Likely to degrade performance, not improve it
a) Shrink DB
Almost...
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
April 28, 2011 at 5:21 am
Reason for what?
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
April 28, 2011 at 5:17 am
Execution plan in Excel please, as shown in article.
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
April 28, 2011 at 5:17 am
SQL manages memory at an instance level, not at a database level.
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
April 28, 2011 at 5:16 am
ravisamigo (4/28/2011)
It's a non clustered index.Total_Pages 114.
Too small to worry about. Around 1000 pages is about the point where fragmentation makes noticeable differences
In the below query, if index name...
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
April 28, 2011 at 4:53 am
Please post execution plans, query, table definition, index definitions. See http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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
April 28, 2011 at 4:19 am
How big is the index? How many pages?
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
April 28, 2011 at 4:19 am
Viewing 15 posts - 26,446 through 26,460 (of 49,552 total)