InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 08:39:52 GMT20http://www.sqlservercentral.com/Forums/Topic1418042-263-1.aspx[quote][b]LoztInSpace (2/10/2013)[/b][hr][quote]Caching is also the type of solution I've found many developers enjoy implementing[/quote]That may be true, but it's also one they also fail to get right 90% of the time. Done incorrectly, it leaves apps with strange intermittent bugs, consistency errors, confusing "wait - didn't I just change that?" moments for the users (especially on a web farm) and performance bottlenecks when restarting a server.It may be fun, but it's hard to do well.[/quote]Very true, and I'd like to see more reference applications and information on how to do this well.Mon, 11 Feb 2013 10:36:31 GMTSteve Jones - SSC Editorhttp://www.sqlservercentral.com/Forums/Topic1418042-263-1.aspx[quote][b]GeorgeCopeland (2/11/2013)[/b][hr]It is important to remember that Windows Server and SQL Server provide good caching behavior right out of the box. When designing caching functionality, take care not to interfere with or duplicate what is already occurring.[/quote]Good point George. if one does not know exactly what they are doing in this area they can easily make things worse. :-DMon, 11 Feb 2013 10:28:27 GMTTravisDBAhttp://www.sqlservercentral.com/Forums/Topic1418042-263-1.aspxIt is important to remember that Windows Server and SQL Server provide good caching behavior right out of the box. When designing caching functionality, take care not to interfere with or duplicate what is already occurring.Mon, 11 Feb 2013 08:17:50 GMTGeorgeCopelandhttp://www.sqlservercentral.com/Forums/Topic1418042-263-1.aspx[quote]Caching is also the type of solution I've found many developers enjoy implementing[/quote]That may be true, but it's also one they also fail to get right 90% of the time. Done incorrectly, it leaves apps with strange intermittent bugs, consistency errors, confusing "wait - didn't I just change that?" moments for the users (especially on a web farm) and performance bottlenecks when restarting a server.It may be fun, but it's hard to do well.Sun, 10 Feb 2013 16:29:36 GMTLoztInSpacehttp://www.sqlservercentral.com/Forums/Topic1418042-263-1.aspxSteve, it sounds like a good time for an in-depth treatment of SQL Server's in-memory capabilities ;^)Sat, 09 Feb 2013 16:55:45 GMTphegedusichhttp://www.sqlservercentral.com/Forums/Topic1418042-263-1.aspxComments posted to this topic are about the item [B]<A HREF="/articles/Editorial/96897/">Rethinking Your Design</A>[/B]Sat, 09 Feb 2013 12:34:18 GMTSteve Jones - SSC Editor