Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

The best way to store Key Value type of data Expand / Collapse
Author
Message
Posted Friday, November 22, 2013 2:45 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, August 24, 2014 8:56 AM
Points: 257, Visits: 629
What is the best way to store Key Value type of data?
I mean should we go with redundant data or is there anything else better then this.

Thanks.
Post #1516692
Posted Friday, November 22, 2013 5:15 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Today @ 1:14 AM
Points: 43, Visits: 494
Shadab Shah (11/22/2013)
What is the best way to store Key Value type of data?
I mean should we go with redundant data or is there anything else better then this.

Thanks.


I think you should read this great series on indexing by GAIL

http://www.sqlservercentral.com/articles/Indexing/68439/


===========================================
performance issue:
(1) Have you update the statistics on all tables of underling query?
(2) Are you using index well on the tables?
(3) Can you simplify your Query by re-writing it .
(4) are indexes are Defragmented well ?

Post #1516723
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse