Viewing 15 posts - 32,956 through 32,970 (of 49,552 total)
It happens, as well as cases where the percentages add up to less than 100%. I forget the exact explaiantion that was given but, iirc it has to do with...
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 11, 2010 at 9:14 am
You don't.
There's no way, from the native tools, to undo changes once committed. That's what a backup is for.
You could try a 3rd party log reader tool. They cost a...
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 11, 2010 at 6:39 am
Bhuvnesh (5/11/2010)
GilaMonster (5/11/2010)
Does it use the nc index then join back to the cluster/heap to delete?You mean to say Key Lookup ?
No, I did not. This is a delete...
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 11, 2010 at 5:52 am
kastros.george (5/11/2010)
That was the problematic statement... I cant see how sql can generate 2 execution plans that have such huge differences in Disk reads....
I can see a number of reasons:
Does...
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 11, 2010 at 2:54 am
kastros.george (5/11/2010)
Option keepplan also fixed the problem...
No, that just hid the symptoms. If the plan had been forced out of the cache due to memory pressure, DB maint operation, schema...
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 11, 2010 at 2:22 am
You can't with the native tools. Best you can do with the native tools is a file backup (backup of a single database file). Check the requirements and limitations on...
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 11, 2010 at 1:42 am
Last year I'd say about 2/3 were self-nominations. Some of them were .... um... entertaining.
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 11, 2010 at 1:37 am
Please post query, 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 11, 2010 at 1:36 am
kastros.george (5/11/2010)
Select * from sys.dm_db_index_physical_statswill show you if the index is fragmented Not the Data Pages (with the exception of course of a clustered index), isn't that right ???
Clustered...
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 11, 2010 at 1:30 am
kastros.george (5/10/2010)
Furthermore for a simple view (joining 2-3 tables) the execution plan will 99% of time be the same.....
Over-generalisation. Completely depends on the view.
Anyway the root cause of 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
May 11, 2010 at 1:12 am
Ninja's_RGR'us (5/10/2010)
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 10, 2010 at 1:44 pm
Ninja's_RGR'us (5/10/2010)
Do you have any articles to recommend? Written one yourself perhaps?
No and no. Not an area that I've dived deeply into yet.
What impact can I expect for tempdb...
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 10, 2010 at 10:16 am
The clustered index is the table. If you have a table that's 10GB with a clustered index on it, you have a 10GB structure consisting of the clustered index with...
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 10, 2010 at 10:15 am
Ninja's_RGR'us (5/10/2010)
GilaMonster (5/10/2010)
One of the snapshot isolations?[set beginner lvl on]
What?
[set beginner lvl off]
I've read about transaction isolations but I don't know what you're asking.
Snapshot isolation level or read committed snapshot...
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 10, 2010 at 9:35 am
iqtedar (5/10/2010)
i) is it that clustered indexes can only be created on primary columns?
No. A clustered index can be created on any column other than a Lob data type...
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 10, 2010 at 9:30 am
Viewing 15 posts - 32,956 through 32,970 (of 49,552 total)