Viewing 15 posts - 10,531 through 10,545 (of 49,566 total)
ramana3327 (12/28/2013)
But is there any limit for the no. of indexs
Yes, same as for any other table.
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...
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.
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...
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...
December 28, 2013 at 2:12 am
And the last_wait_type column?
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...
December 27, 2013 at 9:37 am
Banks1850 (12/27/2013)
December 27, 2013 at 9:20 am
For anyone interested, plan converted and fixed so that it will actually load into SSMS
December 27, 2013 at 8:54 am
Still need indexes and both execution plans, fast and slow (actual plans please)
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...
December 27, 2013 at 8:25 am
Lowell (12/27/2013)
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...
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...
December 27, 2013 at 5:13 am
Viewing 15 posts - 10,531 through 10,545 (of 49,566 total)