{"id":3484,"date":"2025-11-21T12:07:41","date_gmt":"2025-11-21T11:07:41","guid":{"rendered":"http:\/\/nas01\/wordpress\/?page_id=3484"},"modified":"2025-11-23T11:00:21","modified_gmt":"2025-11-23T10:00:21","slug":"mssql-tips","status":"publish","type":"page","link":"https:\/\/jsanders.myds.me\/wordpress\/?page_id=3484","title":{"rendered":"MSSQL tips"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-page\" data-elementor-id=\"3484\" class=\"elementor elementor-3484\">\n\t\t\t\t<div class=\"elementor-element elementor-element-8ba5031 e-flex e-con-boxed e-con e-parent\" data-id=\"8ba5031\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-92d8736 elementor-widget elementor-widget-heading\" data-id=\"92d8736\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">MSSQL tips\n<\/h2>\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-25be8f9 e-flex e-con-boxed e-con e-parent\" data-id=\"25be8f9\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-e5d7e97 elementor-widget elementor-widget-text-editor\" data-id=\"e5d7e97\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p><ul id=\"verzamellinks\" style=\"list-style:none; padding:0; margin:0;\"><li style=\"margin-bottom:8px;\">\n            <a href=\"http:\/\/www.mssqltips.com\/tc.asp?n=953&#038;u=7587&#038;l=http:\/\/www.mssqltips.com\/tip.asp?tip=1891\" target=\"_blank\" style=\"color:#800080; text-decoration:underline;\">\n            Best Practice for renaming a SQL Server Database<\/a><\/li><li style=\"margin-bottom:8px;\">\n            <a href=\"http:\/\/www.mssqltips.com\/tc.asp?n=953&#038;u=7587&#038;l=http:\/\/www.mssqltips.com\/tip.asp?tip=1145\" target=\"_blank\" style=\"color:#800080; text-decoration:underline;\">\n            Date\/Time Conversions Using SQL Server<\/a><\/li><li style=\"margin-bottom:8px;\">\n            <a href=\"https:\/\/www.mssqltips.com\/sqlservertip\/1202\/export-data-from-sql-server-to-excel\/\" target=\"_blank\" style=\"color:#800080; text-decoration:underline;\">\n            Export data from SQL Server to Excel<\/a><\/li><li style=\"margin-bottom:8px;\">\n            <a href=\"https:\/\/www.mssqltips.com\/sqlservertip\/1911\/manipulating-multiple-objects-in-sql-server-management-studio\/\" target=\"_blank\" style=\"color:#800080; text-decoration:underline;\">\n            Manipulating Multiple Objects in SQL Server Management Studio<\/a><\/li><li style=\"margin-bottom:8px;\">\n            <a href=\"http:\/\/links_op_categorie\" target=\"_blank\" style=\"color:#800080; text-decoration:underline;\">\n            Microsoft SQL Server vs. MySQL<\/a><\/li><li style=\"margin-bottom:8px;\">\n            <a href=\"https:\/\/www.mssqltips.com\/sqlservertip\/1145\/date-and-time-conversions-using-sql-server\/\" target=\"_blank\" style=\"color:#800080; text-decoration:underline;\">\n            SQL Date Format Examples using CONVERT Function<\/a><\/li><li style=\"margin-bottom:8px;\">\n            <a href=\"https:\/\/www.mssqltips.com\/sqlservertip\/1885\/sql-integration-services-ssis-troubleshooting-best-practices\/\" target=\"_blank\" style=\"color:#800080; text-decoration:underline;\">\n            SQL Integration Services SSIS Troubleshooting Best Practices<\/a><\/li><li style=\"margin-bottom:8px;\">\n            <a href=\"http:\/\/www.mssqltips.com\/tc.asp?n=953&#038;u=7587&#038;l=http:\/\/www.mssqltips.com\/tip.asp?tip=1852\" target=\"_blank\" style=\"color:#800080; text-decoration:underline;\">\n            SQL Server 2005 Index Best Practices<\/a><\/li><li style=\"margin-bottom:8px;\">\n            <a href=\"https:\/\/www.mssqltips.com\/sqlservertip\/1599\/cursor-in-sql-server\/\" target=\"_blank\" style=\"color:#800080; text-decoration:underline;\">\n            SQL Server Cursor Example<\/a><\/li><li style=\"margin-bottom:8px;\">\n            <a href=\"http:\/\/www.mssqltips.com\/tc.asp?n=953&#038;u=7587&#038;l=http:\/\/www.mssqltips.com\/tip.asp?tip=1599\" target=\"_blank\" style=\"color:#800080; text-decoration:underline;\">\n            SQL Server Cursor Examples<\/a><\/li><li style=\"margin-bottom:8px;\">\n            <a href=\"http:\/\/www.mssqltips.com\/tc.asp?n=953&#038;u=7587&#038;l=http:\/\/www.mssqltips.com\/tip.asp?tip=1885%20\" target=\"_blank\" style=\"color:#800080; text-decoration:underline;\">\n            SQL Server Integration Services (SSIS) &#8211; Troubleshooting Best Practices<\/a><\/li><li style=\"margin-bottom:8px;\">\n            <a href=\"http:\/\/www.mssqltips.com\/tc.asp?n=953&#038;u=7587&#038;l=http:\/\/www.mssqltips.com\/tip.asp?tip=1867\" target=\"_blank\" style=\"color:#800080; text-decoration:underline;\">\n            SQL Server Integration Services (SSIS) Performance Best Practices<\/a><\/li><li style=\"margin-bottom:8px;\">\n            <a href=\"http:\/\/www.mssqltips.com\/tc.asp?n=948&#038;u=7587&#038;l=http:\/\/www.mssqltips.com\/tip.asp?tip=1861\" target=\"_blank\" style=\"color:#800080; text-decoration:underline;\">\n            SQL Server Monitoring Scripts with the DMVs<\/a><\/li><li style=\"margin-bottom:8px;\">\n            <a href=\"http:\/\/www.mssqltips.com\/tc.asp?n=953&#038;u=7587&#038;l=http:\/\/www.mssqltips.com\/tip.asp?tip=1881\" target=\"_blank\" style=\"color:#800080; text-decoration:underline;\">\n            SQL Server Security Audit Report<\/a><\/li><li style=\"margin-bottom:8px;\">\n            <a href=\"https:\/\/www.mssqltips.com\/sqlservertip\/1893\/sql-server-integration-services-ssis-design-best-practices\/\" target=\"_blank\" style=\"color:#800080; text-decoration:underline;\">\n            SSIS Design Best Practices<\/a><\/li><li style=\"margin-bottom:8px;\">\n            <a href=\"https:\/\/www.mssqltips.com\/sqlservertip\/1867\/sql-server-integration-services-ssis-performance-best-practices\/\" target=\"_blank\" style=\"color:#800080; text-decoration:underline;\">\n            SSIS Performance Best Practices<\/a><\/li><li style=\"margin-bottom:8px;\">\n            <a href=\"https:\/\/www.mssqltips.com\/sqlservertip\/1891\/steps-to-rename-a-sql-server-database\/\" target=\"_blank\" style=\"color:#800080; text-decoration:underline;\">\n            Steps to Rename a SQL Server Database<\/a><\/li><li style=\"margin-bottom:8px;\">\n            <a href=\"https:\/\/www.mssqltips.com\/sqlservertip\/1910\/transfer-sql-server-database-schema-objects-and-data-with-smo\/\" target=\"_blank\" style=\"color:#800080; text-decoration:underline;\">\n            Transfer SQL Server database schema objects and data with SMO<\/a><\/li><li style=\"margin-bottom:8px;\">\n            <a href=\"http:\/\/www.mssqltips.com\/tc.asp?n=953&#038;u=7587&#038;l=http:\/\/www.mssqltips.com\/tip.asp?tip=1887%20\" target=\"_blank\" style=\"color:#800080; text-decoration:underline;\">\n            Understanding SQL Server fixed server roles<\/a><\/li><li style=\"margin-bottom:8px;\">\n            <a href=\"http:\/\/www.mssqltips.com\/tc.asp?n=953&#038;u=7587&#038;l=http:\/\/www.mssqltips.com\/tip.asp?tip=1882\" target=\"_blank\" style=\"color:#800080; text-decoration:underline;\">\n            Understanding why there is still downtime with Microsoft Clustering<\/a><\/li><li style=\"margin-bottom:8px;\">\n            <a href=\"http:\/\/www.mssqltips.com\/tc.asp?n=953&#038;u=7587&#038;l=http:\/\/www.mssqltips.com\/tip.asp?tip=1888\" target=\"_blank\" style=\"color:#800080; text-decoration:underline;\">\n            When to use SET vs SELECT when assigning values to variables<\/a><\/li><\/ul><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-986276c e-flex e-con-boxed e-con e-parent\" data-id=\"986276c\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-f10ea19 hfe-post-info-layout-inline elementor-widget elementor-widget-post-info-widget\" data-id=\"f10ea19\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"post-info-widget.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<ul class=\"hfe-post-info-inline hfe-post-info-items hfe-post-info\">\n\t\t\t\t\t<li class=\"hfe-post-info-item elementor-repeater-item-ac33501 hfe-post-info-inline-item\" itemprop=\"datePublished\"> \n\t\t\t\n\t\t\t\t\t\t<span class=\"hfe-post-info-icon\">\n\t\t\t\t\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-far-calendar-alt\" viewBox=\"0 0 448 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M148 288h-40c-6.6 0-12-5.4-12-12v-40c0-6.6 5.4-12 12-12h40c6.6 0 12 5.4 12 12v40c0 6.6-5.4 12-12 12zm108-12v-40c0-6.6-5.4-12-12-12h-40c-6.6 0-12 5.4-12 12v40c0 6.6 5.4 12 12 12h40c6.6 0 12-5.4 12-12zm96 0v-40c0-6.6-5.4-12-12-12h-40c-6.6 0-12 5.4-12 12v40c0 6.6 5.4 12 12 12h40c6.6 0 12-5.4 12-12zm-96 96v-40c0-6.6-5.4-12-12-12h-40c-6.6 0-12 5.4-12 12v40c0 6.6 5.4 12 12 12h40c6.6 0 12-5.4 12-12zm-96 0v-40c0-6.6-5.4-12-12-12h-40c-6.6 0-12 5.4-12 12v40c0 6.6 5.4 12 12 12h40c6.6 0 12-5.4 12-12zm192 0v-40c0-6.6-5.4-12-12-12h-40c-6.6 0-12 5.4-12 12v40c0 6.6 5.4 12 12 12h40c6.6 0 12-5.4 12-12zm96-260v352c0 26.5-21.5 48-48 48H48c-26.5 0-48-21.5-48-48V112c0-26.5 21.5-48 48-48h48V12c0-6.6 5.4-12 12-12h40c6.6 0 12 5.4 12 12v52h128V12c0-6.6 5.4-12 12-12h40c6.6 0 12 5.4 12 12v52h48c26.5 0 48 21.5 48 48zm-48 346V160H48v298c0 3.3 2.7 6 6 6h340c3.3 0 6-2.7 6-6z\"><\/path><\/svg>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t<span class=\"hfe-post-info-text hfe-post-info__item hfe-post-info__item--type-date\">\n\t\t\t\n\t\t\t\t\t\t\tvr 21 november 2025\t\t\t\t\t<\/span>\n\t\t\n\t\t\t\t\t<\/li>\n\t\t\t\t<\/ul>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>MSSQL tips vr 21 november 2025<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"ocean_post_layout":"","ocean_both_sidebars_style":"","ocean_both_sidebars_content_width":0,"ocean_both_sidebars_sidebars_width":0,"ocean_sidebar":"","ocean_second_sidebar":"","ocean_disable_margins":"enable","ocean_add_body_class":"","ocean_shortcode_before_top_bar":"","ocean_shortcode_after_top_bar":"","ocean_shortcode_before_header":"","ocean_shortcode_after_header":"","ocean_has_shortcode":"","ocean_shortcode_after_title":"","ocean_shortcode_before_footer_widgets":"","ocean_shortcode_after_footer_widgets":"","ocean_shortcode_before_footer_bottom":"","ocean_shortcode_after_footer_bottom":"","ocean_display_top_bar":"off","ocean_display_header":"off","ocean_header_style":"","ocean_center_header_left_menu":"","ocean_custom_header_template":"","ocean_custom_logo":0,"ocean_custom_retina_logo":0,"ocean_custom_logo_max_width":0,"ocean_custom_logo_tablet_max_width":0,"ocean_custom_logo_mobile_max_width":0,"ocean_custom_logo_max_height":0,"ocean_custom_logo_tablet_max_height":0,"ocean_custom_logo_mobile_max_height":0,"ocean_header_custom_menu":"","ocean_menu_typo_font_family":"","ocean_menu_typo_font_subset":"","ocean_menu_typo_font_size":0,"ocean_menu_typo_font_size_tablet":0,"ocean_menu_typo_font_size_mobile":0,"ocean_menu_typo_font_size_unit":"px","ocean_menu_typo_font_weight":"","ocean_menu_typo_font_weight_tablet":"","ocean_menu_typo_font_weight_mobile":"","ocean_menu_typo_transform":"","ocean_menu_typo_transform_tablet":"","ocean_menu_typo_transform_mobile":"","ocean_menu_typo_line_height":0,"ocean_menu_typo_line_height_tablet":0,"ocean_menu_typo_line_height_mobile":0,"ocean_menu_typo_line_height_unit":"","ocean_menu_typo_spacing":0,"ocean_menu_typo_spacing_tablet":0,"ocean_menu_typo_spacing_mobile":0,"ocean_menu_typo_spacing_unit":"","ocean_menu_link_color":"","ocean_menu_link_color_hover":"","ocean_menu_link_color_active":"","ocean_menu_link_background":"","ocean_menu_link_hover_background":"","ocean_menu_link_active_background":"","ocean_menu_social_links_bg":"","ocean_menu_social_hover_links_bg":"","ocean_menu_social_links_color":"","ocean_menu_social_hover_links_color":"","ocean_disable_title":"default","ocean_disable_heading":"default","ocean_post_title":"","ocean_post_subheading":"","ocean_post_title_style":"","ocean_post_title_background_color":"","ocean_post_title_background":0,"ocean_post_title_bg_image_position":"","ocean_post_title_bg_image_attachment":"","ocean_post_title_bg_image_repeat":"","ocean_post_title_bg_image_size":"","ocean_post_title_height":0,"ocean_post_title_bg_overlay":0.5,"ocean_post_title_bg_overlay_color":"","ocean_disable_breadcrumbs":"default","ocean_breadcrumbs_color":"","ocean_breadcrumbs_separator_color":"","ocean_breadcrumbs_links_color":"","ocean_breadcrumbs_links_hover_color":"","ocean_display_footer_widgets":"default","ocean_display_footer_bottom":"default","ocean_custom_footer_template":"","footnotes":""},"categories":[407],"tags":[],"class_list":["post-3484","page","type-page","status-publish","hentry","category-programeer","entry"],"_links":{"self":[{"href":"https:\/\/jsanders.myds.me\/wordpress\/index.php?rest_route=\/wp\/v2\/pages\/3484","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jsanders.myds.me\/wordpress\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/jsanders.myds.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/jsanders.myds.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/jsanders.myds.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3484"}],"version-history":[{"count":0,"href":"https:\/\/jsanders.myds.me\/wordpress\/index.php?rest_route=\/wp\/v2\/pages\/3484\/revisions"}],"wp:attachment":[{"href":"https:\/\/jsanders.myds.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3484"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jsanders.myds.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3484"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jsanders.myds.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3484"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}