Viewing 15 posts - 25,381 through 25,395 (of 49,552 total)
Post the 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
June 22, 2011 at 11:48 am
Also use char for very small strings. VARCHAR(1) is completely nonsensical.
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
June 22, 2011 at 11:47 am
Replication does not depend in any way on recovery model.
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
June 22, 2011 at 11:46 am
Restore from a clean backup.
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
June 22, 2011 at 11:30 am
Both of them.
Edit: As in, I need to see the .sqlplan file for both the queries (not both picture and .sqlplan)
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
June 22, 2011 at 6:37 am
Ok, I checked with an expert on this.
If this is the only error, then checkDB with repair_allow_data_loss should fix this with no data loss. Take a backup first.
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
June 22, 2011 at 5:52 am
Interesting.
My guess is that it's an optimisation for the TPC benchmarks, not something for normal use.
Edit: Just checked with ex-MS developer. Several downsides, not something that you should consider 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
June 22, 2011 at 5:48 am
p.s. Is this a SQL 2000 upgrade? If so is it a recent upgrade?
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
June 21, 2011 at 2:49 pm
As for the table, that's easy (or should be). Take the objectID (1268915592) and query sys.tables. Otherwise what you could do (which should have the same result) is take 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
June 21, 2011 at 2:45 pm
Not sure about rebuilding, in your case it's the clustered index affected (the actual data in the table). The case in the ref was a nonclustered index (redundant copy 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
June 21, 2011 at 2:28 pm
jcrawf02 (6/21/2011)
GabyYYZ (6/20/2011)
Well, MVP is the highest official accolade from MSNot sure that's true, MCM would rank higher than MVP, I would think. Depends what you're measuring, I suppose.
Steak 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
June 21, 2011 at 1:10 pm
Why is the trigger not using the deleted/inserted tables? As written it's going to affect the entire table if one row is changed.
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
June 21, 2011 at 1:08 pm
sys.dm_exec_requests cross apply to sys.dm_exec_sql_text and use substring on the text with the start and end offset. (script is in BoL)
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
June 21, 2011 at 1:07 pm
Jayanth_Kurup (6/21/2011)
As a first try you could try replacing the subqueries with joins.
http://sqlinthewild.co.za/index.php/2010/01/12/in-vs-inner-join/
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
June 21, 2011 at 12:49 pm
As I said
GilaMonster (6/21/2011)
Because the insert starts a transaction and automatically commits it as soon as its finished.
So you started one (BEGIN TRANSACTION), the insert started one that it autocommitted....
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
June 21, 2011 at 12:47 pm
Viewing 15 posts - 25,381 through 25,395 (of 49,552 total)