Viewing 15 posts - 34,246 through 34,260 (of 49,552 total)
emily-1119612 (2/3/2010)
If I do want to truncate the log after the backup, is BACKUP LOG WITH NO_LOG the correct way to do this?
No. The DB is in simple recovery. 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
February 3, 2010 at 10:23 am
EdA ROC (2/3/2010)
Not sure what you mean by "more selective on its own"?
More unique.
There are two queries that I will run, the columns are the same, the order would be...
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
February 3, 2010 at 10:18 am
We're not asking for the client statistics. We're asking for the IO statistics which are completely different.
Run the command
SET STATISTICS IO ON
Then run the query. The IO stats will be...
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
February 3, 2010 at 8:21 am
Sorry. It can not seek on that index because deleted is not a left-based subset of the index key. Yes, it can use that index for a scan operation.
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
February 3, 2010 at 8:20 am
Digs (2/2/2010)
BUT what if WHERE clause is onlyName='Brown'
That could easily use the composite index on Name, deleted
or
Deleted =0
That, however, cannot.
How often is deleted filtered on alone?
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
February 3, 2010 at 7:31 am
Um....
http://www.sqlservercentral.com/Forums/FindPost858555.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
February 3, 2010 at 7:23 am
Welsh Corgi (2/3/2010)
Oracle using the same concept as the later versions of SQL Server.
Maybe, but that doesn't mean that an article on how to rebuild Oracle indexes 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
February 3, 2010 at 7:22 am
Those aren't IO Statistics.
For the IO statistics, run SET STATISTICS IO ON, then run the query.
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
February 3, 2010 at 7:20 am
milzs (2/3/2010)
If we can't we'll have to roll the database back to the last backup prior to when the spill occurred.
That may very well be the only way you can...
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
February 3, 2010 at 6:36 am
Not sure what could be happening here, I've pinged a corruption expert to get some advice.
Just one question first, pick a table that has this problem and run the following...
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
February 3, 2010 at 6:29 am
Welsh Corgi (2/3/2010)
Please rtefer to the following link:
How is an article on rebuilding indexes in Oracle relevant to a SQL Server index problem?
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
February 3, 2010 at 6:15 am
Which is more selective on its own? UserID or Activity?
Other than the cluster (yes, RowID is good as the PK), only two indexes will be needed, not sure yet which...
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
February 3, 2010 at 6:10 am
http://sqlinthewild.co.za/index.php/2007/11/15/execution-plan-operations-scans-and-seeks/
http://sqlinthewild.co.za/index.php/2009/01/09/seek-or-scan/
http://sqlinthewild.co.za/index.php/2009/07/29/is-a-scan-a-bad-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
February 3, 2010 at 5:23 am
You have what looks like errors in the allocation pages. Because of those errors, checkDB can't do a full check of the DB. There is no repair for this.
Either restore...
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
February 3, 2010 at 5:21 am
Marios Philippopoulos (2/3/2010)
What happens to this information if the computer is suddenly rebooted and...
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
February 3, 2010 at 5:15 am
Viewing 15 posts - 34,246 through 34,260 (of 49,552 total)