SQL Server

<style>/*<meta name='google-adsense-platform-account' content='ca-host-pub-1556223355139109'/>
<meta name='google-adsense-platform-domain' content='blogspot.com'/>

<script async src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js?client=ca-pub-4788329703770464&host=ca-host-pub-1556223355139109" crossorigin="anonymous"></script>

<!-- data-ad-client=ca-pub-4788329703770464 -->

</head><body>*/</style>

Database , SQL Server

Performance tuning scripts

--Long Running Queries SELECT r.session_id, st.TEXT AS batch_text, qp.query_plan AS 'XML Plan', r.start_time, ...

Tvenkat 24 Jan, 2024

Azure , Azure SQL , SQL Server

SQL Server information, OS details in a script

SQL Server info, OS details, databases, and more. Easy to Use: Just run it in SSMS and read the output. See server configuration, backup st...

Tvenkat 3 Jan, 2024

<style>/*
<script type="text/javascript" src="https://www.blogger.com/static/v1/widgets/3102550-widgets.js"></script>
<script type='text/javascript'>
window['__wavt'] = 'AOuZoY7DV1eknkrCkKmYLl_n3poX4VJW8g:1746007659000';_WidgetManager._Init('//www.blogger.com/rearrange?blogID\x3d4912569757089635964','//www.tirupativenkat.in/search/label/SQL%20Server?max-results\x3d10','4912569757089635964');
_WidgetManager._SetDataContext([{'name': 'blog', 'data': {'blogId': '4912569757089635964', 'title': 'Tirupati Venkat', 'url': 'https://www.tirupativenkat.in/search/label/SQL%20Server?max-results\x3d10', 'canonicalUrl': 'https://www.tirupativenkat.in/search/label/SQL%20Server?max-results\x3d10', 'homepageUrl': 'https://www.tirupativenkat.in/', 'searchUrl': 'https://www.tirupativenkat.in/search', 'canonicalHomepageUrl': 'https://www.tirupativenkat.in/', 'blogspotFaviconUrl': 'https://www.tirupativenkat.in/favicon.ico', 'bloggerUrl': 'https://www.blogger.com', 'hasCustomDomain': true, 'httpsEnabled': true, 'enabledCommentProfileImages': true, 'gPlusViewType': 'FILTERED_POSTMOD', 'adultContent': false, 'analyticsAccountNumber': '', 'encoding': 'UTF-8', 'locale': 'en', 'localeUnderscoreDelimited': 'en', 'languageDirection': 'ltr', 'isPrivate': false, 'isMobile': false, 'isMobileRequest': false, 'mobileClass': '', 'isPrivateBlog': false, 'isDynamicViewsAvailable': true, 'feedLinks': '\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Tirupati Venkat - Atom\x22 href\x3d\x22https://www.tirupativenkat.in/feeds/posts/default\x22 /\x3e\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/rss+xml\x22 title\x3d\x22Tirupati Venkat - RSS\x22 href\x3d\x22https://www.tirupativenkat.in/feeds/posts/default?alt\x3drss\x22 /\x3e\n\x3clink rel\x3d\x22service.post\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Tirupati Venkat - Atom\x22 href\x3d\x22https://www.blogger.com/feeds/4912569757089635964/posts/default\x22 /\x3e\n', 'meTag': '\x3clink rel\x3d\x22me\x22 href\x3d\x22https://www.blogger.com/profile/13253944425069766081\x22 /\x3e\n', 'adsenseClientId': 'ca-pub-4788329703770464', 'adsenseHostId': 'ca-host-pub-1556223355139109', 'adsenseHasAds': true, 'adsenseAutoAds': true, 'boqCommentIframeForm': true, 'loginRedirectParam': '', 'view': '', 'dynamicViewsCommentsSrc': '//www.blogblog.com/dynamicviews/4224c15c4e7c9321/js/comments.js', 'dynamicViewsScriptSrc': '//www.blogblog.com/dynamicviews/f41918035ef7fb14', 'plusOneApiSrc': 'https://apis.google.com/js/platform.js', 'disableGComments': true, 'interstitialAccepted': false, 'sharing': {'platforms': [{'name': 'Get link', 'key': 'link', 'shareMessage': 'Get link', 'target': ''}, {'name': 'Facebook', 'key': 'facebook', 'shareMessage': 'Share to Facebook', 'target': 'facebook'}, {'name': 'BlogThis!', 'key': 'blogThis', 'shareMessage': 'BlogThis!', 'target': 'blog'}, {'name': 'X', 'key': 'twitter', 'shareMessage': 'Share to X', 'target': 'twitter'}, {'name': 'Pinterest', 'key': 'pinterest', 'shareMessage': 'Share to Pinterest', 'target': 'pinterest'}, {'name': 'Email', 'key': 'email', 'shareMessage': 'Email', 'target': 'email'}], 'disableGooglePlus': true, 'googlePlusShareButtonWidth': 0, 'googlePlusBootstrap': '\x3cscript type\x3d\x22text/javascript\x22\x3ewindow.___gcfg \x3d {\x27lang\x27: \x27en\x27};\x3c/script\x3e'}, 'hasCustomJumpLinkMessage': false, 'jumpLinkMessage': 'Read more', 'pageType': 'index', 'searchLabel': 'SQL Server', 'pageName': 'SQL Server', 'pageTitle': 'Tirupati Venkat: SQL Server'}}, {'name': 'features', 'data': {}}, {'name': 'messages', 'data': {'edit': 'Edit', 'linkCopiedToClipboard': 'Link copied to clipboard!', 'ok': 'Ok', 'postLink': 'Post Link'}}, {'name': 'template', 'data': {'name': 'custom', 'localizedName': 'Custom', 'isResponsive': true, 'isAlternateRendering': false, 'isCustom': true}}, {'name': 'view', 'data': {'classic': {'name': 'classic', 'url': '?view\x3dclassic'}, 'flipcard': {'name': 'flipcard', 'url': '?view\x3dflipcard'}, 'magazine': {'name': 'magazine', 'url': '?view\x3dmagazine'}, 'mosaic': {'name': 'mosaic', 'url': '?view\x3dmosaic'}, 'sidebar': {'name': 'sidebar', 'url': '?view\x3dsidebar'}, 'snapshot': {'name': 'snapshot', 'url': '?view\x3dsnapshot'}, 'timeslide': {'name': 'timeslide', 'url': '?view\x3dtimeslide'}, 'isMobile': false, 'title': 'Tirupati Venkat', 'description': 'Online Training with Real time Projects \x26amp; Job Support', 'url': 'https://www.tirupativenkat.in/search/label/SQL%20Server?max-results\x3d10', 'type': 'feed', 'isSingleItem': false, 'isMultipleItems': true, 'isError': false, 'isPage': false, 'isPost': false, 'isHomepage': false, 'isArchive': false, 'isSearch': true, 'isLabelSearch': true, 'search': {'label': 'SQL Server', 'resultsMessage': 'Showing posts with the label SQL Server', 'resultsMessageHtml': 'Showing posts with the label \x3cspan class\x3d\x27search-label\x27\x3eSQL Server\x3c/span\x3e'}}}, {'name': 'widgets', 'data': [{'title': 'Upload Image', 'type': 'Image', 'sectionId': 'upload-image', 'id': 'Image50'}, {'title': 'tirupati venkat', 'type': 'HTML', 'sectionId': 'header-main', 'id': 'HTML50'}, {'title': 'Icons, Dark, Search', 'type': 'LinkList', 'sectionId': 'header-main', 'id': 'LinkList52'}, {'title': 'Menu', 'type': 'LinkList', 'sectionId': 'header-main', 'id': 'LinkList53'}, {'title': '#Advertisement', 'type': 'HTML', 'sectionId': 'before-blog', 'id': 'HTML51'}, {'title': 'Blog Posts', 'type': 'Blog', 'sectionId': 'blog-post', 'id': 'Blog50', 'posts': [{'id': '296086938687670706', 'title': 'Performance tuning scripts', 'featuredImage': 'https://blogger.googleusercontent.com/img/a/AVvXsEhqiCkRw_gzvW61gBUTj0LRF-6eQWh_QDg2CQexEqy6FUg1wAal-eYpKuhkVEZJkmMpJr6T94TrcuwnEGCUXx1sq81svZWsWElpGrQNRaVeqboQ9nRjtP-i5VwH0GnbBpQBnlWAnREnwnKcSwGRuf8kXPTp60mQJhmgkmetIewYIAUCNr8BaPJga7SwNK1T\x3dw483-h221', 'showInlineAds': false}, {'id': '8345891008942012450', 'title': 'SQL Server information, OS details in a script', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi_JxFiMzVbLnH9b7DjNk8K5hwvnfQXBDiC96pJODvKuDt2lZoX6P0eS_s58cQG2RjsonVoBoAk0UrMl_8hR109hH7R4Mf_JKeWldY69ACn2-nHB6D1LVFdMy6RnlLqzERjUE1QijMYGsNql9OfECUMqDLddLUIrUL2rwxkV3LEO9mP8nW0Rn2Lvf8L0vvF/s320/Untitled.png', 'showInlineAds': false}], 'footerBylines': [{'regionName': 'footer1', 'items': [{'name': 'author', 'label': 'Posted by'}, {'name': 'timestamp', 'label': '-'}, {'name': 'comments', 'label': 'Comment'}, {'name': 'share', 'label': ''}]}, {'regionName': 'footer2', 'items': [{'name': 'labels', 'label': 'Labels:'}]}], 'allBylineItems': [{'name': 'author', 'label': 'Posted by'}, {'name': 'timestamp', 'label': '-'}, {'name': 'comments', 'label': 'Comment'}, {'name': 'share', 'label': ''}, {'name': 'labels', 'label': 'Labels:'}]}, {'title': '#You may also like', 'type': 'HTML', 'sectionId': 'ads-post', 'id': 'HTML63'}, {'title': 'Online Trainings', 'type': 'PageList', 'sectionId': 'sidebar-static', 'id': 'PageList1'}, {'title': 'Popular Posts', 'type': 'PopularPosts', 'sectionId': 'sidebar-static', 'id': 'PopularPosts50', 'posts': [{'title': ' Cannot start node if snitch\x27s data center (dc1) differs from previous data center (datacenter1). Please fix the snitch configuration, decommission and rebootstrap this node or use the flag -Dcassandra.ignore_dc\x3dtrue.', 'id': 3078269853930330244}, {'title': 'Comparison of NDB, XtraDB, Galera, and InnoDB Cluster', 'id': 45326777957772966}, {'title': ' MySQL Server Enterprise Firewall Tutorial ', 'id': 2402111729877522881}, {'title': 'MySQL Server 5.7 to 8.0 in AWS RDS ', 'id': 5113388849891271156}, {'title': 'GCP Cloud firewall Interview Questions - Real time Questions for Google Cloud', 'id': 2118466394188803105}]}, {'title': 'Categories', 'type': 'Label', 'sectionId': 'sidebar-static', 'id': 'Label50'}, {'title': 'Hashtag', 'type': 'Label', 'sectionId': 'sidebar-static', 'id': 'Label51'}, {'title': '#Recent Post', 'type': 'HTML', 'sectionId': 'sidebar-static', 'id': 'HTML66'}, {'title': '#Advertisement', 'type': 'HTML', 'sectionId': 'sidebar-sticky', 'id': 'HTML54'}, {'title': 'About Us', 'type': 'HTML', 'sectionId': 'footer-widget', 'id': 'HTML55'}, {'title': 'Learn More', 'type': 'LinkList', 'sectionId': 'footer-widget', 'id': 'LinkList50'}, {'title': 'Follow Us', 'type': 'LinkList', 'sectionId': 'footer-widget', 'id': 'LinkList51'}, {'title': 'Newsletter', 'type': 'HTML', 'sectionId': 'footer-widget', 'id': 'HTML58'}, {'title': 'Copyright', 'type': 'HTML', 'sectionId': 'copyright', 'id': 'HTML56'}, {'title': 'SVG Icons', 'type': 'HTML', 'sectionId': 'jet-options', 'id': 'HTML57'}]}]);
_WidgetManager._RegisterWidget('_ImageView', new _WidgetInfo('Image50', 'upload-image', document.getElementById('Image50'), {'resize': false}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML50', 'header-main', document.getElementById('HTML50'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList52', 'header-main', document.getElementById('LinkList52'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList53', 'header-main', document.getElementById('LinkList53'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML51', 'before-blog', document.getElementById('HTML51'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_BlogView', new _WidgetInfo('Blog50', 'blog-post', document.getElementById('Blog50'), {'cmtInteractionsEnabled': false, 'navMessage': 'Showing posts with label \x3cb\x3eSQL Server\x3c/b\x3e. \x3ca href\x3d\x22https://www.tirupativenkat.in/\x22\x3eShow all posts\x3c/a\x3e', 'lightboxEnabled': true, 'lightboxModuleUrl': 'https://www.blogger.com/static/v1/jsbin/2952873794-lbx.js', 'lightboxCssUrl': 'https://www.blogger.com/static/v1/v-css/3681588378-lightbox_bundle.css'}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML63', 'ads-post', document.getElementById('HTML63'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_PageListView', new _WidgetInfo('PageList1', 'sidebar-static', document.getElementById('PageList1'), {'title': 'Online Trainings', 'links': [{'isCurrentPage': false, 'href': 'https://www.tirupativenkat.in/p/linux-shell-scripting-online-training.html', 'id': '4249654896922791182', 'title': 'Linux Shell Scripting Online Training '}, {'isCurrentPage': false, 'href': 'https://www.tirupativenkat.in/p/sql-advanced-online-training.html', 'id': '4807783328311567544', 'title': 'SQL basic to advanced Online training'}, {'isCurrentPage': false, 'href': 'https://www.tirupativenkat.in/p/gcp-data-engineere.html', 'id': '5049836616644791364', 'title': 'GCP Data Engineering'}, {'isCurrentPage': false, 'href': 'https://www.tirupativenkat.in/p/gcp-cloud-engineer-gcp-devops-sample.html', 'id': '5162342218520205201', 'title': 'GCP Cloud Engineer \x26 GCP DevOPS Sample Resume '}], 'mobile': false, 'showPlaceholder': true, 'hasCurrentPage': false}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_PopularPostsView', new _WidgetInfo('PopularPosts50', 'sidebar-static', document.getElementById('PopularPosts50'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LabelView', new _WidgetInfo('Label50', 'sidebar-static', document.getElementById('Label50'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LabelView', new _WidgetInfo('Label51', 'sidebar-static', document.getElementById('Label51'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML66', 'sidebar-static', document.getElementById('HTML66'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML54', 'sidebar-sticky', document.getElementById('HTML54'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML55', 'footer-widget', document.getElementById('HTML55'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList50', 'footer-widget', document.getElementById('LinkList50'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList51', 'footer-widget', document.getElementById('LinkList51'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML58', 'footer-widget', document.getElementById('HTML58'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML56', 'copyright', document.getElementById('HTML56'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML57', 'jet-options', document.getElementById('HTML57'), {}, 'displayModeFull'));
</script>
</body>*/</style>

Performance tuning scripts

SQL Server information, OS details in a script

Online Trainings

Popular Posts

Cannot start node if snitch's data center (dc1) differs from previous data center (datacenter1). Please fix the snitch configuration, decommission and rebootstrap this node or use the flag -Dcassandra.ignore_dc=true.

Comparison of NDB, XtraDB, Galera, and InnoDB Cluster

MySQL Server Enterprise Firewall Tutorial

MySQL Server 5.7 to 8.0 in AWS RDS

GCP Cloud firewall Interview Questions - Real time Questions for Google Cloud

Categories

Hashtag