Viewing 15 posts - 28,591 through 28,605 (of 49,552 total)
AD7 (1/7/2011)
Thanks Gail. Brilliant article. Can't wait for part 2 and 3.
They're available, see the links at the end of the article. These three were originally published Nov 2009. Steve's...
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 7, 2011 at 2:17 am
Do you have the execution plan on? Normally it would be triggers.
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 7, 2011 at 1:53 am
luckysql.kinda (1/6/2011)
MS SQL Corruption: "Msg 2627 - Violation of PRIMARY KEY constraint"
Um, no. This is not a corrupt database, it's a table that has duplicates that need removing.
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 7, 2011 at 12:57 am
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 7, 2011 at 12:55 am
GSquared (1/6/2011)
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 7, 2011 at 12:45 am
What do you do with the xml in the database?
If you put it in nvarchar, it's just a piece of text. If you put it in XML, you can add...
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 7, 2011 at 12:44 am
Yes. But do some research and reading up first, and also it would help people find your questions if the titles were meaningful.
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 7, 2011 at 12:38 am
brendanc (1/6/2011)
Just a comment, clustered indexes are order physically when the index is created and maintained logically there after.
Physically within the file, yes (mostly), physically on disk still 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 7, 2011 at 12:35 am
Please note this thread is 2 years old.
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 6, 2011 at 9:06 am
ziller (1/6/2011)
No, I was thinking if the columns needed were not part of the index key, they would not be returned in any way sorted.
Wouldn't change a thing. If SQL...
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 6, 2011 at 6:54 am
ziller (1/6/2011)
If the data is not part of the clustered key, right.
You mean if SQL uses another index? Index scan rather than clustered index scan?
I guess I'm thinking...
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 6, 2011 at 6:14 am
ziller (1/6/2011)
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 6, 2011 at 5:45 am
Koen (da-zero) (1/6/2011)
An additional resource that says table scan and index scan are not the same (as opposed of the article of Pinal Dave):http://www.sql-server-performance.com/faq/graphical_query_pla_%20optimizer%20_p1.aspx
There's a fair bit of incorrect information...
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 6, 2011 at 5:44 am
Koen (da-zero) (1/6/2011)
If you have a clustered index, an index scan is the same as a table scan.
If you have a clustered index, then a clustered index scan is equivalent...
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 6, 2011 at 5:37 am
Do note there's damage to the Sites table as well. So this may be more than just some missing documents. Take a backup before you start, test that the 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
January 6, 2011 at 4:21 am
Viewing 15 posts - 28,591 through 28,605 (of 49,552 total)