Viewing 15 posts - 35,761 through 35,775 (of 49,558 total)
The first thing you need to ask is whether the poor performance is normal or abnormal. Is the system always slow or is it usually fast, but has been slow...
November 18, 2009 at 9:02 am
Is there a question here?
Can you give the cursor definition, the full FETCH INTO and the full insert and delete?
November 18, 2009 at 8:04 am
Drop the foreign key first, then drop the index. I suspect you won't be able to recreate the foreign key unless the index is recreated.
Why do you need to...
November 18, 2009 at 7:59 am
Then call Microsoft and ask them. Contact numbers for the various regions are given on the partner site: https://partner.microsoft.com/global/40032423
As I said, the fees differ per region, so only someone at...
November 18, 2009 at 7:55 am
Please post new questions in a new thread and give some detail a to what you're trying to do and exactly what error you're getting.
Thanks.
November 18, 2009 at 7:35 am
jcrawf02 (11/18/2009)
November 18, 2009 at 7:33 am
Please post entire query, table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 18, 2009 at 7:26 am
Did you look here: https://partner.microsoft.com/global/program and more specifically here: https://partner.microsoft.com/global/40013031
Fees apparently vary by country, so contact them and ask (provided your company meets all the other requirements)
November 18, 2009 at 7:23 am
jcrawf02 (11/18/2009)
Adding a clustered index that covers multiple columns within a table is not necessarily advantageous, because it will expand all of the non-clustered indexes as well. (from part II)
Yes
Therefore,...
November 18, 2009 at 7:18 am
DBTeam (11/18/2009)
So it won't create any problem right,even though if we insert million of records into that in the future.
Maybe. You need to test.
Unique constraint will not delay the insertion...
November 18, 2009 at 7:15 am
Please post full query, table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 18, 2009 at 5:37 am
An nvarchar(255) is a rather bad choice for a clustered index. Clustered indexes should be narrow (among other things). 512 bytes is not narrow.
If there an existing primary key on...
November 18, 2009 at 5:36 am
It's a clustered SQL Server. The only drives that will be visible to it are the drives which are set up as cluster resources and dependencies for the SQL service....
November 18, 2009 at 5:31 am
gr8.jain (11/18/2009)
now i attached the execution plan
Where?
November 18, 2009 at 5:25 am
Look in Books Online for the page titled "System Views" (Also available on msdn)
As for counts...
November 18, 2009 at 12:34 am
Viewing 15 posts - 35,761 through 35,775 (of 49,558 total)