Viewing 15 posts - 34,651 through 34,665 (of 49,552 total)
3) The only indexes that can be created against table variables are primary key and unique constraints (and even then, people don't usually bother)
It's not a problem with 10 rows...
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
January 16, 2010 at 8:45 am
kingscriber (1/16/2010)
Forcing the sproc to be read committed doesn't allow an exclusive lock during the select. Does my assumption seem correct for this fix?
Incorrect. Your selects were taking shared range...
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
January 16, 2010 at 7:41 am
Indianrock (1/16/2010)
Thanks Gail. So you're recommending targeted updating for problematic indexes weekly. And I suppose more often as needed.
Or daily. Or hourly. Whatever you need.
I see 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
January 16, 2010 at 7:36 am
Limiting your fullscan tables where > 20% of the rows has changed is senseless. That's the threshold that the auto update uses. If the row changed reaches that, the auto...
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
January 16, 2010 at 6:47 am
Indianrock (1/16/2010)
I'll have to see if I can find what sp_updateStats does under the hood.
If you're not specifying any parameters to the proc, it does a sampled update to...
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
January 16, 2010 at 6:20 am
kingscriber (1/15/2010)
My guess the default isolation level for the .Net Data Provider for Data Reads is serializable.
I'm not a .net dev, so can't answer that one. Can you investigate...
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
January 16, 2010 at 6:17 am
I'm honestly not sure why this is happening.
Is there any reason you have no clustered index? If there's no good reason, maybe make the pk clustered, see if it...
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
January 16, 2010 at 6:15 am
PrincessPuja (1/16/2010)
1. Style of questions - multi choice/case scenarios/ similar to questions found in self paced training kit CD?
Never used the training kit, but they are multiple choice questions
2. No...
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
January 16, 2010 at 4:46 am
Jeff Moden (1/15/2010)
Not familiar enough with the system but my first blush guess would simply be that the transactions are way too long.
At a first glance, I'd agree with you....
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
January 16, 2010 at 4:42 am
Interesting, a 3-process deadlock. Not the most common type.
Can you post some more information please. I need to see the definition of the stored proc "AddBookingAvailabilitySettingCoverSize" and the definition (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
January 16, 2010 at 3:56 am
I'm trying to have a look at this, but without the definitions of the two procs (which I can no longer access from the PM that you sent, I assume...
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
January 16, 2010 at 3:45 am
Please post 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
January 16, 2010 at 1:44 am
GRE-452109 (1/15/2010)
I''ll send you to Paul Randal's blog post here...
In this case the database is not suspect or recovery_pending, hence there is no need to switch to emergency mode. That...
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
January 16, 2010 at 1:42 am
love sql (1/15/2010)
I was specific about what are the roles and responsibilities of an 'Development SQL Server DBA '.
Depends on the company. There's no fixed spec across all companies for...
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
January 16, 2010 at 1:40 am
CirquedeSQLeil (1/15/2010)
Potentially lost. Data may be lost - it depends on how bad the corruption is.
Will be lost.
If the minimum level to repair is repair_allow_data_loss, it...
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
January 16, 2010 at 1:39 am
Viewing 15 posts - 34,651 through 34,665 (of 49,552 total)