Viewing 15 posts - 19,321 through 19,335 (of 49,552 total)
Lynn answered that.
May depend on how good the statistics are. If prior to the import the statistics had been created/updated using a full scan and after the import 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
April 5, 2012 at 9:36 am
You could, just watch the IO impact.
Lots of database snapshots can have a serious impact on data modifications in the source DB. By lots, I don't mean hundreds, 5...
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 5, 2012 at 9:34 am
No, you cannot detach database snapshots.
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 5, 2012 at 9:15 am
dfrome (4/5/2012)
It's not possible for an application to corrupt it is it?
No. Not unless you've tripped over a SQL bug.
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 5, 2012 at 9:15 am
george sibbald (4/5/2012)
where I have added a clustered index to a heap I have achieved a reduction...
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 5, 2012 at 9:13 am
It is odd, and what's more odd is I don't see the error saying what's wrong with the page.
Normally if you have a single corrupt page in an index, you'll...
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 5, 2012 at 9:01 am
Recompilation in SQL 2008 is at a statement level. Compilation is at a batch level.
http://sqlinthewild.co.za/index.php/2011/08/16/compiles-and-recompiles/
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 5, 2012 at 8:50 am
george sibbald (4/5/2012)
GSquared (4/5/2012)
The whole point of a heap vs a clustered index is that fragmentation doesn't matter in a heap. They don't have a defined storage sequence (well,...
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 5, 2012 at 8:36 am
Yes
Yes
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 5, 2012 at 8:35 am
Did you try Google or Books Online? Lots of info available.
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 5, 2012 at 8:34 am
Well the select is doing a clustered index scan, which is not efficient.
Does anything ever use the ReferenceID column to filter or join on?
Is that the only select in 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
April 5, 2012 at 8:31 am
anthony.green (4/5/2012)
Figured it out, enable trace flag 3604 then use dbcc page.boths pages have MetaData: ObjectId = 789577851 which relates to PSX_PUBLICATION_SITE_ITEM in sys.objects
I know the object, what I don'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 5, 2012 at 8:22 am
dfrome (4/5/2012)
It still says repair_allow_data_loss...Actually I think it always says that, maybe they did that to just scare people
No it 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 5, 2012 at 8:20 am
Easiest solution (since this is a reader-writer deadlock) would be snapshot or read committed smapshot isolation.
Can you investigate and see what these two pages belong to (can see the 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
April 5, 2012 at 6:36 am
It's not an intra-query parallelism deadlock. There's more than one process involved and the resources are locks in 2 cases. For it to be an intra-query parallelism deadlock there would...
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 5, 2012 at 6:32 am
Viewing 15 posts - 19,321 through 19,335 (of 49,552 total)