Thanks Shehap for your response. I can certainly look at those options. You don't think cascade delete and cascade update on ScoreNote table is...
Vivek, Appreciated for your reply. After doing further analysis, the issue may not be on missing indexes (both tables have proper indexes) but the...
Hello Everyone, I have this deadlock graph from one of our systems. The deadlock seem to be happening with dbo.ScoreNote table. I can use all the...
Hello Everyone, This is the deadlock graph I have from one of our systems. I will use all the help I can get. <deadlock-list> <deadlock...
You can have an FK refer to a (set of) column(s) that has a unique constraint, which could be a PK or a unique index - either way. [/quote] Can be...
Also, don't forget about the FOREIGN KEY constraint by having PK in one table.
Can you post your sql query? Without looking at the query, it's hard to see what the issue is.
Hmmm... I never thought about it.[;)]
Also, there is a free versioning software called SubVersion(TortoiseSVN).
<P mce_keep="true"> [/quote]</P><P>[:D] </P><P mce_keep="true"> </P>
Congratulations to all. Hmmm...it's just me or what, I am seeing the drastic decrease in forum participation by most of the members after switching...
You are pulling the OLD forum topic. Good way to increase the post...[;)]
I am assuming that you know what is One-to-Many relationship means. Of course, you have to define this column as PK which itself is unique if you...
There you go!!!
Try yourself. [:)]
Uniqueidentifier is a GUID (Globally Unique IDentifier) which consumes more space than typical identity column (an example of a formatted...
That's a vague question without any specific requirement. I assume that AddressID is a primary key, so it already has clusterred index created unless...
Probably this section might not be the right one for this topic but it's definately the right site regarding the performance difference. Can you give...
"Use DatabaseName" will do that. Also the question of if your .NET connection object will show the original or the new database; if the connection is...
Or, using table variable instead of temp table might be an option?
Separate names with a comma.
