vahid.arr (9/19/2012)
Well Thanks to all this are the things that i have doubt about it.specialy number 4:1- i have table with 40 fields that it have 10 image Type field (varbinary(max)).image SIZE are between 15MB to 100mb
What is the question here. Seems a bit overkill to have 40 varbinary(max) columns in the same table. I suspect normalization would help here but with no more details it is impossible to tell.
2-i have some tables that have many to many relationship i use table between them(junction table).how can i speed up them?i mean wheter or not use index in junction table for speed up?
I assume you must have queries that are running slow? There is no magic go fast button or indexing scheme that will work for everything.
3-what is deferent between unique constraint and uniqe index ?
They are very similar. This should explain it better than I can. http://msdn.microsoft.com/en-us/library/ms187019.aspx
4- i have tables that have relationship together and have one field in both them.is this happen in DB design?
[/quote]
I am not sure I am following your question. It sounds like you have some foreign keys perhaps?
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/