{"id":654,"date":"2006-01-16T02:39:34","date_gmt":"2006-01-16T02:39:34","guid":{"rendered":"\/blogs\/kimberly\/post\/Scalable-Share-Databases-are-supported-by-SQL-Server-2005-RTM.aspx"},"modified":"2006-01-16T02:39:34","modified_gmt":"2006-01-16T02:39:34","slug":"scalable-share-databases-are-supported-by-sql-server-2005-rtm","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/scalable-share-databases-are-supported-by-sql-server-2005-rtm\/","title":{"rendered":"Scalable Share Databases are supported by SQL Server 2005 RTM"},"content":{"rendered":"<p><P>If you&#8217;re interested in scale-out improvements for reporting and read-only scenarios&#8230;check this out: <a href=\"http:\/\/support.microsoft.com\/default.aspx?scid=kb;en-us;910378\" class=\"broken_link\">KB 910378<\/a>. This KB is actually a feature release KB and describes a new feature of SQL Server 2005 which allows multiple servers to simultaneously share the same database files on a SAN. This is NOT possible for read\/write databases, only read-only databases; however, it does allow you to leverage multiple server&#8217;s hardware to perform complex reporting locally &#8211; using that node&#8217;s memory, tempdb, etc.<\/P><br \/>\n<P>If you implement this &#8211; report back (no pun intended) as I&#8217;d love to hear your good\/bad experiences!<\/P><br \/>\n<P>Have fun,<BR>kt<\/P><\/p>\n","protected":false},"excerpt":{"rendered":"<p>If you&#8217;re interested in scale-out improvements for reporting and read-only scenarios&#8230;check this out: KB 910378. This KB is actually a feature release KB and describes a new feature of SQL Server 2005 which allows multiple servers to simultaneously share the same database files on a SAN. This is NOT possible for read\/write databases, only read-only [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[65],"tags":[],"class_list":["post-654","post","type-post","status-publish","format-standard","hentry","category-sql-server-2005"],"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/posts\/654","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/comments?post=654"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/posts\/654\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/media?parent=654"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/categories?post=654"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/tags?post=654"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}