Viewing 15 posts - 331 through 345 (of 430 total)
GilaMonster (7/14/2011)
Please run the following and post the full results
DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS
Please find the dbcc results:
Msg 2576, Level 16, State 1, Line 1
The Index Allocation...
July 14, 2011 at 3:52 am
Roy Ernest (6/28/2011)
You could always try to create the table manually on the subscriber, take a BCP and import the data and then start the replication without snapshot.
thanks for your...
June 28, 2011 at 7:57 am
On some blog, some guy suggested that we can change the compatibility mode to 100, run the snapshot agent and then once the replication starts working fine, we change the...
June 27, 2011 at 4:27 am
I tested something else too. I took a copy of this sql 2000 database and restored it in sql 2008 version. I created the same index as above and now...
June 24, 2011 at 1:15 am
This was the situation when I did not touch anything. Now, to start with, I created an index:
CREATE NONCLUSTERED INDEX [IX_Synthes_OCR_Checked_IndexDef_Loc] ON [dbo].[Synthes_OCR]
(
[IndexDef] ASC,
[Location_Code] ASC,
[Checked] ASC,
[SynthesBatchID] ASC
)
Following are the...
June 24, 2011 at 1:03 am
When i right click on the table and see dependencies, it shows me stored procedures or views depending on it. Is it a correct and reliable way?
June 23, 2011 at 6:48 am
Any suggestions from anyone. I am sure someone must have faced this question atleast once in their career 🙂
June 23, 2011 at 4:39 am
ok.. I think i will ask this 3rd and last time:-)
Without schema and index details, not possible to give best solution. And the numbers that you wrote above are just...
June 23, 2011 at 4:31 am
ananda.murugesan (6/23/2011)
yes, after migration i have done as below1. dbcc checkdb with data purity
2. Rebuild index
3. update statistics both all existing statistices and column level
thanks
If you rebuild all the indexes,...
June 23, 2011 at 1:32 am
You need to include table and index schema details as well as the execution plan for any query. This will help all the experts to analyze and suggest you some...
June 23, 2011 at 1:12 am
The Dixie Flatline (6/20/2011)
Where did you include the index schema?
I am attaching the index schema for both the tables. Please let me know your opinion.
June 21, 2011 at 12:10 am
The Dixie Flatline (6/20/2011)
Where did you include the index schema?
Sorry Sir. I think I forgot to attach the index schema.
I will surely attach it as soon as I reach...
June 20, 2011 at 12:57 pm
Thanks to everyone who spent their valuable time.I think due to the join between so many rows, we cannot get this work faster anymore. The where condition is not too...
June 20, 2011 at 12:59 am
Viewing 15 posts - 331 through 345 (of 430 total)