Viewing 15 posts - 35,221 through 35,235 (of 49,552 total)
crainlee2 (12/17/2009)
1. Does rebuilding indexes also update data distribution statistics?
Rebuilding an index updates the statistics associated with that index. It does not update any other statistics on that table....
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
December 17, 2009 at 2:07 pm
Depends. Is there a process still restoring the DB (or rolling back the restore)?
Easiest way, as I said, is just to restore again. Drop that DB or restore over...
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
December 17, 2009 at 1:11 pm
Nope. A switch of recovery model does not disconnect users.
Is it possible that he took the database offline? Set it to single user or restricted mode?
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
December 17, 2009 at 1:09 pm
One thing first. Run this and see if there's any change in the exec plan or IO stats.
UPDATE STATISTICS Payments WITH FULLSCAN
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
December 17, 2009 at 12:56 pm
The message in the error log was expected. Restoring a database does clear a couple of caches, so anytime you do a restore you will see three similar messages.
Best thing...
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
December 17, 2009 at 12:54 pm
Please post query, view definition, 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
December 17, 2009 at 12:50 pm
Drop a different connection? So from one session terminate another?
KILL is what you're looking for. It's the only thing (other than a shutdown) that can terminate someone else's connection.
Edit: Taking...
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
December 17, 2009 at 12:50 pm
What kind of replication?
What do you mean by 'written to disk'? SQL writes changes to memory initially. They're written to disk in a checkpoint operation on a regular basis.
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
December 17, 2009 at 12:32 pm
The other question to consider is whether you can afford Enterprise Edition. It's not exactly cheap.
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
December 17, 2009 at 12:27 pm
Three words: Beware SQL Injection.
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
December 17, 2009 at 12:24 pm
Jack Corbett (12/17/2009)
Wish I was taking one. Feeling a bit burned out right now.
You and me both. I'm probably working right through the holidays on a combination...
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
December 17, 2009 at 12:13 pm
Both DBCC INDEXDEFRAG and DBCC SHOWCONTIG are deprecated on SQL 2005, should not be used in new development and will be removed in a future version of the product.
The replacements...
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
December 17, 2009 at 12:02 pm
Then consider table partitioning if this kind of delete is a regular operation. If you get the partition function and column appropraitely configured, a massive delete can be done as...
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
December 17, 2009 at 11:18 am
Users can access the DB while it's in bulk-logged recovery. No limitations on that.
You missed a part of the page:
However, if data loss is unacceptable, to prevent data loss,...
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
December 17, 2009 at 11:13 am
See this site for all cert-related info. http://www.microsoft.com/learning/mcp/certifications.mspx
Please don't use polls for normal questions.
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
December 17, 2009 at 10:57 am
Viewing 15 posts - 35,221 through 35,235 (of 49,552 total)