1<!doctype html> 2<html class="no-js" lang="en"> 3 4<head> 5 <meta charset="utf-8" /> 6 <title>Tibor Karaszi SQL Server</title> 7 <meta name="keywords" content="SQL Server, SQL" /> 8 <meta name="description" content="Tibor Karaszis SQL Server pages" /> 9 <meta http-equiv="content-language" content="en" /> 10 11 <link rel="icon" href="https://cdn-content.surftown.com/content/uploads/favicon.png" type="image/x-icon" /> 12 <link rel="SHORTCUT ICON" href="https://cdn-content.surftown.com/content/uploads/favicon.png?v=1790248129" type="image/x-icon" /> 13 <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"> 14 <meta name="viewport" content="width=device-width,initial-scale=1"> 15 16 17 <meta property="og:url" content="https://karaszi.com/articlesandutilities"> 18 <meta property="og:title" content="Articles and utilities"> 19 <meta property="og:description" content="Tibor Karaszis SQL Server pages"> 20 <meta property="og:site_name" content=""> 21<meta name="viewport" content="width=device-width, initial-scale=1, viewport-fit=cover"> 22 23<meta name="generator" content="BaseKit"> 24 25 26 <link rel="canonical" href="https://karaszi.com/articlesandutilities"> 27 28 <link rel="stylesheet" href="//files.builder.nu/c5/0b/c50b9b14-0713-4cd2-bac0-1ed745bd030a.css" class="js-initial-stylesheet"> 29 30<link rel="preload" href="https://55b558c7-resources.builder.nu/ea42165d20/compiled/photo-swipe.css" as="style" onload="this.onload=null;this.rel='stylesheet'"> 31 32 33 34 35 36
36<script nonce=""> 37 function isScriptAllowedByCookieConsent() { 38 var hasOptedIn = window.localStorage && window.localStorage.getItem('bk-cookie-warning') === '1'; 39 var isCookieWarningEnabled = false ; 40 41 return hasOptedIn || !isCookieWarningEnabled; 42 } 43 44 if (!isScriptAllowedByCookieConsent()) { 45 window['ga-disable-' + 'UA-110028036-1'] = true; 46 } 47 48 var _gaq = _gaq || []; 49 _gaq.push(['_setAccount', "UA-110028036-1"]); 50 _gaq.push(['_gat._anonymizeIp']); 51 _gaq.push(['_trackPageview']); 52 53 (function() { 54 var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true; 55 ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js'; 56 var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s); 57 })(); 58 </script>
58 59 60 61<style> 62 @font-face { 63 font-display: block; 64 font-family: 'FontAwesome'; 65 src: url('https://55b558c7-resources.builder.nu/ea42165d20/app-fonts/FontAwesome.woff2') format('woff2'), 66 url('https://55b558c7-resources.builder.nu/ea42165d20/app-fonts/FontAwesome.woff') format('woff'), 67 url('https://55b558c7-resources.builder.nu/ea42165d20/app-fonts/FontAwesome.ttf') format('truetype'), 68 url('https://55b558c7-resources.builder.nu/ea42165d20/app-fonts/FontAwesome.svg') format('svg') 69 } 70</style> 71 72 <style 73 class="js-webfont" 74 data-woff-cache="https://55b558c7-resources.builder.nu/ea42165d20/seven/fonts/arimo.woff.json" 75 data-ttf-cache="https://55b558c7-resources.builder.nu/ea42165d20/seven/fonts/arimo.ttf.json" 76 data-fallback-stylesheet="https://fonts.googleapis.com/css?family=Arimo&subset=latin" 77 data-name="arimo" 78 ></style> 79 <style 80 class="js-webfont" 81 data-woff-cache="https://55b558c7-resources.builder.nu/ea42165d20/seven/fonts/open_sans.woff.json" 82 data-ttf-cache="https://55b558c7-resources.builder.nu/ea42165d20/seven/fonts/open_sans.ttf.json" 83 data-fallback-stylesheet="https://fonts.googleapis.com/css?family=Open+Sans&subset=latin" 84 data-name="open_sans" 85 ></style> 86 <style 87 class="js-webfont" 88 data-woff-cache="https://55b558c7-resources.builder.nu/ea42165d20/seven/fonts/montserrat.woff.json" 89 data-ttf-cache="https://55b558c7-resources.builder.nu/ea42165d20/seven/fonts/montserrat.ttf.json" 90 data-fallback-stylesheet="https://fonts.googleapis.com/css?family=Montserrat&subset=latin" 91 data-name="montserrat" 92 ></style> 93 <style 94 class="js-webfont" 95 data-woff-cache="https://55b558c7-resources.builder.nu/ea42165d20/seven/fonts/playfair_display.woff.json" 96 data-ttf-cache="https://55b558c7-resources.builder.nu/ea42165d20/seven/fonts/playfair_display.ttf.json" 97 data-fallback-stylesheet="https://fonts.googleapis.com/css?family=Playfair+Display&subset=latin" 98 data-name="playfair_display" 99 ></style> 100
100<script nonce=""> 101(function () { 102 var fontCollections, 103 fontsToCache, 104 fallback = 1; 105 106 function loadFontsAsynchronously() { 107 if (!fallback) { 108 return; 109 } 110 111 for (var i = 0, j = fontCollections.length; i < j; ++i) { 112 var link = document.createElement('link'), 113 head = document.getElementsByTagName('head')[0]; 114 link.rel = 'stylesheet'; 115 link.href = fontCollections[i].getAttribute('data-fallback-stylesheet'); 116 head.appendChild(link); 117 } 118 } 119 120 function loadFontsFromStorage() { 121 var localKey = 'published', 122 format, 123 collection, 124 cachedFont; 125 126 if (!window.localStorage) { 127 return; 128 } 129 130 format = window.localStorage.getItem('bk.webfonts.format') 131 if (!format) { 132 return; 133 } 134 135 for (var i = 0, j = fontCollections.length; i < j; ++i) { 136 collection = fontCollections[i]; 137 cacheKey = 'bk.webfonts.' + localKey + '.' + format + '.' + collection.getAttribute('data-name'); 138 cachedFont = window.localStorage.getItem(cacheKey); 139 if (!cachedFont) { 140 continue; 141 } 142 collection.innerHTML = cachedFont; 143 collection.setAttribute('data-cache-full', 'data-cache-full'); 144 } 145 } 146 147 if (!'querySelectorAll' in window) { 148 return; 149 } 150 151 fontCollections = document.head.querySelectorAll('.js-webfont'); 152 if (!'localStorage' in window || !'addEventListener' in window) { 153 loadFontsAsynchronously(); 154 return; 155 } 156 157 loadFontsFromStorage(); 158}()); 159</script>
159 160 161 162 163 164
164<script nonce=""> 165 const touchClass = 'ontouchstart' in window ? 'touch' : 'no-touch'; 166 document.documentElement.classList.add(touchClass); 167 </script>
167 168
169<script nonce="">document.documentElement.classList.remove('no-js');</script>
169 170</head> 171<body class=""> 172 173 174<!-- Header --> 175<header class="template-header"> 176 <div class="header-wrapper"> 177 <div class="header-companyname"> 178 179 <div id="page-zones__template-widgets__companyname-companyname" class="widget widget--template-widget" data-widget-type="companyname" data-uniqueid="page-zones__template-widgets__companyname-companyname"> 180 181 182<div class="bk-companyname companyname widget__companyname" itemscope itemtype="https://schema.org/Organization"> 183 184 <a href="/" class="company-link companyname__company-link" itemprop="url"> 185 <span class="company-text companyname__company-text" itemprop="name"> 186 Tibor Karaszi's SQL Server pages 187 </span> 188 </a> 189 190</div> 191 192</div> 193 194 </div> 195 </div> 196 </div> 197</header> 198 199<div class="bk-pt-default"> 200 201 <div class="profile-header"> 202 <div id="page-zones__template-widgets__extendednavigation-extendednavigation" class="widget widget--template-widget" data-widget-type="extendednavigation" data-uniqueid="page-zones__template-widgets__extendednavigation-extendednavigation"> 203 204 205 206<div class="bk-extendednavigation extendednavigation widget__extendednavigation align-right " itemscope itemtype="https://www.schema.org/SiteNavigationElement"> 207 208 <button class="js-pull navigation-toggle icon icon--bars extendednavigation__navigation-toggle"> 209 <span>Meny</span> 210 </button> 211 212<nav class="navigation-body extendednavigation__navigation-body" role="navigation"> 213 214 <ul class="navigation-list extendednavigation__navigation-list js-menu-list itemcount-8"> 215 216 217 218 <li class="navigation-item extendednavigation__navigation-item home" itemprop="name"> 219 220 221 <a href="/" class="item-name extendednavigation__item-name" itemprop="url">Home</a> 222 223 224 225 </li> 226 227 228 229 <li class="navigation-item extendednavigation__navigation-item page selected" itemprop="name"> 230 231 232 <a href="/articlesandutilities" class="item-name extendednavigation__item-name" itemprop="url">Articles and utilities</a> 233 234 235 236 </li> 237 238 239 240 <li class="navigation-item extendednavigation__navigation-item page" itemprop="name"> 241 242 243 <a href="/training" class="item-name extendednavigation__item-name" itemprop="url">Training</a> 244 245 246 247 </li> 248 249 250 251 <li class="navigation-item extendednavigation__navigation-item page" itemprop="name"> 252 253 254 <a href="/httpsqlblogcomblogstiborkaraszi" class="item-name extendednavigation__item-name" itemprop="url">Blog</a> 255 256 257 258 </li> 259 260 261 262 <li class="navigation-item extendednavigation__navigation-item page" itemprop="name"> 263 264 265 <a href="/links" class="item-name extendednavigation__item-name" itemprop="url">Links</a> 266 267 268 269 </li> 270 271 272 273 <li class="navigation-item extendednavigation__navigation-item page" itemprop="name"> 274 275 276 <a href="/forums" class="item-name extendednavigation__item-name" itemprop="url">Forums</a> 277 278 279 280 </li> 281 282 283 284 <li class="navigation-item extendednavigation__navigation-item page" itemprop="name"> 285 286 287 <a href="/about-me" class="item-name extendednavigation__item-name" itemprop="url">About me</a> 288 289 290 291 </li> 292 293 294 295 <li class="navigation-item extendednavigation__navigation-item page" itemprop="name"> 296 297 298 <a href="/contact" class="item-name extendednavigation__item-name" itemprop="url">Contact</a> 299 300 301 302 </li> 303 </ul> 304 305</nav> 306 307</div> 308 309</div> 310 311 </div> 312 313 <div class="template-title-wrap"> 314 <div class="template-title"> 315 <div id="page-zones__template-widgets__pagetitle-title" class="widget widget--template-widget" data-widget-type="pagetitle" data-uniqueid="page-zones__template-widgets__pagetitle-title"> 316 317 <div class="bk-pagetitle pagetitle widget__pagetitle" itemscope itemtype="https://schema.org/WebPage"> 318 <h1 class="pagetitle-text pagetitle__pagetitle-text" itemprop="name">Articles and utilities</h1> 319</div> 320 321</div> 322 323 </div> 324 </div> 325 326 <!-- Page Content --> 327 <section class="template-content container"> 328 329 <!-- Main Widet Zone --> 330 <section 331 id="page-zones__main" 332 class="bk-zone column " 333 data-uniqueid="CzN2Kcu0CmOfuWp" 334 data-parentuniqueid="" 335> 336<div 337 id="page-zones__main-widgets__59f70c1d25f5b" 338 data-name="content" 339 class="widget widget--zone-widget js-widget" 340 data-uniqueid="MgD54mkKKuuSBh0" 341 data-parentuniqueid="CzN2Kcu0CmOfuWp" 342 > 343 <div class="bk-content-text content widget__content wysihtml-editor-content" itemscope 344 itemtype="https://schema.org/WebPage" >
345 <span class="js-text-content content-block" itemprop="mainContentOfPage" itemscope itemtype="https://schema.org/WebPageElement"> 346 347 <p> 348 349Here you find articles, tips and utilities I have written. Unlike blog posts, I <b>do</b> modify these from time to time. There is update history in each article, and for the more recently updated and new articles you find a visual indication on this page. 350 351</p><p> 352 353<span class="wysiwyg-font-size-small"><span class="wysiwyg-font-size-large">Articles</span><br></span></p><ul><li><span class="wysiwyg-font-size-small"><a href="/new-in-version-x" target="_self">What's new in version X</a></span></li><li><span class="wysiwyg-font-size-small"><a href="/checklist-for-sql-server-implementations" target="_self">Checklist for SQL Server implementations</a></span></li><li><span class="wysiwyg-font-size-small"><a href="/the-ultimate-guide-to-the-datetime-datatypes" target="_self">The ultimate guide to the datetime datatypes</a></span></li><li><span class="wysiwyg-font-size-small"><a href="/moving-a-database-between-two-sql-server-instances" target="_self">Moving a database between two SQL Server instances</a></span></li><li><span class="wysiwyg-font-size-small"><a href="/large-transaction-log-file" target="_self">Large transaction log file</a></span></li><li><span class="wysiwyg-font-size-small"><a href="/why-you-want-to-be-restrictive-with-shrink-of-database-files" target="_self">Why you want to be restrictive with shrink of database files</a></span></li><li><span class="wysiwyg-font-size-small"><a href="/recommended-actions-for-corrupt-databases" target="_self">Recommended actions for corrupt or suspect databases</a></span></li><li><span class="wysiwyg-font-size-small"><a href="/minimizing-data-loss-when-accidents-happens" target="_self">Minimizing data loss when accidents happens</a></span></li></ul><br><span class="wysiwyg-font-size-large">Utilities</span><br><ul><li><a href="/spdbinfo-database-space-usage-information" target="_self">sp_dbinfo - database space usage information</a></li><li><a href="/sptableinfo-list-tables-and-space-usage" target="_self">sp_tableinfo - list tables and space usage</a></li><li><a href="/spindexinfo-enhanced-index-information-procedure" target="_self">sp_indexinfo - enhanced index information procedure <b>(updated)</b></a> </li></ul><br><ul><li><a href="/looking-for-strange" target="_self">Looking for strange</a></li><li><a href="/templates-for-xe-profiler" target="_self">Templates for XE Profiler</a><b><span style="color: rgb(192, 80, 77);"> </span></b></li><li><a href="/log-wait-stats-over-time" target="_self">Log wait statistics over time</a></li><li><a href="/adjust-autogrow-values-for-database-files" target="_self">Adjust autogrow setting to reasonable size</a></li><li><a href="/log-page-life-expectancy-over-time" target="_self">Log Page Life Expectency over time</a></li><li><a href="/rebuild-all-fragmented-heaps" target="_self">Rebuild all fragmented heaps on a SQL Server</a></li><li><a href="/pause-random-number-of-minutes-or-seconds" target="_self">Pause random number of minutes or seconds</a></li><li><a href="/analyze-sql-server-and-agent-errorlogs" target="_self">Analyze SQL Server and Agent errorlogs</a></li><li><a href="/mailafterjob-send-email-after-agent-job-include-ouput-files" target="_self">MailAfterJob - send email after Agent job, with status in mail subject and output files attached</a></li><li><a href="/agent-alerts-management-pack" target="_self">Agent Alerts Management Pack</a></li><li><a href="/tsql-script-to-create-backup-file-including-database-name-date-and-time" target="_self">TSQL script to create backup file including database name, date and time</a></li><li><a href="/restore-all-databases-from-a-number-of-backup-files" target="_self">Restore all databases from a number of backup files in a directory</a></li><li><a href="/list-candidates-for-sparse-columns" target="_self">List column candidates for SPARSE - potential space savings</a> 354 355</li></ul><p></p> 356 357 </span> 358 </div> 359 360 361 362</div> 363 </section> 364 365 366 </section> 367 <!-- End Page Content --> 368 369</div> 370<!-- End bk-pt-default --> 371 372<!-- Footer --> 373<footer class="template-footer clearfix"> 374 <div class="left"> 375 376 </div> 377 <div class="right"> 378 <div id="page-zones__template-widgets__profile-profile2" class="widget widget--template-widget" data-widget-type="profile" data-uniqueid="page-zones__template-widgets__profile-profile2"> 379 380 <div class="bk-profile profile widget__profile"> 381 382 383 384 385 386 387 388 389 390 391 392 393 394 395 396 397 398 399 400 401 <div class="companycopyright profile__companycopyright"> 402 <p class="copyright companycopyright__copyright">Copyright Tibor Karaszi</p> 403 </div> 404 405 406 407 408 409 410 411 412 413 414 415 416 417 418</div> 419 420</div> 421 422 </div> 423</footer> 424<!-- End Footer --> 425 426 427 428<div id="js-cookie-consent-event" style="display: none;"></div> 429
429<script nonce=""> 430 function onCookieConsent(){ 431 window['ga-disable-' + 'UA-110028036-1'] = false; 432 _gaq.push(['_trackPageview']); 433 } 434 435 document.getElementById('js-cookie-consent-event').addEventListener( 436 'cookieConsentEvent', onCookieConsent 437 ); 438 </script>
438 439
440<script nonce=""> 441 App = {}; 442 App.i18n = {}; 443 App.nonce = ''; 444 App.session = { 445 get: function(key) 446 { 447 var property = null; 448 if (this.data[key] !== null && this.data[key] !== undefined) 449 { 450 return this.data[key]; 451 } 452 return property; 453 }, 454 data: { 455 siteRef: 10912, 456 domain: 'site.surftown.com', 457 brandRef: '1', 458 assetBaseUrl: 'https://55b558c7-resources.builder.nu/ea42165d20', 459 languageCode: 'sv', 460 pageRef: 105507, 461 pageLanguage: null, 462 protocol: 'https', 463 cookieBannerContent: null 464 } 465 } 466 467 var Brand = Brand || {}; 468 Brand.googleMapsEmbedKey = "AIzaSyC8V96sGgzrasorg2xPOlrlp-cpQFPLSxM"; 469 470 if ('ontouchstart' in window) { 471 document.body.classList.add('touch'); 472 } 473</script>
473 474
475<script nonce=""> 476window["Server"] = {"app":{"resizerDomain":"resizer.builder.nu","mode":"published","protocol":"https","maintenance":0,"deducedLocale":"sv_SE"},"componentTree":{"page":{"page-zones__main":{"page-zones__main-widgets__59f70c1d25f5b":[]}}},"editorVersion":"eight","isFullVersionTenSite":false,"page":{"pageFeatures":{"features":[],"plugins":[]},"componentTree":{"page":{"page-zones__main":{"page-zones__main-widgets__59f70c1d25f5b":[]}}},"request":"articlesandutilities","pageTree":[{"ref":105499,"request":"home","canonicalUrl":null,"title":"Home","seo_title":"Tibor Karaszi's SQL Server pages","keywords":"","description":"Tibor Karaszi's SQL Server pages","display_order":1,"type":"home","template_ref":"1","menu":1,"basekit_objects_ref":null,"modified":"2017-10-30 12:15:36","redirection":null,"priority":1,"changefreq":"monthly","can_publish":1,"headScript":"","bodyScript":"","headScriptOptions":[],"bodyScriptOptions":[],"status":"active","theme_ref":1,"color_swatch_ref":1,"font_swatch_ref":1,"password":"","password_enabled":false,"do_sub_page":"0","do_default":"0","templateType":"home","hiddenFromNavigation":0,"exclude_from_sitemap":0,"excludeFromPageLimit":0,"parentId":0,"language":null,"username":null,"linkOpenNewTab":null,"linkNofollow":null},{"ref":105503,"request":"blogpost","canonicalUrl":null,"title":"blogpost","seo_title":"","keywords":null,"description":null,"display_order":2,"type":"page","template_ref":"1","menu":1,"basekit_objects_ref":null,"modified":"2017-10-30 10:38:38","redirection":null,"priority":0,"changefreq":"monthly","can_publish":1,"headScript":null,"bodyScript":null,"headScriptOptions":[],"bodyScriptOptions":[],"status":"active","theme_ref":1,"color_swatch_ref":1,"font_swatch_ref":1,"password":"","password_enabled":false,"do_sub_page":"0","do_default":"0","templateType":"blogpost","hiddenFromNavigation":1,"exclude_from_sitemap":1,"excludeFromPageLimit":1,"parentId":0,"language":null,"username":null,"linkOpenNewTab":null,"linkNofollow":null},{"ref":105507,"request":"articlesandutilities","canonicalUrl":null,"title":"Articles and utilities","seo_title":"","keywords":"","description":"","display_order":2,"type":"page","template_ref":"1","menu":1,"basekit_objects_ref":null,"modified":"2017-10-30 12:37:02","redirection":null,"priority":0,"changefreq":"monthly","can_publish":1,"headScript":null,"bodyScript":null,"headScriptOptions":[],"bodyScriptOptions":[],"status":"active","theme_ref":1,"color_swatch_ref":1,"font_swatch_ref":1,"password":"","password_enabled":false,"do_sub_page":"0","do_default":"0","templateType":"default","hiddenFromNavigation":0,"exclude_from_sitemap":0,"excludeFromPageLimit":0,"parentId":0,"language":null,"username":null,"linkOpenNewTab":null,"linkNofollow":null},{"ref":105510,"request":"training","canonicalUrl":null,"title":"Training","seo_title":"","keywords":"","description":"","display_order":3,"type":"page","template_ref":"1","menu":1,"basekit_objects_ref":null,"modified":"2022-03-24 17:31:21","redirection":null,"priority":0,"changefreq":"monthly","can_publish":1,"headScript":null,"bodyScript":null,"headScriptOptions":[],"bodyScriptOptions":[],"status":"active","theme_ref":1,"color_swatch_ref":1,"font_swatch_ref":1,"password":"","password_enabled":false,"do_sub_page":"0","do_default":"0","templateType":"default","hiddenFromNavigation":0,"exclude_from_sitemap":0,"excludeFromPageLimit":0,"parentId":0,"language":null,"username":null,"linkOpenNewTab":null,"linkNofollow":null},{"ref":106505,"request":"httpsqlblogcomblogstiborkaraszi","canonicalUrl":null,"title":"Blog","seo_title":"","keywords":"","description":"","display_order":4,"type":"page","template_ref":"1","menu":1,"basekit_objects_ref":null,"modified":"2022-03-24 17:31:21","redirection":null,"priority":0,"changefreq":"monthly","can_publish":1,"headScript":null,"bodyScript":null,"headScriptOptions":[],"bodyScriptOptions":[],"status":"active","theme_ref":1,"color_swatch_ref":1,"font_swatch_ref":1,"password":"","password_enabled":false,"do_sub_page":"0","do_default":"0","templateType":"default","hiddenFromNavigation":0,"exclude_from_sitemap":0,"excludeFromPageLimit":0,"parentId":0,"language":null,"username":null,"linkOpenNewTab":null,"linkNofollow":null},{"ref":105869,"request":"links","canonicalUrl":null,"title":"Links","seo_title":"","keywords":null,"description":null,"display_order":5,"type":"page","template_ref":"1","menu":1,"basekit_objects_ref":null,"modified":"2022-03-24 17:31:21","redirection":null,"priority":0,"changefreq":"monthly","can_publish":1,"headScript":null,"bodyScript":null,"headScriptOptions":[],"bodyScriptOptions":[],"status":"active","theme_ref":1,"color_swatch_ref":1,"font_swatch_ref":1,"password":"","password_enabled":false,"do_sub_page":"0","do_default":"0","templateType":"default","hiddenFromNavigation":0,"exclude_from_sitemap":0,"excludeFromPageLimit":0,"parentId":0,"language":null,"username":null,"linkOpenNewTab":null,"linkNofollow":null},{"ref":105511,"request":"forums","canonicalUrl":null,"title":"Forums","seo_title":"","keywords":null,"description":null,"display_order":6,"type":"page","template_ref":"1","menu":1,"basekit_objects_ref":null,"modified":"2022-03-24 17:31:21","redirection":null,"priority":0,"changefreq":"monthly","can_publish":1,"headScript":null,"bodyScript":null,"headScriptOptions":[],"bodyScriptOptions":[],"status":"active","theme_ref":1,"color_swatch_ref":1,"font_swatch_ref":1,"password":"","password_enabled":false,"do_sub_page":"0","do_default":"0","templateType":"default","hiddenFromNavigation":0,"exclude_from_sitemap":0,"excludeFromPageLimit":0,"parentId":0,"language":null,"username":null,"linkOpenNewTab":null,"linkNofollow":null},{"ref":105505,"request":"about-me","canonicalUrl":null,"title":"About me","seo_title":"","keywords":null,"description":null,"display_order":7,"type":"page","template_ref":"1","menu":1,"basekit_objects_ref":null,"modified":"2022-03-24 17:31:21","redirection":null,"priority":0,"changefreq":"monthly","can_publish":1,"headScript":null,"bodyScript":null,"headScriptOptions":[],"bodyScriptOptions":[],"status":"active","theme_ref":1,"color_swatch_ref":1,"font_swatch_ref":1,"password":"","password_enabled":false,"do_sub_page":"0","do_default":"0","templateType":"about","hiddenFromNavigation":0,"exclude_from_sitemap":0,"excludeFromPageLimit":0,"parentId":0,"language":null,"username":null,"linkOpenNewTab":null,"linkNofollow":null},{"ref":105529,"request":"contact","canonicalUrl":null,"title":"Contact","seo_title":"","keywords":"","description":"","display_order":8,"type":"page","template_ref":"1","menu":1,"basekit_objects_ref":null,"modified":"2022-03-24 17:31:21","redirection":null,"priority":0,"changefreq":"monthly","can_publish":1,"headScript":null,"bodyScript":null,"headScriptOptions":[],"bodyScriptOptions":[],"status":"active","theme_ref":1,"color_swatch_ref":1,"font_swatch_ref":1,"password":"","password_enabled":false,"do_sub_page":"0","do_default":"0","templateType":"contact","hiddenFromNavigation":0,"exclude_from_sitemap":0,"excludeFromPageLimit":0,"parentId":0,"language":null,"username":null,"linkOpenNewTab":null,"linkNofollow":null},{"ref":105516,"request":"checklist-for-sql-server-implementations","canonicalUrl":null,"title":"Checklist for SQL Server implementations","seo_title":"","keywords":"","description":"","display_order":9,"type":"page","template_ref":"1","menu":1,"basekit_objects_ref":null,"modified":"2022-03-24 17:31:21","redirection":null,"priority":0,"changefreq":"monthly","can_publish":1,"headScript":null,"bodyScript":null,"headScriptOptions":[],"bodyScriptOptions":[],"status":"active","theme_ref":1,"color_swatch_ref":1,"font_swatch_ref":1,"password":"","password_enabled":false,"do_sub_page":"0","do_default":"0","templateType":"default","hiddenFromNavigation":1,"exclude_from_sitemap":0,"excludeFromPageLimit":0,"parentId":0,"language":null,"username":null,"linkOpenNewTab":null,"linkNofollow":null},{"ref":105517,"request":"the-ultimate-guide-to-the-datetime-datatypes","canonicalUrl":null,"title":"The ultimate guide to the datetime datatypes","seo_title":"","keywords":"","description":"","display_order":10,"type":"page","template_ref":"1","menu":1,"basekit_objects_ref":null,"modified":"2022-03-24 17:31:21","redirection":null,"priority":0,"changefreq":"monthly","can_publish":1,"headScript":null,"bodyScript":null,"headScriptOptions":[],"bodyScriptOptions":[],"status":"active","theme_ref":1,"color_swatch_ref":1,"font_swatch_ref":1,"password":"","password_enabled":false,"do_sub_page":"0","do_default":"0","templateType":"default","hiddenFromNavigation":1,"exclude_from_sitemap":0,"excludeFromPageLimit":0,"parentId":0,"language":null,"username":null,"linkOpenNewTab":null,"linkNofollow":null},{"ref":105520,"request":"moving-a-database-between-two-sql-server-instances","canonicalUrl":null,"title":"Moving a database between two SQL Server instances","seo_title":"","keywords":"","description":"","display_order":11,"type":"page","template_ref":"1","menu":1,"basekit_objects_ref":null,"modified":"2022-03-24 17:31:21","redirection":null,"priority":0,"changefreq":"monthly","can_publish":1,"headScript":null,"bodyScript":null,"headScriptOptions":[],"bodyScriptOptions":[],"status":"active","theme_ref":1,"color_swatch_ref":1,"font_swatch_ref":1,"password":"","password_enabled":false,"do_sub_page":"0","do_default":"0","templateType":"default","hiddenFromNavigation":1,"exclude_from_sitemap":0,"excludeFromPageLimit":0,"parentId":0,"language":null,"username":null,"linkOpenNewTab":null,"linkNofollow":null},{"ref":105524,"request":"large-transaction-log-file","canonicalUrl":null,"title":"Large transaction log file","seo_title":"","keywords":"","description":"","display_order":12,"type":"page","template_ref":"1","menu":1,"basekit_objects_ref":null,"modified":"2022-03-24 17:31:21","redirection":null,"priority":0,"changefreq":"monthly","can_publish":1,"headScript":null,"bodyScript":null,"headScriptOptions":[],"bodyScriptOptions":[],"status":"active","theme_ref":1,"color_swatch_ref":1,"font_swatch_ref":1,"password":"","password_enabled":false,"do_sub_page":"0","do_default":"0","templateType":"default","hiddenFromNavigation":1,"exclude_from_sitemap":0,"excludeFromPageLimit":0,"parentId":0,"language":null,"username":null,"linkOpenNewTab":null,"linkNofollow":null},{"ref":105546,"request":"why-you-want-to-be-restrictive-with-shrink-of-database-files","canonicalUrl":null,"title":"Why you want to be restrictive with shrink of database files","seo_title":"","keywords":"","description":"","display_order":13,"type":"page","template_ref":"1","menu":1,"basekit_objects_ref":null,"modified":"2022-03-24 17:31:21","redirection":null,"priority":0,"changefreq":"monthly","can_publish":1,"headScript":null,"bodyScript":null,"headScriptOptions":[],"bodyScriptOptions":[],"status":"active","theme_ref":1,"color_swatch_ref":1,"font_swatch_ref":1,"password":"","password_enabled":false,"do_sub_page":"0","do_default":"0","templateType":"default","hiddenFromNavigation":1,"exclude_from_sitemap":0,"excludeFromPageLimit":0,"parentId":0,"language":null,"username":null,"linkOpenNewTab":null,"linkNofollow":null},{"ref":105547,"request":"recommended-actions-for-corrupt-databases","canonicalUrl":null,"title":"Recommended actions for c
476orrupt databases","seo_title":"","keywords":"","description":"","display_order":14,"type":"page","template_ref":"1","menu":1,"basekit_objects_ref":null,"modified":"2022-03-24 17:31:21","redirection":null,"priority":0,"changefreq":"monthly","can_publish":1,"headScript":null,"bodyScript":null,"headScriptOptions":[],"bodyScriptOptions":[],"status":"active","theme_ref":1,"color_swatch_ref":1,"font_swatch_ref":1,"password":"","password_enabled":false,"do_sub_page":"0","do_default":"0","templateType":"default","hiddenFromNavigation":1,"exclude_from_sitemap":0,"excludeFromPageLimit":0,"parentId":0,"language":null,"username":null,"linkOpenNewTab":null,"linkNofollow":null},{"ref":105548,"request":"minimizing-data-loss-when-accidents-happens","canonicalUrl":null,"title":"Minimizing data loss when accidents happens","seo_title":"","keywords":"","description":"","display_order":15,"type":"page","template_ref":"1","menu":1,"basekit_objects_ref":null,"modified":"2022-03-24 17:31:21","redirection":null,"priority":0,"changefreq":"monthly","can_publish":1,"headScript":null,"bodyScript":null,"headScriptOptions":[],"bodyScriptOptions":[],"status":"active","theme_ref":1,"color_swatch_ref":1,"font_swatch_ref":1,"password":"","password_enabled":false,"do_sub_page":"0","do_default":"0","templateType":"default","hiddenFromNavigation":1,"exclude_from_sitemap":0,"excludeFromPageLimit":0,"parentId":0,"language":null,"username":null,"linkOpenNewTab":null,"linkNofollow":null},{"ref":105521,"request":"spdbinfo-database-space-usage-information","canonicalUrl":null,"title":"sp_dbinfo - database space usage information","seo_title":"","keywords":"","description":"","display_order":16,"type":"page","template_ref":"1","menu":1,"basekit_objects_ref":null,"modified":"2022-03-24 17:31:21","redirection":null,"priority":0,"changefreq":"monthly","can_publish":1,"headScript":null,"bodyScript":null,"headScriptOptions":[],"bodyScriptOptions":[],"status":"active","theme_ref":1,"color_swatch_ref":1,"font_swatch_ref":1,"password":"","password_enabled":false,"do_sub_page":"0","do_default":"0","templateType":"default","hiddenFromNavigation":1,"exclude_from_sitemap":0,"excludeFromPageLimit":0,"parentId":0,"language":null,"username":null,"linkOpenNewTab":null,"linkNofollow":null},{"ref":105522,"request":"sptableinfo-list-tables-and-space-usage","canonicalUrl":null,"title":"sp_tableinfo - list tables and space usage","seo_title":"","keywords":"","description":"","display_order":17,"type":"page","template_ref":"1","menu":1,"basekit_objects_ref":null,"modified":"2022-03-24 17:31:21","redirection":null,"priority":0,"changefreq":"monthly","can_publish":1,"headScript":null,"bodyScript":null,"headScriptOptions":[],"bodyScriptOptions":[],"status":"active","theme_ref":1,"color_swatch_ref":1,"font_swatch_ref":1,"password":"","password_enabled":false,"do_sub_page":"0","do_default":"0","templateType":"default","hiddenFromNavigation":1,"exclude_from_sitemap":0,"excludeFromPageLimit":0,"parentId":0,"language":null,"username":null,"linkOpenNewTab":null,"linkNofollow":null},{"ref":105523,"request":"spindexinfo-enhanced-index-information-procedure","canonicalUrl":null,"title":"sp_indexinfo - enhanced index information procedure","seo_title":"","keywords":"","description":"","display_order":18,"type":"page","template_ref":"1","menu":1,"basekit_objects_ref":null,"modified":"2022-03-24 17:31:21","redirection":null,"priority":0,"changefreq":"monthly","can_publish":1,"headScript":null,"bodyScript":null,"headScriptOptions":[],"bodyScriptOptions":[],"status":"active","theme_ref":1,"color_swatch_ref":1,"font_swatch_ref":1,"password":"","password_enabled":false,"do_sub_page":"0","do_default":"0","templateType":"default","hiddenFromNavigation":1,"exclude_from_sitemap":0,"excludeFromPageLimit":0,"parentId":0,"language":null,"username":null,"linkOpenNewTab":null,"linkNofollow":null},{"ref":105588,"request":"templates-for-xe-profiler","canonicalUrl":null,"title":"Templates for XE Profiler","seo_title":"","keywords":"","description":"","display_order":19,"type":"page","template_ref":"1","menu":1,"basekit_objects_ref":null,"modified":"2022-03-24 17:31:21","redirection":null,"priority":0,"changefreq":"monthly","can_publish":1,"headScript":null,"bodyScript":null,"headScriptOptions":[],"bodyScriptOptions":[],"status":"active","theme_ref":1,"color_swatch_ref":1,"font_swatch_ref":1,"password":"","password_enabled":false,"do_sub_page":"0","do_default":"0","templateType":"default","hiddenFromNavigation":1,"exclude_from_sitemap":0,"excludeFromPageLimit":0,"parentId":0,"language":null,"username":null,"linkOpenNewTab":null,"linkNofollow":null},{"ref":105589,"request":"log-wait-stats-over-time","canonicalUrl":null,"title":"Log wait stats over time","seo_title":"","keywords":"","description":"","display_order":20,"type":"page","template_ref":"1","menu":1,"basekit_objects_ref":null,"modified":"2022-03-24 17:31:21","redirection":null,"priority":0,"changefreq":"monthly","can_publish":1,"headScript":null,"bodyScript":null,"headScriptOptions":[],"bodyScriptOptions":[],"status":"active","theme_ref":1,"color_swatch_ref":1,"font_swatch_ref":1,"password":"","password_enabled":false,"do_sub_page":"0","do_default":"0","templateType":"default","hiddenFromNavigation":1,"exclude_from_sitemap":0,"excludeFromPageLimit":0,"parentId":0,"language":null,"username":null,"linkOpenNewTab":null,"linkNofollow":null},{"ref":105590,"request":"adjust-autogrow-values-for-database-files","canonicalUrl":null,"title":"Adjust autogrow values for database files","seo_title":"","keywords":"","description":"","display_order":21,"type":"page","template_ref":"1","menu":1,"basekit_objects_ref":null,"modified":"2022-03-24 17:31:21","redirection":null,"priority":0,"changefreq":"monthly","can_publish":1,"headScript":null,"bodyScript":null,"headScriptOptions":[],"bodyScriptOptions":[],"status":"active","theme_ref":1,"color_swatch_ref":1,"font_swatch_ref":1,"password":"","password_enabled":false,"do_sub_page":"0","do_default":"0","templateType":"default","hiddenFromNavigation":1,"exclude_from_sitemap":0,"excludeFromPageLimit":0,"parentId":0,"language":null,"username":null,"linkOpenNewTab":null,"linkNofollow":null},{"ref":105591,"request":"log-page-life-expectancy-over-time","canonicalUrl":null,"title":"Log Page Life Expectancy over time","seo_title":"","keywords":"","description":"","display_order":22,"type":"page","template_ref":"1","menu":1,"basekit_objects_ref":null,"modified":"2022-03-24 17:31:21","redirection":null,"priority":0,"changefreq":"monthly","can_publish":1,"headScript":null,"bodyScript":null,"headScriptOptions":[],"bodyScriptOptions":[],"status":"active","theme_ref":1,"color_swatch_ref":1,"font_swatch_ref":1,"password":"","password_enabled":false,"do_sub_page":"0","do_default":"0","templateType":"default","hiddenFromNavigation":1,"exclude_from_sitemap":0,"excludeFromPageLimit":0,"parentId":0,"language":null,"username":null,"linkOpenNewTab":null,"linkNofollow":null},{"ref":105592,"request":"rebuild-all-fragmented-heaps","canonicalUrl":null,"title":"Rebuild all fragmented heaps","seo_title":"","keywords":"","description":"","display_order":23,"type":"page","template_ref":"1","menu":1,"basekit_objects_ref":null,"modified":"2022-03-24 17:31:21","redirection":null,"priority":0,"changefreq":"monthly","can_publish":1,"headScript":null,"bodyScript":null,"headScriptOptions":[],"bodyScriptOptions":[],"status":"active","theme_ref":1,"color_swatch_ref":1,"font_swatch_ref":1,"password":"","password_enabled":false,"do_sub_page":"0","do_default":"0","templateType":"default","hiddenFromNavigation":1,"exclude_from_sitemap":0,"excludeFromPageLimit":0,"parentId":0,"language":null,"username":null,"linkOpenNewTab":null,"linkNofollow":null},{"ref":105593,"request":"pause-random-number-of-minutes-or-seconds","canonicalUrl":null,"title":"Pause random number of minutes or seconds","seo_title":"","keywords":"","description":"","display_order":24,"type":"page","template_ref":"1","menu":1,"basekit_objects_ref":null,"modified":"2022-03-24 17:31:21","redirection":null,"priority":0,"changefreq":"monthly","can_publish":1,"headScript":null,"bodyScript":null,"headScriptOptions":[],"bodyScriptOptions":[],"status":"active","theme_ref":1,"color_swatch_ref":1,"font_swatch_ref":1,"password":"","password_enabled":false,"do_sub_page":"0","do_default":"0","templateType":"default","hiddenFromNavigation":1,"exclude_from_sitemap":0,"excludeFromPageLimit":0,"parentId":0,"language":null,"username":null,"linkOpenNewTab":null,"linkNofollow":null},{"ref":105594,"request":"analyze-sql-server-and-agent-errorlogs","canonicalUrl":null,"title":"Analyze SQL Server and Agent errorlogs","seo_title":"","keywords":"","description":"","display_order":25,"type":"page","template_ref":"1","menu":1,"basekit_objects_ref":null,"modified":"2022-03-24 17:31:21","redirection":null,"priority":0,"changefreq":"monthly","can_publish":1,"headScript":null,"bodyScript":null,"headScriptOptions":[],"bodyScriptOptions":[],"status":"active","theme_ref":1,"color_swatch_ref":1,"font_swatch_ref":1,"password":"","password_enabled":false,"do_sub_page":"0","do_default":"0","templateType":"default","hiddenFromNavigation":1,"exclude_from_sitemap":0,"excludeFromPageLimit":0,"parentId":0,"language":null,"username":null,"linkOpenNewTab":null,"linkNofollow":null},{"ref":105595,"request":"mailafterjob-send-email-after-agent-job-include-ouput-files","canonicalUrl":null,"title":"MailAfterJob - send email after Agent job, include ouput files","seo_title":"","keywords":"","description":"","display_order":26,"type":"page","template_ref":"1","menu":1,"basekit_objects_ref":null,"modified":"2022-03-24 17:31:21","redirection":null,"priority":0,"changefreq":"monthly","can_publish":1,"headScript":null,"bodyScript":null,"headScriptOptions":[],"bodyScriptOptions":[],"status":"active","theme_ref":1,"color_swatch_ref":1,"font_swatch_ref":1,"password":"","password_enabled":false,"do_sub_page":"0","do_default":"0","templateType":"default","hiddenFromNavigation":1,"exclude_from_sitemap":0,"excludeFromPageLimit":0,"parentId":0,"language":null,"username":null,"linkOpenNewTab":null,"linkNofollow":null},{"ref":105596,"request":"agent-alerts-management-pack","canonicalUrl":null,"title":"Agent Alerts Management Pack","seo_title":"","keywords":"","description":"","display_order":27,"type":"page","template_ref":"1","menu":1,"basekit_objects_ref":null,"modified":"2022-03-24 17:31:21","redirection":null,"priority":0,"changefreq":"monthly","can_publish":1,"headScript":null,"bodyScript":null,"headScriptOptions":[],"bodyScriptOptions":[],"status":"active","theme_ref":1,"color_swatch_ref":1,"font_swatch_ref":1,"password":"","password_enabled":false,"do_sub_page":"0","do_default":"0","templateType":"default","hiddenFromNavigation":1,"exclude_from_sitemap":0,"excludeFromPageLimit":0,"parentId":0,"language":null,"username":null,"linkOpenNewTab":null,"linkNofollow":null},{"ref":105597,"request":"tsql-script-to-create-backup-file-including-database-name-date-and-time","canonicalUrl":null,"title":"TSQL script to create backup file including database name, date and time","seo_title":"","keywords":"","description":"","display_order":28,"type":"page","template_ref":"1","menu":1,"basekit_objects_ref":null,"modified":"2022-03-24 17:31:21","redirection":null,"priority":0,"changefreq":"monthly","can_publish":1,"headScript":null,"bodyScript":null,"headScriptOptions":[],"bodyScriptOptions":[],"status":"active","theme_ref":1,"color_swatch_ref":1,"font_swatch_ref":1,"password":"","password_enabled":false,"do_sub_page":"0","do_default":"0","templateType":"default","hiddenFromNavigation":1,"exclude_from_sitemap":0,"excludeFromPageLimit":0,"parentId":0,"language":null,"username":null,"linkOpenNewTab":null,"linkNofollow":null},{"ref":105598,"request":"restore-all-databases-from-a-number-of-backup-files","canonicalUrl":null,"title":"Restore all databases from a number of backup files","seo_title":"","keywords":"","description":"","display_order":29,"type":"page","template_ref":"1","menu":1,"basekit_objects_ref":null,"modified":"2022-03-24 17:31:21","redirection":null,"priority":0,"changefreq":"monthly","can_publish":1,"headScript":null,"bodyScript":null,"headScriptOptions":[],"bodyScriptOptions":[],"status":"active","theme_ref":1,"color_swatch_ref":1,"font_swatch_ref":1,"password":"","password_enabled":false,"do_sub_page":"0","do_default":"0","templateType":"default","hiddenFromNavigation":1,"exclude_from_sitemap":0,"excludeFromPageLimit":0,"parentId":0,"language":null,"username":null,"linkOpenNewTab":null,"linkNofollow":null},{"ref":105599,"request":"list-candidates-for-sparse-columns","canonicalUrl":null,"title":"List candidates for sparse columns","seo_title":"","keywords":"","description":"","display_order":30,"type":"page","template_ref":"1","menu":1,"basekit_objects_ref":null,"modified":"2022-03-24 17:31:21","redirection":null,"priority":0,"changefreq":"monthly","can_publish":1,"headScript":null,"bodyScript":null,"headScriptOptions":[],"bodyScriptOptions":[],"status":"active","theme_ref":1,"color_swatch_ref":1,"font_swatch_ref":1,"password":"","password_enabled":false,"do_sub_page":"0","do_default":"0","templateType":"default","hiddenFromNavigation":1,"exclude_from_sitemap":0,"excludeFromPageLimit":0,"parentId":0,"language":null,"username":null,"linkOpenNewTab":null,"linkNofollow":null},{"ref":105600,"request":"running-shoes","canonicalUrl":null,"title":"Running shoes","seo_title":"","keywords":"","description":"","display_order":31,"type":"page","template_ref":"1","menu":1,"basekit_objects_ref":null,"modified":"2022-03-24 17:31:21","redirection":null,"priority":0,"changefreq":"monthly","can_publish":1,"headScript":null,"bodyScript":null,"headScriptOptions":[],"bodyScriptOptions":[],"status":"active","theme_ref":1,"color_swatch_ref":1,"font_swatch_ref":1,"password":"","password_enabled":false,"do_sub_page":"0","do_default":"0","templateType":"default","hiddenFromNavigation":1,"exclude_from_sitemap":0,"excludeFromPageLimit":0,"parentId":0,"language":null,"username":null,"linkOpenNewTab":null,"linkNofollow":null},{"ref":105813,"request":"kursmaterial-skillpipe","canonicalUrl":null,"title":"Kursmaterial Skillpipe","seo_title":"","keywords":"","description":"","display_order":33,"type":"page","template_ref":"1","menu":1,"basekit_objects_ref":null,"modified":"2022-03-24 17:31:21","redirection":null,"priority":0,"changefreq":"monthly","can_publish":1,"headScript":null,"bodyScript":null,"headScriptOptions":[],"bodyScriptOptions":[],"status":"active","theme_ref":1,"color_swatch_ref":1,"font_swatch_ref":1,"password":"","password_enabled":false,"do_sub_page":"0","do_default":"0","templateType":"default","hiddenFromNavigation":1,"exclude_from_sitemap":0,"excludeFromPageLimit":0,"parentId":0,"language":null,"username":null,"linkOpenNewTab":null,"linkNofollow":null},{"ref":135591,"request":"new-in-version-x","canonicalUrl":null,"title":"What's new in SQL Server","seo_title":"","keywords":"","description":"","display_order":34,"type":"page","template_ref":"1","menu":1,"basekit_objects_ref":null,"modified":"2022-05-19 15:08:42","redirection":null,"priority":0,"changefreq":"monthly","can_publish":1,"headScript":null,"bodyScript":null,"headScriptOptions":[],"bodyScriptOptions":[],"status":"active","theme_ref":1,"color_swatch_ref":1,"font_swatch_ref":1,"password":"","password_enabled":false,"do_sub_page":"0","do_default":"0","templateType":"default","hiddenFromNavigation":1,"exclude_from_sitemap":0,"excludeFromPageLimit":0,"parentId":0,"language":null,"username":null,"linkOpenNewTab":null,"linkNofollow":null},{"ref":216332,"request":"looking-for-strange","canonicalUrl":null,"title":"Looking for strange","seo_title":"","keywords":"","description":"","display_order":35,"type":"page","template_ref":"1","menu":1,"basekit_objects_ref":null,"modified":"2022-03-24 17:31:21","redirection":null,"priority":0,"changefreq":"monthly","can_publish":1,"headScript":null,"bodyScript":null,"headScriptOptions":[],"bodyScriptOptions":[],"status":"active","theme_ref":1,"color_swatch_ref":1,"font_swatch_ref":1,"password":"","password_enabled":false,"do_sub_page":"0","do_default":"0","templateType":"default","hiddenFromNavigation":1,"exclude_from_sitemap":0,"excludeFromPageLimit":0,"parentId":0,"language":null,"username":null,"linkOpenNewTab":null,"linkNofollow":null},
476{"ref":377724,"request":"tack-f\u00f6r-denna-g\u00e5ng","canonicalUrl":null,"title":"Tack f\u00f6r denna g\u00e5ng","seo_title":"","keywords":"","description":"","display_order":36,"type":"page","template_ref":"1","menu":1,"basekit_objects_ref":null,"modified":"2022-03-24 17:31:21","redirection":null,"priority":0,"changefreq":"monthly","can_publish":1,"headScript":null,"bodyScript":null,"headScriptOptions":[],"bodyScriptOptions":[],"status":"active","theme_ref":1,"color_swatch_ref":1,"font_swatch_ref":1,"password":"","password_enabled":false,"do_sub_page":"0","do_default":"0","templateType":"default","hiddenFromNavigation":1,"exclude_from_sitemap":0,"excludeFromPageLimit":0,"parentId":0,"language":null,"username":null,"linkOpenNewTab":null,"linkNofollow":null},{"ref":105504,"request":"blog","canonicalUrl":null,"title":"SQL Server blog","seo_title":"","keywords":null,"description":null,"display_order":37,"type":"page","template_ref":"1","menu":1,"basekit_objects_ref":null,"modified":"2022-03-24 17:31:21","redirection":null,"priority":0,"changefreq":"monthly","can_publish":1,"headScript":null,"bodyScript":null,"headScriptOptions":[],"bodyScriptOptions":[],"status":"active","theme_ref":1,"color_swatch_ref":1,"font_swatch_ref":1,"password":"","password_enabled":false,"do_sub_page":"0","do_default":"0","templateType":"blogpostlist","hiddenFromNavigation":0,"exclude_from_sitemap":1,"excludeFromPageLimit":1,"parentId":0,"language":null,"username":null,"linkOpenNewTab":null,"linkNofollow":null},{"ref":420179,"request":"my-students-page","canonicalUrl":null,"title":"Only for Tibor's students","seo_title":"","keywords":"","description":"","display_order":38,"type":"page","template_ref":"1","menu":1,"basekit_objects_ref":null,"modified":"2022-10-12 15:51:50","redirection":null,"priority":0,"changefreq":"monthly","can_publish":1,"headScript":null,"bodyScript":null,"headScriptOptions":[],"bodyScriptOptions":[],"status":"active","theme_ref":1,"color_swatch_ref":1,"font_swatch_ref":1,"password":"","password_enabled":false,"do_sub_page":"0","do_default":"0","templateType":"default","hiddenFromNavigation":1,"exclude_from_sitemap":0,"excludeFromPageLimit":0,"parentId":0,"language":null,"username":null,"linkOpenNewTab":null,"linkNofollow":null}],"backgroundClass":null,"customHead":[],"canonicalUrl":"https:\/\/karaszi.com\/articlesandutilities","language":null,"isPluginPage":false,"isRTLLanguage":false,"ref":105507,"title":"Tibor Karaszi SQL Server","titleInNavAndWidget":"Articles and utilities","description":"Tibor Karaszis SQL Server pages","type":"page","keywords":"SQL Server, SQL","seoLang":"en","templateType":"default","headScript":"","bodyScript":"","headScriptOptions":[],"bodyScriptOptions":[]},"pageTree":[{"ref":105499,"request":"home","canonicalUrl":null,"title":"Home","seo_title":"Tibor Karaszi's SQL Server pages","keywords":"","description":"Tibor Karaszi's SQL Server pages","display_order":1,"type":"home","template_ref":"1","menu":1,"basekit_objects_ref":null,"modified":"2017-10-30 12:15:36","redirection":null,"priority":1,"changefreq":"monthly","can_publish":1,"headScript":"","bodyScript":"","headScriptOptions":[],"bodyScriptOptions":[],"status":"active","theme_ref":1,"color_swatch_ref":1,"font_swatch_ref":1,"password":"","password_enabled":false,"do_sub_page":"0","do_default":"0","templateType":"home","hiddenFromNavigation":0,"exclude_from_sitemap":0,"excludeFromPageLimit":0,"parentId":0,"language":null,"username":null,"linkOpenNewTab":null,"linkNofollow":null},{"ref":105503,"request":"blogpost","canonicalUrl":null,"title":"blogpost","seo_title":"","keywords":null,"description":null,"display_order":2,"type":"page","template_ref":"1","menu":1,"basekit_objects_ref":null,"modified":"2017-10-30 10:38:38","redirection":null,"priority":0,"changefreq":"monthly","can_publish":1,"headScript":null,"bodyScript":null,"headScriptOptions":[],"bodyScriptOptions":[],"status":"active","theme_ref":1,"color_swatch_ref":1,"font_swatch_ref":1,"password":"","password_enabled":false,"do_sub_page":"0","do_default":"0","templateType":"blogpost","hiddenFromNavigation":1,"exclude_from_sitemap":1,"excludeFromPageLimit":1,"parentId":0,"language":null,"username":null,"linkOpenNewTab":null,"linkNofollow":null},{"ref":105507,"request":"articlesandutilities","canonicalUrl":null,"title":"Articles and utilities","seo_title":"","keywords":"","description":"","display_order":2,"type":"page","template_ref":"1","menu":1,"basekit_objects_ref":null,"modified":"2017-10-30 12:37:02","redirection":null,"priority":0,"changefreq":"monthly","can_publish":1,"headScript":null,"bodyScript":null,"headScriptOptions":[],"bodyScriptOptions":[],"status":"active","theme_ref":1,"color_swatch_ref":1,"font_swatch_ref":1,"password":"","password_enabled":false,"do_sub_page":"0","do_default":"0","templateType":"default","hiddenFromNavigation":0,"exclude_from_sitemap":0,"excludeFromPageLimit":0,"parentId":0,"language":null,"username":null,"linkOpenNewTab":null,"linkNofollow":null},{"ref":105510,"request":"training","canonicalUrl":null,"title":"Training","seo_title":"","keywords":"","description":"","display_order":3,"type":"page","template_ref":"1","menu":1,"basekit_objects_ref":null,"modified":"2022-03-24 17:31:21","redirection":null,"priority":0,"changefreq":"monthly","can_publish":1,"headScript":null,"bodyScript":null,"headScriptOptions":[],"bodyScriptOptions":[],"status":"active","theme_ref":1,"color_swatch_ref":1,"font_swatch_ref":1,"password":"","password_enabled":false,"do_sub_page":"0","do_default":"0","templateType":"default","hiddenFromNavigation":0,"exclude_from_sitemap":0,"excludeFromPageLimit":0,"parentId":0,"language":null,"username":null,"linkOpenNewTab":null,"linkNofollow":null},{"ref":106505,"request":"httpsqlblogcomblogstiborkaraszi","canonicalUrl":null,"title":"Blog","seo_title":"","keywords":"","description":"","display_order":4,"type":"page","template_ref":"1","menu":1,"basekit_objects_ref":null,"modified":"2022-03-24 17:31:21","redirection":null,"priority":0,"changefreq":"monthly","can_publish":1,"headScript":null,"bodyScript":null,"headScriptOptions":[],"bodyScriptOptions":[],"status":"active","theme_ref":1,"color_swatch_ref":1,"font_swatch_ref":1,"password":"","password_enabled":false,"do_sub_page":"0","do_default":"0","templateType":"default","hiddenFromNavigation":0,"exclude_from_sitemap":0,"excludeFromPageLimit":0,"parentId":0,"language":null,"username":null,"linkOpenNewTab":null,"linkNofollow":null},{"ref":105869,"request":"links","canonicalUrl":null,"title":"Links","seo_title":"","keywords":null,"description":null,"display_order":5,"type":"page","template_ref":"1","menu":1,"basekit_objects_ref":null,"modified":"2022-03-24 17:31:21","redirection":null,"priority":0,"changefreq":"monthly","can_publish":1,"headScript":null,"bodyScript":null,"headScriptOptions":[],"bodyScriptOptions":[],"status":"active","theme_ref":1,"color_swatch_ref":1,"font_swatch_ref":1,"password":"","password_enabled":false,"do_sub_page":"0","do_default":"0","templateType":"default","hiddenFromNavigation":0,"exclude_from_sitemap":0,"excludeFromPageLimit":0,"parentId":0,"language":null,"username":null,"linkOpenNewTab":null,"linkNofollow":null},{"ref":105511,"request":"forums","canonicalUrl":null,"title":"Forums","seo_title":"","keywords":null,"description":null,"display_order":6,"type":"page","template_ref":"1","menu":1,"basekit_objects_ref":null,"modified":"2022-03-24 17:31:21","redirection":null,"priority":0,"changefreq":"monthly","can_publish":1,"headScript":null,"bodyScript":null,"headScriptOptions":[],"bodyScriptOptions":[],"status":"active","theme_ref":1,"color_swatch_ref":1,"font_swatch_ref":1,"password":"","password_enabled":false,"do_sub_page":"0","do_default":"0","templateType":"default","hiddenFromNavigation":0,"exclude_from_sitemap":0,"excludeFromPageLimit":0,"parentId":0,"language":null,"username":null,"linkOpenNewTab":null,"linkNofollow":null},{"ref":105505,"request":"about-me","canonicalUrl":null,"title":"About me","seo_title":"","keywords":null,"description":null,"display_order":7,"type":"page","template_ref":"1","menu":1,"basekit_objects_ref":null,"modified":"2022-03-24 17:31:21","redirection":null,"priority":0,"changefreq":"monthly","can_publish":1,"headScript":null,"bodyScript":null,"headScriptOptions":[],"bodyScriptOptions":[],"status":"active","theme_ref":1,"color_swatch_ref":1,"font_swatch_ref":1,"password":"","password_enabled":false,"do_sub_page":"0","do_default":"0","templateType":"about","hiddenFromNavigation":0,"exclude_from_sitemap":0,"excludeFromPageLimit":0,"parentId":0,"language":null,"username":null,"linkOpenNewTab":null,"linkNofollow":null},{"ref":105529,"request":"contact","canonicalUrl":null,"title":"Contact","seo_title":"","keywords":"","description":"","display_order":8,"type":"page","template_ref":"1","menu":1,"basekit_objects_ref":null,"modified":"2022-03-24 17:31:21","redirection":null,"priority":0,"changefreq":"monthly","can_publish":1,"headScript":null,"bodyScript":null,"headScriptOptions":[],"bodyScriptOptions":[],"status":"active","theme_ref":1,"color_swatch_ref":1,"font_swatch_ref":1,"password":"","password_enabled":false,"do_sub_page":"0","do_default":"0","templateType":"contact","hiddenFromNavigation":0,"exclude_from_sitemap":0,"excludeFromPageLimit":0,"parentId":0,"language":null,"username":null,"linkOpenNewTab":null,"linkNofollow":null},{"ref":105516,"request":"checklist-for-sql-server-implementations","canonicalUrl":null,"title":"Checklist for SQL Server implementations","seo_title":"","keywords":"","description":"","display_order":9,"type":"page","template_ref":"1","menu":1,"basekit_objects_ref":null,"modified":"2022-03-24 17:31:21","redirection":null,"priority":0,"changefreq":"monthly","can_publish":1,"headScript":null,"bodyScript":null,"headScriptOptions":[],"bodyScriptOptions":[],"status":"active","theme_ref":1,"color_swatch_ref":1,"font_swatch_ref":1,"password":"","password_enabled":false,"do_sub_page":"0","do_default":"0","templateType":"default","hiddenFromNavigation":1,"exclude_from_sitemap":0,"excludeFromPageLimit":0,"parentId":0,"language":null,"username":null,"linkOpenNewTab":null,"linkNofollow":null},{"ref":105517,"request":"the-ultimate-guide-to-the-datetime-datatypes","canonicalUrl":null,"title":"The ultimate guide to the datetime datatypes","seo_title":"","keywords":"","description":"","display_order":10,"type":"page","template_ref":"1","menu":1,"basekit_objects_ref":null,"modified":"2022-03-24 17:31:21","redirection":null,"priority":0,"changefreq":"monthly","can_publish":1,"headScript":null,"bodyScript":null,"headScriptOptions":[],"bodyScriptOptions":[],"status":"active","theme_ref":1,"color_swatch_ref":1,"font_swatch_ref":1,"password":"","password_enabled":false,"do_sub_page":"0","do_default":"0","templateType":"default","hiddenFromNavigation":1,"exclude_from_sitemap":0,"excludeFromPageLimit":0,"parentId":0,"language":null,"username":null,"linkOpenNewTab":null,"linkNofollow":null},{"ref":105520,"request":"moving-a-database-between-two-sql-server-instances","canonicalUrl":null,"title":"Moving a database between two SQL Server instances","seo_title":"","keywords":"","description":"","display_order":11,"type":"page","template_ref":"1","menu":1,"basekit_objects_ref":null,"modified":"2022-03-24 17:31:21","redirection":null,"priority":0,"changefreq":"monthly","can_publish":1,"headScript":null,"bodyScript":null,"headScriptOptions":[],"bodyScriptOptions":[],"status":"active","theme_ref":1,"color_swatch_ref":1,"font_swatch_ref":1,"password":"","password_enabled":false,"do_sub_page":"0","do_default":"0","templateType":"default","hiddenFromNavigation":1,"exclude_from_sitemap":0,"excludeFromPageLimit":0,"parentId":0,"language":null,"username":null,"linkOpenNewTab":null,"linkNofollow":null},{"ref":105524,"request":"large-transaction-log-file","canonicalUrl":null,"title":"Large transaction log file","seo_title":"","keywords":"","description":"","display_order":12,"type":"page","template_ref":"1","menu":1,"basekit_objects_ref":null,"modified":"2022-03-24 17:31:21","redirection":null,"priority":0,"changefreq":"monthly","can_publish":1,"headScript":null,"bodyScript":null,"headScriptOptions":[],"bodyScriptOptions":[],"status":"active","theme_ref":1,"color_swatch_ref":1,"font_swatch_ref":1,"password":"","password_enabled":false,"do_sub_page":"0","do_default":"0","templateType":"default","hiddenFromNavigation":1,"exclude_from_sitemap":0,"excludeFromPageLimit":0,"parentId":0,"language":null,"username":null,"linkOpenNewTab":null,"linkNofollow":null},{"ref":105546,"request":"why-you-want-to-be-restrictive-with-shrink-of-database-files","canonicalUrl":null,"title":"Why you want to be restrictive with shrink of database files","seo_title":"","keywords":"","description":"","display_order":13,"type":"page","template_ref":"1","menu":1,"basekit_objects_ref":null,"modified":"2022-03-24 17:31:21","redirection":null,"priority":0,"changefreq":"monthly","can_publish":1,"headScript":null,"bodyScript":null,"headScriptOptions":[],"bodyScriptOptions":[],"status":"active","theme_ref":1,"color_swatch_ref":1,"font_swatch_ref":1,"password":"","password_enabled":false,"do_sub_page":"0","do_default":"0","templateType":"default","hiddenFromNavigation":1,"exclude_from_sitemap":0,"excludeFromPageLimit":0,"parentId":0,"language":null,"username":null,"linkOpenNewTab":null,"linkNofollow":null},{"ref":105547,"request":"recommended-actions-for-corrupt-databases","canonicalUrl":null,"title":"Recommended actions for c
476orrupt databases","seo_title":"","keywords":"","description":"","display_order":14,"type":"page","template_ref":"1","menu":1,"basekit_objects_ref":null,"modified":"2022-03-24 17:31:21","redirection":null,"priority":0,"changefreq":"monthly","can_publish":1,"headScript":null,"bodyScript":null,"headScriptOptions":[],"bodyScriptOptions":[],"status":"active","theme_ref":1,"color_swatch_ref":1,"font_swatch_ref":1,"password":"","password_enabled":false,"do_sub_page":"0","do_default":"0","templateType":"default","hiddenFromNavigation":1,"exclude_from_sitemap":0,"excludeFromPageLimit":0,"parentId":0,"language":null,"username":null,"linkOpenNewTab":null,"linkNofollow":null},{"ref":105548,"request":"minimizing-data-loss-when-accidents-happens","canonicalUrl":null,"title":"Minimizing data loss when accidents happens","seo_title":"","keywords":"","description":"","display_order":15,"type":"page","template_ref":"1","menu":1,"basekit_objects_ref":null,"modified":"2022-03-24 17:31:21","redirection":null,"priority":0,"changefreq":"monthly","can_publish":1,"headScript":null,"bodyScript":null,"headScriptOptions":[],"bodyScriptOptions":[],"status":"active","theme_ref":1,"color_swatch_ref":1,"font_swatch_ref":1,"password":"","password_enabled":false,"do_sub_page":"0","do_default":"0","templateType":"default","hiddenFromNavigation":1,"exclude_from_sitemap":0,"excludeFromPageLimit":0,"parentId":0,"language":null,"username":null,"linkOpenNewTab":null,"linkNofollow":null},{"ref":105521,"request":"spdbinfo-database-space-usage-information","canonicalUrl":null,"title":"sp_dbinfo - database space usage information","seo_title":"","keywords":"","description":"","display_order":16,"type":"page","template_ref":"1","menu":1,"basekit_objects_ref":null,"modified":"2022-03-24 17:31:21","redirection":null,"priority":0,"changefreq":"monthly","can_publish":1,"headScript":null,"bodyScript":null,"headScriptOptions":[],"bodyScriptOptions":[],"status":"active","theme_ref":1,"color_swatch_ref":1,"font_swatch_ref":1,"password":"","password_enabled":false,"do_sub_page":"0","do_default":"0","templateType":"default","hiddenFromNavigation":1,"exclude_from_sitemap":0,"excludeFromPageLimit":0,"parentId":0,"language":null,"username":null,"linkOpenNewTab":null,"linkNofollow":null},{"ref":105522,"request":"sptableinfo-list-tables-and-space-usage","canonicalUrl":null,"title":"sp_tableinfo - list tables and space usage","seo_title":"","keywords":"","description":"","display_order":17,"type":"page","template_ref":"1","menu":1,"basekit_objects_ref":null,"modified":"2022-03-24 17:31:21","redirection":null,"priority":0,"changefreq":"monthly","can_publish":1,"headScript":null,"bodyScript":null,"headScriptOptions":[],"bodyScriptOptions":[],"status":"active","theme_ref":1,"color_swatch_ref":1,"font_swatch_ref":1,"password":"","password_enabled":false,"do_sub_page":"0","do_default":"0","templateType":"default","hiddenFromNavigation":1,"exclude_from_sitemap":0,"excludeFromPageLimit":0,"parentId":0,"language":null,"username":null,"linkOpenNewTab":null,"linkNofollow":null},{"ref":105523,"request":"spindexinfo-enhanced-index-information-procedure","canonicalUrl":null,"title":"sp_indexinfo - enhanced index information procedure","seo_title":"","keywords":"","description":"","display_order":18,"type":"page","template_ref":"1","menu":1,"basekit_objects_ref":null,"modified":"2022-03-24 17:31:21","redirection":null,"priority":0,"changefreq":"monthly","can_publish":1,"headScript":null,"bodyScript":null,"headScriptOptions":[],"bodyScriptOptions":[],"status":"active","theme_ref":1,"color_swatch_ref":1,"font_swatch_ref":1,"password":"","password_enabled":false,"do_sub_page":"0","do_default":"0","templateType":"default","hiddenFromNavigation":1,"exclude_from_sitemap":0,"excludeFromPageLimit":0,"parentId":0,"language":null,"username":null,"linkOpenNewTab":null,"linkNofollow":null},{"ref":105588,"request":"templates-for-xe-profiler","canonicalUrl":null,"title":"Templates for XE Profiler","seo_title":"","keywords":"","description":"","display_order":19,"type":"page","template_ref":"1","menu":1,"basekit_objects_ref":null,"modified":"2022-03-24 17:31:21","redirection":null,"priority":0,"changefreq":"monthly","can_publish":1,"headScript":null,"bodyScript":null,"headScriptOptions":[],"bodyScriptOptions":[],"status":"active","theme_ref":1,"color_swatch_ref":1,"font_swatch_ref":1,"password":"","password_enabled":false,"do_sub_page":"0","do_default":"0","templateType":"default","hiddenFromNavigation":1,"exclude_from_sitemap":0,"excludeFromPageLimit":0,"parentId":0,"language":null,"username":null,"linkOpenNewTab":null,"linkNofollow":null},{"ref":105589,"request":"log-wait-stats-over-time","canonicalUrl":null,"title":"Log wait stats over time","seo_title":"","keywords":"","description":"","display_order":20,"type":"page","template_ref":"1","menu":1,"basekit_objects_ref":null,"modified":"2022-03-24 17:31:21","redirection":null,"priority":0,"changefreq":"monthly","can_publish":1,"headScript":null,"bodyScript":null,"headScriptOptions":[],"bodyScriptOptions":[],"status":"active","theme_ref":1,"color_swatch_ref":1,"font_swatch_ref":1,"password":"","password_enabled":false,"do_sub_page":"0","do_default":"0","templateType":"default","hiddenFromNavigation":1,"exclude_from_sitemap":0,"excludeFromPageLimit":0,"parentId":0,"language":null,"username":null,"linkOpenNewTab":null,"linkNofollow":null},{"ref":105590,"request":"adjust-autogrow-values-for-database-files","canonicalUrl":null,"title":"Adjust autogrow values for database files","seo_title":"","keywords":"","description":"","display_order":21,"type":"page","template_ref":"1","menu":1,"basekit_objects_ref":null,"modified":"2022-03-24 17:31:21","redirection":null,"priority":0,"changefreq":"monthly","can_publish":1,"headScript":null,"bodyScript":null,"headScriptOptions":[],"bodyScriptOptions":[],"status":"active","theme_ref":1,"color_swatch_ref":1,"font_swatch_ref":1,"password":"","password_enabled":false,"do_sub_page":"0","do_default":"0","templateType":"default","hiddenFromNavigation":1,"exclude_from_sitemap":0,"excludeFromPageLimit":0,"parentId":0,"language":null,"username":null,"linkOpenNewTab":null,"linkNofollow":null},{"ref":105591,"request":"log-page-life-expectancy-over-time","canonicalUrl":null,"title":"Log Page Life Expectancy over time","seo_title":"","keywords":"","description":"","display_order":22,"type":"page","template_ref":"1","menu":1,"basekit_objects_ref":null,"modified":"2022-03-24 17:31:21","redirection":null,"priority":0,"changefreq":"monthly","can_publish":1,"headScript":null,"bodyScript":null,"headScriptOptions":[],"bodyScriptOptions":[],"status":"active","theme_ref":1,"color_swatch_ref":1,"font_swatch_ref":1,"password":"","password_enabled":false,"do_sub_page":"0","do_default":"0","templateType":"default","hiddenFromNavigation":1,"exclude_from_sitemap":0,"excludeFromPageLimit":0,"parentId":0,"language":null,"username":null,"linkOpenNewTab":null,"linkNofollow":null},{"ref":105592,"request":"rebuild-all-fragmented-heaps","canonicalUrl":null,"title":"Rebuild all fragmented heaps","seo_title":"","keywords":"","description":"","display_order":23,"type":"page","template_ref":"1","menu":1,"basekit_objects_ref":null,"modified":"2022-03-24 17:31:21","redirection":null,"priority":0,"changefreq":"monthly","can_publish":1,"headScript":null,"bodyScript":null,"headScriptOptions":[],"bodyScriptOptions":[],"status":"active","theme_ref":1,"color_swatch_ref":1,"font_swatch_ref":1,"password":"","password_enabled":false,"do_sub_page":"0","do_default":"0","templateType":"default","hiddenFromNavigation":1,"exclude_from_sitemap":0,"excludeFromPageLimit":0,"parentId":0,"language":null,"username":null,"linkOpenNewTab":null,"linkNofollow":null},{"ref":105593,"request":"pause-random-number-of-minutes-or-seconds","canonicalUrl":null,"title":"Pause random number of minutes or seconds","seo_title":"","keywords":"","description":"","display_order":24,"type":"page","template_ref":"1","menu":1,"basekit_objects_ref":null,"modified":"2022-03-24 17:31:21","redirection":null,"priority":0,"changefreq":"monthly","can_publish":1,"headScript":null,"bodyScript":null,"headScriptOptions":[],"bodyScriptOptions":[],"status":"active","theme_ref":1,"color_swatch_ref":1,"font_swatch_ref":1,"password":"","password_enabled":false,"do_sub_page":"0","do_default":"0","templateType":"default","hiddenFromNavigation":1,"exclude_from_sitemap":0,"excludeFromPageLimit":0,"parentId":0,"language":null,"username":null,"linkOpenNewTab":null,"linkNofollow":null},{"ref":105594,"request":"analyze-sql-server-and-agent-errorlogs","canonicalUrl":null,"title":"Analyze SQL Server and Agent errorlogs","seo_title":"","keywords":"","description":"","display_order":25,"type":"page","template_ref":"1","menu":1,"basekit_objects_ref":null,"modified":"2022-03-24 17:31:21","redirection":null,"priority":0,"changefreq":"monthly","can_publish":1,"headScript":null,"bodyScript":null,"headScriptOptions":[],"bodyScriptOptions":[],"status":"active","theme_ref":1,"color_swatch_ref":1,"font_swatch_ref":1,"password":"","password_enabled":false,"do_sub_page":"0","do_default":"0","templateType":"default","hiddenFromNavigation":1,"exclude_from_sitemap":0,"excludeFromPageLimit":0,"parentId":0,"language":null,"username":null,"linkOpenNewTab":null,"linkNofollow":null},{"ref":105595,"request":"mailafterjob-send-email-after-agent-job-include-ouput-files","canonicalUrl":null,"title":"MailAfterJob - send email after Agent job, include ouput files","seo_title":"","keywords":"","description":"","display_order":26,"type":"page","template_ref":"1","menu":1,"basekit_objects_ref":null,"modified":"2022-03-24 17:31:21","redirection":null,"priority":0,"changefreq":"monthly","can_publish":1,"headScript":null,"bodyScript":null,"headScriptOptions":[],"bodyScriptOptions":[],"status":"active","theme_ref":1,"color_swatch_ref":1,"font_swatch_ref":1,"password":"","password_enabled":false,"do_sub_page":"0","do_default":"0","templateType":"default","hiddenFromNavigation":1,"exclude_from_sitemap":0,"excludeFromPageLimit":0,"parentId":0,"language":null,"username":null,"linkOpenNewTab":null,"linkNofollow":null},{"ref":105596,"request":"agent-alerts-management-pack","canonicalUrl":null,"title":"Agent Alerts Management Pack","seo_title":"","keywords":"","description":"","display_order":27,"type":"page","template_ref":"1","menu":1,"basekit_objects_ref":null,"modified":"2022-03-24 17:31:21","redirection":null,"priority":0,"changefreq":"monthly","can_publish":1,"headScript":null,"bodyScript":null,"headScriptOptions":[],"bodyScriptOptions":[],"status":"active","theme_ref":1,"color_swatch_ref":1,"font_swatch_ref":1,"password":"","password_enabled":false,"do_sub_page":"0","do_default":"0","templateType":"default","hiddenFromNavigation":1,"exclude_from_sitemap":0,"excludeFromPageLimit":0,"parentId":0,"language":null,"username":null,"linkOpenNewTab":null,"linkNofollow":null},{"ref":105597,"request":"tsql-script-to-create-backup-file-including-database-name-date-and-time","canonicalUrl":null,"title":"TSQL script to create backup file including database name, date and time","seo_title":"","keywords":"","description":"","display_order":28,"type":"page","template_ref":"1","menu":1,"basekit_objects_ref":null,"modified":"2022-03-24 17:31:21","redirection":null,"priority":0,"changefreq":"monthly","can_publish":1,"headScript":null,"bodyScript":null,"headScriptOptions":[],"bodyScriptOptions":[],"status":"active","theme_ref":1,"color_swatch_ref":1,"font_swatch_ref":1,"password":"","password_enabled":false,"do_sub_page":"0","do_default":"0","templateType":"default","hiddenFromNavigation":1,"exclude_from_sitemap":0,"excludeFromPageLimit":0,"parentId":0,"language":null,"username":null,"linkOpenNewTab":null,"linkNofollow":null},{"ref":105598,"request":"restore-all-databases-from-a-number-of-backup-files","canonicalUrl":null,"title":"Restore all databases from a number of backup files","seo_title":"","keywords":"","description":"","display_order":29,"type":"page","template_ref":"1","menu":1,"basekit_objects_ref":null,"modified":"2022-03-24 17:31:21","redirection":null,"priority":0,"changefreq":"monthly","can_publish":1,"headScript":null,"bodyScript":null,"headScriptOptions":[],"bodyScriptOptions":[],"status":"active","theme_ref":1,"color_swatch_ref":1,"font_swatch_ref":1,"password":"","password_enabled":false,"do_sub_page":"0","do_default":"0","templateType":"default","hiddenFromNavigation":1,"exclude_from_sitemap":0,"excludeFromPageLimit":0,"parentId":0,"language":null,"username":null,"linkOpenNewTab":null,"linkNofollow":null},{"ref":105599,"request":"list-candidates-for-sparse-columns","canonicalUrl":null,"title":"List candidates for sparse columns","seo_title":"","keywords":"","description":"","display_order":30,"type":"page","template_ref":"1","menu":1,"basekit_objects_ref":null,"modified":"2022-03-24 17:31:21","redirection":null,"priority":0,"changefreq":"monthly","can_publish":1,"headScript":null,"bodyScript":null,"headScriptOptions":[],"bodyScriptOptions":[],"status":"active","theme_ref":1,"color_swatch_ref":1,"font_swatch_ref":1,"password":"","password_enabled":false,"do_sub_page":"0","do_default":"0","templateType":"default","hiddenFromNavigation":1,"exclude_from_sitemap":0,"excludeFromPageLimit":0,"parentId":0,"language":null,"username":null,"linkOpenNewTab":null,"linkNofollow":null},{"ref":105600,"request":"running-shoes","canonicalUrl":null,"title":"Running shoes","seo_title":"","keywords":"","description":"","display_order":31,"type":"page","template_ref":"1","menu":1,"basekit_objects_ref":null,"modified":"2022-03-24 17:31:21","redirection":null,"priority":0,"changefreq":"monthly","can_publish":1,"headScript":null,"bodyScript":null,"headScriptOptions":[],"bodyScriptOptions":[],"status":"active","theme_ref":1,"color_swatch_ref":1,"font_swatch_ref":1,"password":"","password_enabled":false,"do_sub_page":"0","do_default":"0","templateType":"default","hiddenFromNavigation":1,"exclude_from_sitemap":0,"excludeFromPageLimit":0,"parentId":0,"language":null,"username":null,"linkOpenNewTab":null,"linkNofollow":null},{"ref":105813,"request":"kursmaterial-skillpipe","canonicalUrl":null,"title":"Kursmaterial Skillpipe","seo_title":"","keywords":"","description":"","display_order":33,"type":"page","template_ref":"1","menu":1,"basekit_objects_ref":null,"modified":"2022-03-24 17:31:21","redirection":null,"priority":0,"changefreq":"monthly","can_publish":1,"headScript":null,"bodyScript":null,"headScriptOptions":[],"bodyScriptOptions":[],"status":"active","theme_ref":1,"color_swatch_ref":1,"font_swatch_ref":1,"password":"","password_enabled":false,"do_sub_page":"0","do_default":"0","templateType":"default","hiddenFromNavigation":1,"exclude_from_sitemap":0,"excludeFromPageLimit":0,"parentId":0,"language":null,"username":null,"linkOpenNewTab":null,"linkNofollow":null},{"ref":135591,"request":"new-in-version-x","canonicalUrl":null,"title":"What's new in SQL Server","seo_title":"","keywords":"","description":"","display_order":34,"type":"page","template_ref":"1","menu":1,"basekit_objects_ref":null,"modified":"2022-05-19 15:08:42","redirection":null,"priority":0,"changefreq":"monthly","can_publish":1,"headScript":null,"bodyScript":null,"headScriptOptions":[],"bodyScriptOptions":[],"status":"active","theme_ref":1,"color_swatch_ref":1,"font_swatch_ref":1,"password":"","password_enabled":false,"do_sub_page":"0","do_default":"0","templateType":"default","hiddenFromNavigation":1,"exclude_from_sitemap":0,"excludeFromPageLimit":0,"parentId":0,"language":null,"username":null,"linkOpenNewTab":null,"linkNofollow":null},{"ref":216332,"request":"looking-for-strange","canonicalUrl":null,"title":"Looking for strange","seo_title":"","keywords":"","description":"","display_order":35,"type":"page","template_ref":"1","menu":1,"basekit_objects_ref":null,"modified":"2022-03-24 17:31:21","redirection":null,"priority":0,"changefreq":"monthly","can_publish":1,"headScript":null,"bodyScript":null,"headScriptOptions":[],"bodyScriptOptions":[],"status":"active","theme_ref":1,"color_swatch_ref":1,"font_swatch_ref":1,"password":"","password_enabled":false,"do_sub_page":"0","do_default":"0","templateType":"default","hiddenFromNavigation":1,"exclude_from_sitemap":0,"excludeFromPageLimit":0,"parentId":0,"language":null,"username":null,"linkOpenNewTab":null,"linkNofollow":null},
476{"ref":377724,"request":"tack-f\u00f6r-denna-g\u00e5ng","canonicalUrl":null,"title":"Tack f\u00f6r denna g\u00e5ng","seo_title":"","keywords":"","description":"","display_order":36,"type":"page","template_ref":"1","menu":1,"basekit_objects_ref":null,"modified":"2022-03-24 17:31:21","redirection":null,"priority":0,"changefreq":"monthly","can_publish":1,"headScript":null,"bodyScript":null,"headScriptOptions":[],"bodyScriptOptions":[],"status":"active","theme_ref":1,"color_swatch_ref":1,"font_swatch_ref":1,"password":"","password_enabled":false,"do_sub_page":"0","do_default":"0","templateType":"default","hiddenFromNavigation":1,"exclude_from_sitemap":0,"excludeFromPageLimit":0,"parentId":0,"language":null,"username":null,"linkOpenNewTab":null,"linkNofollow":null},{"ref":105504,"request":"blog","canonicalUrl":null,"title":"SQL Server blog","seo_title":"","keywords":null,"description":null,"display_order":37,"type":"page","template_ref":"1","menu":1,"basekit_objects_ref":null,"modified":"2022-03-24 17:31:21","redirection":null,"priority":0,"changefreq":"monthly","can_publish":1,"headScript":null,"bodyScript":null,"headScriptOptions":[],"bodyScriptOptions":[],"status":"active","theme_ref":1,"color_swatch_ref":1,"font_swatch_ref":1,"password":"","password_enabled":false,"do_sub_page":"0","do_default":"0","templateType":"blogpostlist","hiddenFromNavigation":0,"exclude_from_sitemap":1,"excludeFromPageLimit":1,"parentId":0,"language":null,"username":null,"linkOpenNewTab":null,"linkNofollow":null},{"ref":420179,"request":"my-students-page","canonicalUrl":null,"title":"Only for Tibor's students","seo_title":"","keywords":"","description":"","display_order":38,"type":"page","template_ref":"1","menu":1,"basekit_objects_ref":null,"modified":"2022-10-12 15:51:50","redirection":null,"priority":0,"changefreq":"monthly","can_publish":1,"headScript":null,"bodyScript":null,"headScriptOptions":[],"bodyScriptOptions":[],"status":"active","theme_ref":1,"color_swatch_ref":1,"font_swatch_ref":1,"password":"","password_enabled":false,"do_sub_page":"0","do_default":"0","templateType":"default","hiddenFromNavigation":1,"exclude_from_sitemap":0,"excludeFromPageLimit":0,"parentId":0,"language":null,"username":null,"linkOpenNewTab":null,"linkNofollow":null}],"requestBase":"","cookieWarningUrl":"","plugins":{"assets":{"images":{"238424":{"ref":238424,"url":"http:\/\/files.site.surftown.com\/d9\/07\/d90754b7-a541-4cfc-853d-260913091a52.JPG","fileName":"TiborKaraszi.JPG","fileType":"image","fileSize":63661,"title":null,"updated":{"date":"2017-10-30 11:06:12.000000","timezone_type":3,"timezone":"Europe\/London"},"description":null,"path":"d9\/07\/d90754b7-a541-4cfc-853d-260913091a52.JPG","imageWidth":640,"imageHeight":480,"deleted":false,"albumRef":null,"albumTitle":null,"providerRef":null,"compression":"complete","compressedUrl":"http:\/\/files.site.surftown.com\/9a\/a4\/9aa41bd5-d030-487a-912a-5309b9ba977a.jpg"},"238425":{"ref":238425,"url":"http:\/\/files.site.surftown.com\/83\/89\/8389a697-b1ae-456d-b998-2ec4abd803d3.jpg","fileName":"c51bab1d-a1c1-4dab-b30a-5f4aa580ee1d.jpg","fileType":"image","fileSize":44680,"title":null,"updated":{"date":"2017-10-30 11:06:47.000000","timezone_type":3,"timezone":"Europe\/London"},"description":null,"path":"83\/89\/8389a697-b1ae-456d-b998-2ec4abd803d3.jpg","imageWidth":640,"imageHeight":480,"deleted":false,"albumRef":null,"albumTitle":null,"providerRef":null,"compression":"none","compressedUrl":null},"238436":{"ref":238436,"url":"http:\/\/files.site.surftown.com\/f1\/5a\/f15ad5a6-ce7b-4d1a-abf1-67d85005d35f.png","fileName":"icons8-database.png","fileType":"image","fileSize":1264,"title":null,"updated":{"date":"2017-10-30 11:52:47.000000","timezone_type":3,"timezone":"Europe\/London"},"description":null,"path":"f1\/5a\/f15ad5a6-ce7b-4d1a-abf1-67d85005d35f.png","imageWidth":50,"imageHeight":50,"deleted":false,"albumRef":null,"albumTitle":null,"providerRef":null,"compression":"none","compressedUrl":null},"238437":{"ref":238437,"url":"http:\/\/files.site.surftown.com\/c2\/fc\/c2fcb728-695b-4524-997c-007ba1986da5.jpg","fileName":"TiborCornerstone.jpg","fileType":"image","fileSize":68620,"title":null,"updated":{"date":"2017-10-30 11:56:37.000000","timezone_type":3,"timezone":"Europe\/London"},"description":null,"path":"c2\/fc\/c2fcb728-695b-4524-997c-007ba1986da5.jpg","imageWidth":500,"imageHeight":334,"deleted":false,"albumRef":null,"albumTitle":null,"providerRef":null,"compression":"complete","compressedUrl":"http:\/\/files.site.surftown.com\/04\/f3\/04f35a44-d91f-43f9-b81b-ba631ff0ed60.jpg"},"238457":{"ref":238457,"url":"http:\/\/files.site.surftown.com\/98\/48\/9848ac95-b472-4ede-a7ba-f626c2a6db9e.jpg","fileName":"TiborCornerstone.jpg","fileType":"image","fileSize":68620,"title":null,"updated":{"date":"2017-10-30 12:24:22.000000","timezone_type":3,"timezone":"Europe\/London"},"description":null,"path":"98\/48\/9848ac95-b472-4ede-a7ba-f626c2a6db9e.jpg","imageWidth":500,"imageHeight":334,"deleted":false,"albumRef":null,"albumTitle":null,"providerRef":null,"compression":"complete","compressedUrl":"http:\/\/files.site.surftown.com\/b5\/d9\/b5d91904-41d0-4514-a370-ffa9da7fdff4.jpg"},"238459":{"ref":238459,"url":"http:\/\/files.site.surftown.com\/3f\/ed\/3fed4d0e-9085-4eb8-bc14-de32a1d04522.jpg","fileName":"TiborCornerstoneBred.jpg","fileType":"image","fileSize":46302,"title":null,"updated":{"date":"2017-10-30 12:29:37.000000","timezone_type":3,"timezone":"Europe\/London"},"description":null,"path":"3f\/ed\/3fed4d0e-9085-4eb8-bc14-de32a1d04522.jpg","imageWidth":499,"imageHeight":281,"deleted":false,"albumRef":null,"albumTitle":null,"providerRef":null,"compression":"none","compressedUrl":null},"238894":{"ref":238894,"url":"http:\/\/files.site.surftown.com\/11\/b8\/11b8d106-62f9-47fd-b6bd-fa29005e33cd.jpg","fileName":"forest-1208296_1920.jpg","fileType":"image","fileSize":762348,"title":null,"updated":{"date":"2017-10-31 10:08:41.000000","timezone_type":3,"timezone":"Europe\/London"},"description":null,"path":"11\/b8\/11b8d106-62f9-47fd-b6bd-fa29005e33cd.jpg","imageWidth":1920,"imageHeight":1281,"deleted":false,"albumRef":null,"albumTitle":null,"providerRef":null,"compression":"complete","compressedUrl":"http:\/\/files.site.surftown.com\/ca\/91\/ca91d096-ba62-4c96-9b2a-09c866e9ebc5.jpg"},"238902":{"ref":238902,"url":"http:\/\/files.site.surftown.com\/8d\/81\/8d816fa3-9e8b-4c6b-a88a-877b37fc4d14.jpg","fileName":"forest-1208296_1920.jpg","fileType":"image","fileSize":762348,"title":null,"updated":{"date":"2017-10-31 10:42:40.000000","timezone_type":3,"timezone":"Europe\/London"},"description":null,"path":"8d\/81\/8d816fa3-9e8b-4c6b-a88a-877b37fc4d14.jpg","imageWidth":1920,"imageHeight":1281,"deleted":false,"albumRef":null,"albumTitle":null,"providerRef":null,"compression":"complete","compressedUrl":"http:\/\/files.site.surftown.com\/4f\/18\/4f18640f-1781-4f38-bf91-a8a0251b1fa7.jpg"},"239647":{"ref":239647,"url":"http:\/\/files.site.surftown.com\/85\/07\/850773a2-38a5-4164-b34f-5f6c95d3901c.png","fileName":"mvp.png","fileType":"image","fileSize":5075,"title":null,"updated":{"date":"2017-11-01 15:28:55.000000","timezone_type":3,"timezone":"Europe\/London"},"description":null,"path":"85\/07\/850773a2-38a5-4164-b34f-5f6c95d3901c.png","imageWidth":182,"imageHeight":74,"deleted":false,"albumRef":null,"albumTitle":null,"providerRef":null,"compression":"none","compressedUrl":null},"1052160":{"ref":1052160,"url":"http:\/\/files.builder.nu\/6c\/2d\/6c2d43b3-8784-4fa4-beb5-fb41ad0f0567.jpg","fileName":"boy-playing-trumpet.jpg","fileType":"image","fileSize":1622493,"title":null,"updated":{"date":"2022-03-24 17:24:55.000000","timezone_type":3,"timezone":"Europe\/London"},"description":null,"path":"6c\/2d\/6c2d43b3-8784-4fa4-beb5-fb41ad0f0567.jpg","imageWidth":2120,"imageHeight":1414,"deleted":false,"albumRef":null,"albumTitle":null,"providerRef":1,"compression":"complete","compressedUrl":"http:\/\/files.builder.nu\/e4\/83\/e48391d5-5809-4ffc-86d5-4c21c3470b2f.jpeg"},"1052161":{"ref":1052161,"url":"http:\/\/files.builder.nu\/61\/69\/61697970-7540-4322-8b31-6270773b23c9.jpg","fileName":"student-standing-on-steps-outdoors.jpg","fileType":"image","fileSize":1428565,"title":null,"updated":{"date":"2022-03-24 17:25:26.000000","timezone_type":3,"timezone":"Europe\/London"},"description":null,"path":"61\/69\/61697970-7540-4322-8b31-6270773b23c9.jpg","imageWidth":2000,"imageHeight":1499,"deleted":false,"albumRef":null,"albumTitle":null,"providerRef":1,"compression":"complete","compressedUrl":"http:\/\/files.builder.nu\/ec\/94\/ec943bd0-b985-4c4e-96ea-f66462825772.jpeg"},"1052163":{"ref":1052163,"url":"http:\/\/files.builder.nu\/31\/07\/310745f1-dc56-462b
476-a504-515320a56bd0.jpg","fileName":"student-standing-on-steps-outdoors.jpg","fileType":"image","fileSize":167341,"title":null,"updated":{"date":"2022-03-24 17:26:08.000000","timezone_type":3,"timezone":"Europe\/London"},"description":null,"path":"31\/07\/310745f1-dc56-462b-a504-515320a56bd0.jpg","imageWidth":1633,"imageHeight":1224,"deleted":false,"albumRef":null,"albumTitle":null,"providerRef":null,"compression":"complete","compressedUrl":"http:\/\/files.builder.nu\/fb\/95\/fb95449e-1b74-479e-9ab0-37fb0a9742a5.jpeg"}},"albums":{"":[238424,238424,238425,238425,238436,238436,238437,238437,238457,238457,238459,238459,238894,238894,238902,238902,239647,239647,1052160,1052160,1052161,1052161,1052163,1052163]}},"blog":{"live":false,"isPostPage":false,"searchUrl":"\/blog\/search\/","directory":"blog","displayBlogHomePageLink":false,"categories":[],"tags":[],"postsPerPage":5,"totalPages":0,"currentPage":1,"pathFormat":"\/blog\/page\/"}},"desktopSite":{"protocol":"https","primaryDomain":{"domainName":"karaszi.com"}},"siteLanguages":null,"siteDefaultLanguage":null,"siteLanguageMenuSettings":null,"siteCurrentLanguage":null}; 477window["Profile"] = {"profile":{"business":"","headline":"","strapline":"","companydescription":"","copyright":"","address":"","address1":"","address2":"","postalcode":"","country":"","phone":"","twitter":"surftown","linkedin":"https:\/\/www.linkedin.com\/company\/surftown","facebook":"https:\/\/www.facebook.com\/surftown.com\/","googleplus":"https:\/\/plus.google.com\/+Surftowncom","youtube":"https:\/\/www.youtube.com\/user\/Surftowncom","rss":"http:\/\/blog.surftown.dk\/feed\/","logo":"","logowidth":"","logoheight":"","yelpbusinessid":"surftown-k%C3%B8benhavn","featureimage":"http:\/\/files.site.surftown.com\/8d\/81\/8d816fa3-9e8b-4c6b-a88a-877b37fc4d14.jpg","category":"","keywords":"","type":""}}; 478</script>
478 479
480<script nonce=""> 481 Server.components = {"page-zones__main":{"ref":368398,"uniqueHTMLId":"page-zones__main","name":"main","fixed":false,"libraryItemRef":0,"pageRef":105507,"temporary":{},"changed":{},"type":"widget.template","data":[],"className":"template","widget":{},"uniqueId":"CzN2Kcu0CmOfuWp","parentUniqueId":null},"page-zones__main-widgets__59f70c1d25f5b":{"ref":368399,"uniqueHTMLId":"page-zones__main-widgets__59f70c1d25f5b","name":"59f70c1d25f5b","fixed":false,"libraryItemRef":0,"pageRef":105507,"temporary":{},"changed":{},"type":"widget.content","data":{"type":"widget.content","content":"<p>\n\nHere you find articles, tips and utilities I have written. Unlike blog posts, I <b>do<\/b> modify these from time to time. There is update history in each article, and for the more recently updated and new articles you find a visual indication on this page.\n\n<\/p><p>\n\n<span class=\"wysiwyg-font-size-small\"><span class=\"wysiwyg-font-size-large\">Articles<\/span><br><\/span><\/p><ul><li><span class=\"wysiwyg-font-size-small\"><a href=\"\/new-in-version-x\" target=\"_self\">What's new in version X<\/a><\/span><\/li><li><span class=\"wysiwyg-font-size-small\"><a href=\"\/checklist-for-sql-server-implementations\" target=\"_self\">Checklist for SQL Server implementations<\/a><\/span><\/li><li><span class=\"wysiwyg-font-size-small\"><a href=\"\/the-ultimate-guide-to-the-datetime-datatypes\" target=\"_self\">The ultimate guide to the datetime datatypes<\/a><\/span><\/li><li><span class=\"wysiwyg-font-size-small\"><a href=\"\/moving-a-database-between-two-sql-server-instances\" target=\"_self\">Moving a database between two SQL Server instances<\/a><\/span><\/li><li><span class=\"wysiwyg-font-size-small\"><a href=\"\/large-transaction-log-file\" target=\"_self\">Large transaction log file<\/a><\/span><\/li><li><span class=\"wysiwyg-font-size-small\"><a href=\"\/why-you-want-to-be-restrictive-with-shrink-of-database-files\" target=\"_self\">Why you want to be restrictive with shrink of database files<\/a><\/span><\/li><li><span class=\"wysiwyg-font-size-small\"><a href=\"\/recommended-actions-for-corrupt-databases\" target=\"_self\">Recommended actions for corrupt or suspect databases<\/a><\/span><\/li><li><span class=\"wysiwyg-font-size-small\"><a href=\"\/minimizing-data-loss-when-accidents-happens\" target=\"_self\">Minimizing data loss when accidents happens<\/a><\/span><\/li><\/ul><br><span class=\"wysiwyg-font-size-large\">Utilities<\/span><br><ul><li><a href=\"\/spdbinfo-database-space-usage-information\" target=\"_self\">sp_dbinfo - database space usage information<\/a><\/li><li><a href=\"\/sptableinfo-list-tables-and-space-usage\" target=\"_self\">sp_tableinfo - list tables and space usage<\/a><\/li><li><a href=\"\/spindexinfo-enhanced-index-information-procedure\" target=\"_self\">sp_indexinfo - enhanced index information procedure <b>(updated)<\/b><\/a> <\/li><\/ul><br><ul><li><a href=\"\/looking-for-strange\" target=\"_self\">Looking for strange<\/a><\/li><li><a href=\"\/templates-for-xe-profiler\" target=\"_self\">Templates for XE Profiler<\/a><b><span style=\"color: rgb(192, 80, 77);\"> <\/span><\/b><\/li><li><a href=\"\/log-wait-stats-over-time\" target=\"_self\">Log wait statistics over time<\/a><\/li><li><a href=\"\/adjust-autogrow-values-for-database-files\" target=\"_self\">Adjust autogrow setting to reasonable size<\/a><\/li><li><a href=\"\/log-page-life-expectancy-over-time\" target=\"_self\">Log Page Life Expectency over time<\/a><\/li><li><a href=\"\/rebuild-all-fragmented-heaps\" target=\"_self\">Rebuild all fragmented heaps on a SQL Server<\/a><\/li><li><a href=\"\/pause-random-number-of-minutes-or-seconds\" target=\"_self\">Pause random number of minutes or seconds<\/a><\/li><li><a href=\"\/analyze-sql-server-and-agent-errorlogs\" target=\"_self\">Analyze SQL Server and Agent errorlogs<\/a><\/li><li><a href=\"\/mailafterjob-send-email-after-agent-job-include-ouput-files\" target=\"_self\">MailAfterJob - send email after Agent job, with status in mail subject and output files attached<\/a><\/li><li><a href=\"\/agent-alerts-management-pack\" target=\"_self\">Agent Alerts Management Pack<\/a><\/li><li><a href=\"\/tsql-script-to-create-backup-file-including-database-name-date-and-time\" target=\"_self\">TSQL script to create backup file including database name, date and time<\/a><\/li><li><a href=\"\/restore-all-databases-from-a-number-of-backup-files\" target=\"_self\">Restore all databases from a number of backup files in a directory<\/a><\/li><li><a href=\"\/list-candidates-for-sparse-columns\" target=\"_self\">List column candidates for SPARSE - potential space savings<\/a>\n\n<\/li><\/ul><p><\/p>","localClass":"widget-content-P322Q3","uniqueId":"MgD54mkKKuuSBh0"},"className":"content","widget":{},"uniqueId":"MgD54mkKKuuSBh0","parentUniqueId":"CzN2Kcu0CmOfuWp"},"page-zones__template-widgets__companyname-companyname":{"debugMode":false,"enablePolicyPages":false,"ref":null,"uniqueHTMLId":"page-zones__template-widgets__companyname-companyname","name":"companyname-companyname","fixed":true,"libraryItemRef":null,"pageRef":null,"temporary":{},"changed":{},"type":"widget.companyname","data":{"business":"profile","preset":null,"presetRef":null,"uniqueId":null,"companyname":"Tibor Karaszi's SQL Server pages"},"className":"companyname","widget":{},"uniqueId":null,"parentUniqueId":null},"page-zones__template-widgets__extendednavigation-extendednavigation":{"debugMode":false,"enablePolicyPages":false,"ref":null,"uniqueHTMLId":"page-zones__template-widgets__extendednavigation-extendednavigation","name":"extendednavigation-extendednavigation","fixed":true,"libraryItemRef":null,"pageRef":null,"temporary":{},"changed":{},"type":"widget.extendednavigation","data":{"align":"right","preset":null,"presetRef":null,"uniqueId":null,"showTplWidget":"1"},"className":"extendednavigation","widget":{},"uniqueId":null,"parentUniqueId":null},"page-zones__template-widgets__pagetitle-title":{"debugMode":false,"enablePolicyPages":false,"ref":null,"uniqueHTMLId":"page-zones__template-widgets__pagetitle-title","name":"pagetitle-title","fixed":true,"libraryItemRef":null,"pageRef":null,"temporary":{},"changed":{},"type":"widget.pagetitle","data":{"preset":null,"presetRef":null,"uniqueId":null,"showTplWidget":"1"},"className":"pagetitle","widget":{},"uniqueId":null,"parentUniqueId":null},"page-zones__template-widgets__profile-profile2":{"debugMode":false,"enablePolicyPages":false,"ref":null,"uniqueHTMLId":"page-zones__template-widgets__profile-profile2","name":"profile-profile2","fixed":true,"libraryItemRef":null,"pageRef":null,"temporary":{},"changed":{},"type":"widget.profile","data":{"profileType":"copyright","preset":null,"presetRef":null,"uniqueId":null,"address":"profile","address1":"profile","address2":"profile","country":"profile","addressPostalCode":"profile","headline":"profile","stra
481pline":"profile","companydescription":"profile","phone":"profile","business":"profile","copyright":"Copyright Tibor Karaszi","twitter":"profile","defaultTwitter":"BaseKit","mapZoom":"12","mapHeight":"200","mapAddress":"profile","mapAddress1":"profile","mapAddress2":"profile","mapPostalCode":"profile","markerPath":"\/apps\/images\/mobile\/map-marker.png","formText":"Skicka","socialIconsLinkedin":"profile","socialIconsTwitter":"profile","socialIconsFacebook":"profile","socialIconsInstagram":"profile","socialIconsPinterest":"profile","socialIconsRss":"profile","socialIconsGoogleplus":"profile","socialIconsYoutube":"profile","showTplWidget":"1"},"className":"profile","widget":{},"uniqueId":null,"parentUniqueId":null}}; 482 Server.desktopSite.getPrimaryDomainData = function () 483 { 484 var keys = [], 485 key = null, 486 domain = null; 487 488 if (this.primaryDomain !== null) 489 { 490 domain = this.primaryDomain.domainName; 491 } 492 else 493 { 494 bk$.each(this.domains, function(key) 495 { 496 keys.push(parseInt(key, 10)); 497 }); 498 499 key = Math.max.apply(null, keys); 500 domain = this.domains[key] || null; 501 } 502 503 return { 504 key : key, 505 domain: domain 506 }; 507 }; 508 Server.desktopSite.getPrimaryDomain = function () 509 { 510 return this.getPrimaryDomainData().domain; 511 }; 512 Server.customWidgetsDomain = ''; 513 Server.customWidgetVersions = null; 514 Server.connect = {}; 515 Server.connect.bookings = {}; 516 Server.connect.bookings.activeServices = null; 517 Server.connect.bookings.service = null; 518 Server.packageCapabilities = {"liveSites":"1","allowUsers":"0","cdnEnabled":"0","cssEditing":"1","themeLevel":"1","freeDomains":"0","htmlEditing":"1","pagesLimited":"9999","storageLimit":"21474836480","templateTier":"2","domainMapping":"0","googleAnalytics":"1","ecommerceAllowed":"1","googleAdWordVoucher":"0","allowExternalRedirects":"1","allowTemplateSave":"0","mailboxes":"0","mobile":"0","mobileSites":"0","mobilePublishing":"0","restrictPagesOnPublish":"0","templatesAllowed":"1","templatesAllowedV10S":0,"developerModeAllowed":"1","imageEditing":"1","imageCredits":"5","seoAndRedirects":"1","facebookPublish":"0","stockImages":"1","cancellationResistantSites":"0","designTab":"0","ecommerceProductsRestricted":"0","ecommerceProducts":"0","tryNewEditor":"0","tryNewEditorButton":"0","triggersSiteSwitch":"0","onboardingFacebookAuth":"0","onboardingFacebookImport":"0","siteAnalytics":"0","hideFacebookImageImport":"0","createUsersInV8":"0","migrateUsersToV8":"0","offerV8Migration":"0","autoSslProvisioning":"1","compressUploadedImages":"0","disableV8SiteAndPageScripts":"0","enableDragAndDropWidgets":1,"enableGridLayoutSections":0,"disableV8HtmlEditing":"0","securityManagePage":"1","hstsSecurityPage":"0","enableSiteCspHeader":"0","multiLanguageSite":"1","multiLanguageLimit":"5","enableRows":0,"manageApiAccessTokens":"0","supportLiveChatEnabled":"0","createUsersInV10":0,"forceUpgradeV6UsersToResponsive":0,"genericUseButtonLabel":"","genericUseButtonUrl":"","openGenericUseUrlInNewTab":0,"connectBookingsMaxSyncedCalendars":0,"connectBookingsMaxBookings":0,"enableEcwid":0,"enableStandaloneMode":0,"sendCloudIntegration":0,"zapierIntegration":0,"canadaPostIntegration":0,"aiProductDescriptionTextGen":0,"aiCopyWriterTextGen":0,"enableAtarim":0}; 519</script>
519 520
521<script src="//55b558c7-resources.builder.nu/256fb0e/sv/translations.js?sections=widgets,mobile,shared_views,shared_components"></script>
521 522 523 524
524<script src="https://55b558c7-resources.builder.nu/ea42165d20/compiled/published-v8-site-libs.js"></script>
524 525 526
526<script src="https://55b558c7-resources.builder.nu/ea42165d20/compiled/published-v8-site.js"></script>
526 527 528
529<script src="https://55b558c7-resources.builder.nu/ea42165d20/compiled/twig-widget-views-v2.js"></script>
529 530 531
532<script nonce=""> 533(function () { 534 535 fallback = 1; 536 537 if (!'localStorage' in window || 538 !'querySelectorAll' in window || 539 !'addEventListener' in window 540 ) { 541 return; 542 } 543 544 function getFormat(ua) { 545 if (ua.indexOf('android') > -1 && ua.indexOf('chrome') === -1) { 546 return 'ttf'; 547 } 548 549 return 'woff'; 550 } 551 552 function removeObsoleteFontsFromStorage(storageKey) { 553 var prefix; 554 555 if (!window.localStorage) { 556 return; 557 } 558 559 prefix = storageKey + '.' + window.localStorage.getItem('bk.webfonts.format'); 560 try { 561 for (key in window.localStorage) { 562 if (key.indexOf(storageKey) === 0) { 563 removeStorageItem(key, prefix) 564 } 565 } 566 } catch (ex) { 567 } 568 } 569 570 function removeStorageItem(storageKey, prefix) { 571 var font, 572 remove = true, 573 fontCollections = document.head.querySelectorAll('.js-webfont'); 574 575 for (var i = fontCollections.length - 1; i >= 0; --i) { 576 font = prefix + '.' + fontCollections[i].getAttribute('data-name'); 577 if (storageKey.indexOf(font) === 0) { 578 remove = false; 579 } 580 } 581 582 if (remove == true) { 583 try { 584 window.localStorage.removeItem(storageKey); 585 } catch (ex) { 586 } 587 } 588 } 589 590 function loadFontAsynchronously(fontUrl) { 591 var head = document.getElementsByTagName('head')[0], 592 link = document.createElement('link'); 593 594 link.rel = 'stylesheet'; 595 link.href = fontUrl; 596 head.appendChild(link); 597 } 598 599 window.addEventListener('load', function () { 600 var i, 601 localKey = 'published', 602 storageKey = 'bk.webfonts.' + localKey, 603 format, 604 fontCollections, 605 collection, 606 request; 607 608 removeObsoleteFontsFromStorage(storageKey); 609 610 fontCollections = document.head.querySelectorAll('.js-webfont:not([data-cache-full="data-cache-full"])'); 611 if (fontCollections.length === 0) { 612 return; 613 } 614 615 format = getFormat(navigator.userAgent); 616 try { 617 window.localStorage.setItem('bk.webfonts.format', format); 618 } catch (ex) { 619 } 620 621 for (i = fontCollections.length - 1; i >= 0; --i) { 622 fontCollection = fontCollections[i]; 623 (function(collection) { 624 var json, 625 font, 626 content, 627 fonts = []; 628 629 request = new XMLHttpRequest(); 630 request.open('GET', collection.getAttribute('data-' + format + '-cache'), true); 631 request.onload = function () { 632 if (this.status === 200) { 633 try { 634 635 json = JSON.parse(this.response); 636 for (font = json.length - 1; font >= 0; --font) { 637 fonts.push(json[font].css); 638 } 639 content = fonts.join(''); 640 collection.innerHTML = content; 641 window.localStorage.setItem( 642 storageKey + '.' + format + '.' + collection.getAttribute('data-name'), content 643 ); 644 collection.setAttribute('data-cache-full', 'data-cache-full'); 645 } catch (ex) { 646 } 647 } 648 649 if (fallback && this.status === 404) { 650 loadFontAsynchronously(collection.getAttribute('data-fallback-stylesheet')); 651 } 652 }; 653 request.send(); 654 })(fontCollection); 655 } 656 }, false); 657}()); 658</script>
658 659 660
660<script nonce=""> 661 (function () { 662 Server.widgetsOnPage = [{"className":"template","data":{},"fixed":false,"isInRow":false,"isNew":false,"isTemplateWidget":false,"name":"main","pageRef":105507,"parentUniqueId":null,"ref":368398,"type":"widget.template","uniqueHTMLId":"page-zones__main","uniqueId":"CzN2Kcu0CmOfuWp","isZone":true,"parentZone":null,"zoneName":"main"},{"className":"content","data":{"type":"widget.content","content":"<p>\n\nHere you find articles, tips and utilities I have written. Unlike blog posts, I <b>do<\/b> modify these from time to time. There is update history in each article, and for the more recently updated and new articles you find a visual indication on this page.\n\n<\/p><p>\n\n<span class=\"wysiwyg-font-size-small\"><span class=\"wysiwyg-font-size-large\">Articles<\/span><br><\/span><\/p><ul><li><span class=\"wysiwyg-font-size-small\"><a href=\"\/new-in-version-x\" target=\"_self\">What's new in version X<\/a><\/span><\/li><li><span class=\"wysiwyg-font-size-small\"><a href=\"\/checklist-for-sql-server-implementations\" target=\"_self\">Checklist for SQL Server implementations<\/a><\/span><\/li><li><span class=\"wysiwyg-font-size-small\"><a href=\"\/the-ultimate-guide-to-the-datetime-datatypes\" target=\"_self\">The ultimate guide to the datetime datatypes<\/a><\/span><\/li><li><span class=\"wysiwyg-font-size-small\"><a href=\"\/moving-a-database-between-two-sql-server-instances\" target=\"_self\">Moving a database between two SQL Server instances<\/a><\/span><\/li><li><span class=\"wysiwyg-font-size-small\"><a href=\"\/large-transaction-log-file\" target=\"_self\">Large transaction log file<\/a><\/span><\/li><li><span class=\"wysiwyg-font-size-small\"><a href=\"\/why-you-want-to-be-restrictive-with-shrink-of-database-files\" target=\"_self\">Why you want to be restrictive with shrink of database files<\/a><\/span><\/li><li><span class=\"wysiwyg-font-size-small\"><a href=\"\/recommended-actions-for-corrupt-databases\" target=\"_self\">Recommended actions for corrupt or suspect databases<\/a><\/span><\/li><li><span class=\"wysiwyg-font-size-small\"><a href=\"\/minimizing-data-loss-when-accidents-happens\" target=\"_self\">Minimizing data loss when accidents happens<\/a><\/span><\/li><\/ul><br><span class=\"wysiwyg-font-size-large\">Utilities<\/span><br><ul><li><a href=\"\/spdbinfo-database-space-usage-information\" target=\"_self\">sp_dbinfo - database space usage information<\/a><\/li><li><a href=\"\/sptableinfo-list-tables-and-space-usage\" target=\"_self\">sp_tableinfo - list tables and space usage<\/a><\/li><li><a href=\"\/spindexinfo-enhanced-index-information-procedure\" target=\"_self\">sp_indexinfo - enhanced index information procedure <b>(updated)<\/b><\/a> <\/li><\/ul><br><ul><li><a href=\"\/looking-for-strange\" target=\"_self\">Looking for strange<\/a><\/li><li><a href=\"\/templates-for-xe-profiler\" target=\"_self\">Templates for XE Profiler<\/a><b><span style=\"color: rgb(192, 80, 77);\"> <\/span><\/b><\/li><li><a href=\"\/log-wait-stats-over-time\" target=\"_self\">Log wait statistics over time<\/a><\/li><li><a href=\"\/adjust-autogrow-values-for-database-files\" target=\"_self\">Adjust autogrow setting to reasonable size<\/a><\/li><li><a href=\"\/log-page-life-expectancy-over-time\" target=\"_self\">Log Page Life Expectency over time<\/a><\/li><li><a href=\"\/rebuild-all-fragmented-heaps\" target=\"_self\">Rebuild all fragmented heaps on a SQL Server<\/a><\/li><li><a href=\"\/pause-random-number-of-minutes-or-seconds\" target=\"_self\">Pause random number of minutes or seconds<\/a><\/li><li><a href=\"\/analyze-sql-server-and-agent-errorlogs\" target=\"_self\">Analyze SQL Server and Agent errorlogs<\/a><\/li><li><a href=\"\/mailafterjob-send-email-after-agent-job-include-ouput-files\" target=\"_self\">MailAfterJob - send email after Agent job, with status in mail subject and output files attached<\/a><\/li><li><a href=\"\/agent-alerts-management-pack\" target=\"_self\">Agent Alerts Management Pack<\/a><\/li><li><a href=\"\/tsql-script-to-create-backup-file-including-database-name-date-and-time\" target=\"_self\">TSQL script to create backup file including database name, date and time<\/a><\/li><li><a href=\"\/restore-all-databases-from-a-number-of-backup-files\" target=\"_self\">Restore all databases from a number of backup files in a directory<\/a><\/li><li><a href=\"\/list-candidates-for-sparse-columns\" target=\"_self\">List column candidates for SPARSE - potential space savings<\/a>\n\n<\/li><\/ul><p><\/p>","localClass":"widget-content-P322Q3","uniqueId":"MgD54mkKKuuSBh0"},"fixed":false,"isInRow":false,"isNew":false,"isTemplateWidget":false,"name":"59f70c1d25f5b","pageRef":105507,"parentUniqueId":"CzN2Kcu0CmOfuWp","ref":368399,"type":"widget.content","uniqueHTMLId":"page-zones__main-widgets__59f70c1d25f5b","uniqueId":"MgD54mkKKuuSBh0","isZone":false,"parentZone":"main","zoneName":null},{"className":"companyname","data":{"business":"profile","preset":null,"presetRef":null,"uniqueId":null,"companyname":"Tibor Karaszi's SQL Server pages"},"fixed":true,"isInRow":false,"isNew":false,"isTemplateWidget":true,"name":"companyname-companyname","pageRef":null,"parentUniqueId":null,"ref":null,"type":"widget.companyname","uniqueHTMLId":"page-zones__template-widgets__companyname-companyname","uniqueId":null,"debugMode":false,"enablePolicyPages":false,"isZone":false,"parentZone":null,"zoneName":null},{"className":"extendednavigation","data":{"align":"right","preset":null,"presetRef":null,"uniqueId":null,"showTplWidget":"1"},"fixed":true,"isInRow":false,"isNew":false,"isTemplateWidget":true,"name":"extendednavigation-extendednavigation","pageRef":null,"parentUniqueId":null,"ref":null,"type":"widget.extendednavigation","uniqueHTMLId":"page-zones__template-widgets__extendednavigation-extendednavigation","uniqueId":null,"debugMode":false,"enablePolicyPages":false,"isZone":false,"parentZone":null,"zoneName":null},{"className":"pagetitle","data":{"preset":null,"presetRef":null,"uniqueId":null,"showTplWidget":"1"},"fixed":true,"isInRow":false,"isNew":false,"isTemplateWidget":true,"name":"pagetitle-title","pageRef":null,"parentUniqueId":null,"ref":null,"type":"widget.pagetitle","uniqueHTMLId":"page-zones__template-widgets__pagetitle-title","uniqueId":null,"debugMode":false,"enablePolicyPages":false,"isZone":false,"parentZone":null,"zoneName":null},{"className":"profile","data":{"profileType":"copyright","preset":null,"presetRef":null,"uniqueId":null,"address":"profile","address1":"profile","address2":"profile","country":"profile","addressPostalCode":"profile","headline":"profile","stra
662pline":"profile","companydescription":"profile","phone":"profile","business":"profile","copyright":"Copyright Tibor Karaszi","twitter":"profile","defaultTwitter":"BaseKit","mapZoom":"12","mapHeight":"200","mapAddress":"profile","mapAddress1":"profile","mapAddress2":"profile","mapPostalCode":"profile","markerPath":"\/apps\/images\/mobile\/map-marker.png","formText":"Skicka","socialIconsLinkedin":"profile","socialIconsTwitter":"profile","socialIconsFacebook":"profile","socialIconsInstagram":"profile","socialIconsPinterest":"profile","socialIconsRss":"profile","socialIconsGoogleplus":"profile","socialIconsYoutube":"profile","showTplWidget":"1"},"fixed":true,"isInRow":false,"isNew":false,"isTemplateWidget":true,"name":"profile-profile2","pageRef":null,"parentUniqueId":null,"ref":null,"type":"widget.profile","uniqueHTMLId":"page-zones__template-widgets__profile-profile2","uniqueId":null,"debugMode":false,"enablePolicyPages":false,"isZone":false,"parentZone":null,"zoneName":null}]; 663 664 jQuery.noConflict(true); 665 bk$(document).ready(function () { 666 ProfileModel = new BaseKit.Globals.Profile(Profile.profile); 667 668 if(typeof Site != "undefined") { 669 Site.load(); 670 } 671 }); 672 }()); 673</script>
673 674 675 676 677 678 679 680 681
681<script src="//ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
681 682
682<script src="//55b558c7-resources.builder.nu/cc283dc/templates/clone-cache-11158-20180410164703/js/main.js"></script>
682 683
683<script src="//55b558c7-resources.builder.nu/cc283dc/templates/clone-cache-11158-20180410164703/js/theme.js"></script>
683 684 685 <!-- Makes it so only one folder dropdown will show at anytime --> 686
686<script> 687 $('.folder-toggle').click(function() { 688 $('.folder-toggle.folder-open').removeClass('folder-open'); 689 }); 690 </script>
690 691 692 <!-- Page Specific Scripts --> 693 694</body> 695</html>
Line numbers count LF bytes from the start of the resource, as the search results do. Vendor segments are library code the classifier recognised; they are stored but not indexed. Bytes are shown as Latin1 characters, one per byte.