{"id":291,"date":"2007-07-05T10:13:35","date_gmt":"2007-07-05T09:13:35","guid":{"rendered":"http:\/\/soci.hu\/blog\/index.php\/2007\/07\/05\/mennyit-huz-le-az-sql-server-teljesitmenybol-ha-nincs-ott-az-a-huncut-dbo-prefix\/"},"modified":"2007-07-05T10:13:35","modified_gmt":"2007-07-05T09:13:35","slug":"mennyit-huz-le-az-sql-server-teljesitmenybol-ha-nincs-ott-az-a-huncut-dbo-prefix","status":"publish","type":"post","link":"https:\/\/soci.hu\/blog\/index.php\/2007\/07\/05\/mennyit-huz-le-az-sql-server-teljesitmenybol-ha-nincs-ott-az-a-huncut-dbo-prefix\/","title":{"rendered":"Mennyit h\u00faz le az SQL Server teljes\u00edtm\u00e9nyb\u0151l, ha nincs ott az a huncut dbo. prefix?"},"content":{"rendered":"<p>Annak idej\u00e9n olvastam egy ms whitepapert, ami arr\u00f3l sz\u00f3lt, hogy sokfelhaszn\u00e1l\u00f3s rendszerekn\u00e9l probl\u00e9m\u00e1t okozhat az ownerek kihagy\u00e1sa az adatb\u00e1zis ojjektumok el\u00e9r\u00e9s\u00e9n\u00e9l, mert ilyenkor adott szab\u00e1lyok alapj\u00e1n keresg\u00e9lni kell a fully qualified nevek ut\u00e1n, ami a rendszert\u00e1bl\u00e1k haszn\u00e1lat\u00e1val j\u00e1r, \u00edgy lockol\u00e1si (torl\u00f3d\u00e1s) \u00e9s sebess\u00e9g probl\u00e9m\u00e1kat vethet fel.<br \/>\nNo, itt egy konkr\u00e9t <a href=\"http:\/\/sqlblog.com\/blogs\/linchi_shea\/archive\/2007\/07\/05\/performance-impact-of-procedure-calls-without-owner-qualification-sql-server-2000.aspx\">m\u00e9r\u00e9s<\/a>.<\/p>\n<p>A m\u00e9r\u00e9sb\u0151l l\u00e1tszik, hogy a 2005 m\u00e1s sokkal kev\u00e9sb\u00e9 \u00e9rz\u00e9keny a probl\u00e9m\u00e1ra mint a 2000, de 2000-ben m\u00e9g nagyon jelent\u0151s a hat\u00e1s (10-20%!).<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Annak idej\u00e9n olvastam egy ms whitepapert, ami arr\u00f3l sz\u00f3lt, hogy sokfelhaszn\u00e1l\u00f3s rendszerekn\u00e9l probl\u00e9m\u00e1t okozhat az ownerek kihagy\u00e1sa az adatb\u00e1zis ojjektumok el\u00e9r\u00e9s\u00e9n\u00e9l, mert&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4,30,21],"tags":[],"class_list":["post-291","post","type-post","status-publish","format-standard","hentry","category-szakmai-elet","category-sql-server","category-sql-server-2005"],"_links":{"self":[{"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/posts\/291","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/comments?post=291"}],"version-history":[{"count":0,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/posts\/291\/revisions"}],"wp:attachment":[{"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/media?parent=291"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/categories?post=291"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/tags?post=291"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}