Viewing 15 posts - 26,281 through 26,295 (of 49,552 total)
Use the Update Statistics task, but select the option for 'column statistics only' as index stats will have been updated by the index rebuild
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
May 6, 2011 at 3:47 pm
adamwhelan4 (5/6/2011)
To be honest I am using MySQL, not by choice for this project so I am not sure how much this may help.
This is a 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
May 6, 2011 at 2:51 pm
Please post table definitions, index definitions and execution plan, as per 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
May 6, 2011 at 2:35 pm
JoeS 3024 (5/6/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
May 6, 2011 at 2:33 pm
x64 is a full-blown 64-bit version of SQL, flat memory addressing up to the maximum supported.
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
May 6, 2011 at 2:30 pm
SkyBox (5/5/2011)
What would you recommend for my situation?
Get someone in to advise you on a high-availability setup.
Zero downtime is near-impossible. Close to 0 downtime is expensive, the closer...
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
May 6, 2011 at 1:23 pm
theunique1011 (5/6/2011)
Sorry one one answered.
No one answered? There are nine replies to your post, all giving you guidelines and advice.
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
May 6, 2011 at 1:14 pm
Yet another thread on the same problem. No further replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1102345-391-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
May 6, 2011 at 12:51 pm
Please don't start new threads for existing questions.
No further replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1102345-391-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
May 6, 2011 at 12:50 pm
The max memory setting only controls the max size of the buffer pool, the paged memory allocation.
SQL also used non-paged memory for things like thread stacks, backup buffers, CLR,...
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
May 6, 2011 at 11:23 am
Meet George Jetson (5/6/2011)
I would suggest you take a thorough look at the SQL Server Surface Area Configuration for Features to see if any changes were made.
SQL 2000 doesn't have...
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
May 6, 2011 at 8:34 am
Two steps back...
Why do you have a report showing 20 million rows? No one is ever going to read even 0.1% of 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
May 6, 2011 at 7:58 am
pardeshkumar (5/6/2011)
i created temp tables for looping the databases and for each database there are set 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
May 6, 2011 at 7:55 am
Is the database a single filegroup?
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
May 6, 2011 at 5:13 am
I would suggest make sure SQL is patched to the latest service pack, if the problem still occurs call MS customer support and log a case. They have the tools...
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
May 6, 2011 at 5:02 am
Viewing 15 posts - 26,281 through 26,295 (of 49,552 total)