Viewing 15 posts - 3,241 through 3,255 (of 7,429 total)
Do you have a clustered index on this table?
Also can you post the DDL of the table and the index structures?
And finally why so many indexes?
March 7, 2003 at 2:25 pm
Is there any more to this message? If not then I am thinking possible an network stack issue as 10049 in Win32 error codes is for
March 7, 2003 at 2:23 pm
Bani I would have to say that boils down to the reason for references and size considerations.
For example with size, if I can use two SmallInt columns to represent...
March 7, 2003 at 12:01 pm
Thank you GuardData for the kind words.
And I don't think you muddied the water at all. You gave a valid point and I just countered. Your solution is common amoung...
March 7, 2003 at 11:53 am
For your case try
DBCC PAGE('dbname',122223, 3)
For instance to see what is on page 10 in pubs you do
DBCC PAGE('pubs', 10, 3)
and see what you get.
Not really a lot of...
March 7, 2003 at 11:45 am
Check the SQL Server language in the SQL Server Properties (change here does not effect any of the users) and for the user. hese directly effect the dateformat output.
See related...
March 7, 2003 at 4:53 am
Actually is this FileMaker app or FileMaker Server, if Server then moving to SQL may only cost them more if the solution has been working fine and they are not...
March 7, 2003 at 4:47 am
See additional comments on similar thread http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=10360&FORUM_ID=9&CAT_ID=1&Topic_Title=clustered+constraint+vs+clustered+index&Forum_Title=General
March 7, 2003 at 4:44 am
Hey Tomiz 4000+ doesn't mean I am right, I do make mistakes.
-----------------------------------------
Hey Chris, relaized I had lost you thread along the way. I check around and had come across this...
March 7, 2003 at 4:42 am
Bani the question thow was aimed at junction tables.
These are tables are where multiple values from two different tables are matched.
In my previous post I mention the Juntion Table structure....
March 7, 2003 at 3:43 am
First where did you get this output? I have seen it before and forget.
I believe it is FileID, PageID, RowID (or slot)
To See do the following (sorry this I haven't...
March 6, 2003 at 4:30 pm
Simply put
DBREINDEX rebuilds the indexes by creating a new copy of the objects and moving them into order.
INDEXDEFRAG does just like the Windows defrag utility. It reorders the data.
...
March 6, 2003 at 3:53 pm
Hey GuardData can you be a bit more descriptive on your testing and also give final result comparisons?
And which is A and which is B?
March 6, 2003 at 1:25 pm
You only have to be concerned with making an index Clustered. You can have Unique indexes that are non-clustered.
The reason is a Clustered index sorts the data in the table...
March 6, 2003 at 10:25 am
In SQL 7 BOL I find it under Index as "constraints" and "overview" under that. It will be the 3rd Bullet item.
In SQL 2000 I find it under the same...
March 6, 2003 at 9:02 am
Viewing 15 posts - 3,241 through 3,255 (of 7,429 total)