PageSourceSearch

https://karaszi.com/articlesandutilities

html karaszi.com collected 2026-09-24 11:08:49 UTC 112,729 bytes, 695 lines download raw bytes

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&amp;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&amp;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&amp;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&amp;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&#039;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>&nbsp;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&nbsp;<b>(updated)</b></a>&nbsp;</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);">&nbsp;</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>&nbsp;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&nbsp;<b>(updated)<\/b><\/a>&nbsp;<\/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);\">&nbsp;<\/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>&nbsp;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&nbsp;<b>(updated)<\/b><\/a>&nbsp;<\/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);\">&nbsp;<\/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.