{"id":281,"date":"2018-10-29T08:40:06","date_gmt":"2018-10-29T08:40:06","guid":{"rendered":"http:\/\/www.cdesystems.co.uk\/?page_id=281"},"modified":"2018-10-29T08:40:06","modified_gmt":"2018-10-29T08:40:06","slug":"tsql","status":"publish","type":"page","link":"https:\/\/quirky-lalande.209-97-142-59.plesk.page\/?page_id=281","title":{"rendered":"TSQL &#8211; Transact SQL"},"content":{"rendered":"<p>If you&#8217;ve come here for advice on anything TSQL related you&#8217;ve come to the right place.<\/p>\n<p>If you&#8217;re not sure check out the SQL Server\u00a0<a href=\"\/sqlserver\/services\">Services<\/a>\u00a0and\u00a0<a href=\"\/sqlserver\/support\">Support<\/a>\u00a0pages.<\/p>\n<h2>Tidy<\/h2>\n<ul>\n<li>Is your TSQL code a mess?<\/li>\n<li>Database objects created using the wizards?<\/li>\n<li>CDE can standardise your code to make it clearer and logical.<\/li>\n<\/ul>\n<p>CDE can recommend\u00a0<a href=\"http:\/\/www.dpriver.com\/\" target=\"_blank\" rel=\"noopener\">SQL PR<\/a>\u00a0for the initial beautification of code.<\/p>\n<h2>Analysis and Testing<\/h2>\n<ul>\n<li>Need to get to the bottom of what your database is actually doing.<\/li>\n<li>CDE can analyse, comment your code and report back on all the objects.<\/li>\n<\/ul>\n<h2>Document<\/h2>\n<ul>\n<li>CDE can document all the objects in your database giving a full report.<\/li>\n<\/ul>\n<h2>Code Tuning<\/h2>\n<ul>\n<li>Is bad T-SQL causing slowdowns or errors. Our\u00a0<a href=\"\/sqlserver\/tuning\">Performance Tuning<\/a>\u00a0service can help.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>If you&#8217;ve come here for advice on anything TSQL related you&#8217;ve come to the right place. If you&#8217;re not sure check out the SQL Server\u00a0Services\u00a0and\u00a0Support\u00a0pages. Tidy Is your TSQL code a mess? Database objects created using the wizards? CDE can standardise your code to make it clearer and logical. CDE can recommend\u00a0SQL PR\u00a0for the initial [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":11,"menu_order":21,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-281","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/quirky-lalande.209-97-142-59.plesk.page\/index.php?rest_route=\/wp\/v2\/pages\/281","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/quirky-lalande.209-97-142-59.plesk.page\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/quirky-lalande.209-97-142-59.plesk.page\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/quirky-lalande.209-97-142-59.plesk.page\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/quirky-lalande.209-97-142-59.plesk.page\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=281"}],"version-history":[{"count":0,"href":"https:\/\/quirky-lalande.209-97-142-59.plesk.page\/index.php?rest_route=\/wp\/v2\/pages\/281\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/quirky-lalande.209-97-142-59.plesk.page\/index.php?rest_route=\/wp\/v2\/pages\/11"}],"wp:attachment":[{"href":"https:\/\/quirky-lalande.209-97-142-59.plesk.page\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=281"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}