Viewing 15 posts - 10,531 through 10,545 (of 49,552 total)
http://www.sqlservercentral.com/articles/Indexing/68439/
http://www.sqlservercentral.com/articles/Indexing/68563/
http://www.sqlservercentral.com/articles/Indexing/68636/
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
December 29, 2013 at 3:46 am
ramana3327 (12/28/2013)
But is there any limit for the no. of indexs
Yes, same as for any other 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
December 28, 2013 at 11:24 am
Search the articles on this site, there are a couple of good articles on exactly that topic.
Yes, you can have a clustered index on a table variable, yes you can...
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
December 28, 2013 at 9:13 am
Banks1850 (12/28/2013)
GilaMonster (12/27/2013)
And the last_wait_type column?Gail, last wait type for all of them is SOS_SCHEDULER_YIELD
Interesting.....
Definitely need to see an actual plan for that procedure when things are going badly.
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
December 28, 2013 at 9:02 am
Uniqueidentifiers are a rather bad choice for the clustered index (which is by default on the primary key). NewSequentialID is better than NewID, but still not great.
http://www.sqlservercentral.com/articles/Indexing/68563/
Look up the OUTPUT...
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
December 28, 2013 at 2:25 am
sql crazy kid (12/27/2013)
Is there any specific case clustered index not sorted in physical order?
No specific case. It's the norm in fact.
Don't mistake query results order (which results from...
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
December 28, 2013 at 2:12 am
And the last_wait_type column?
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
December 27, 2013 at 2:20 pm
Banks1850 (12/27/2013)
they're not redundant, 1st post is for the versionfileinfo tableand second is for the userfileinfo table
No, you have redundant indexes on each table
CREATE CLUSTERED INDEX [ixc_BackupSetId] ON [dbo].[VersionFileInfo]
(
[BackupSetId] ASC
)
CREATE...
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
December 27, 2013 at 9:37 am
Banks1850 (12/27/2013)
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
December 27, 2013 at 9:20 am
For anyone interested, plan converted and fixed so that it will actually load into SSMS
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
December 27, 2013 at 8:54 am
Still need indexes and both execution plans, fast and slow (actual plans please)
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
December 27, 2013 at 8:30 am
Can you post the queries that are slow (just one or two to start), the slow and fast execution plans (actual plans) along with table and index definitions?
What wait types...
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
December 27, 2013 at 8:25 am
Lowell (12/27/2013)
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
December 27, 2013 at 8:14 am
The leaf level of the clustered index are data pages (and are not necessarily stored in physical order). The non-leaf levels of the clustered index are index pages. Leaf 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
December 27, 2013 at 7:34 am
You find the other half of the backup.
That error means that the backup was striped across two files, either because two files were specified in the BACKUP DATABASE statement or...
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
December 27, 2013 at 5:13 am
Viewing 15 posts - 10,531 through 10,545 (of 49,552 total)