SQL Shack - articoli su audit di database, prestazioni di server, recupero dati, e altro ancora

di 5000~500000

196

Fama e ricchezza. Prosperità e ricchezza Ji

2

3.136.173.2

SQLShack-articlesaboutdatabaseauditing,serverperformance,datarecovery,andmore /**/ .wp-peni{margin-left:auto!important;margin-right:auto;!important} img.wp-smiley,img.emoji{ display:inline!important; border:none!important; box-shadow:none!important; height:1em!important; width:1em!important; margin:00.07em!important; vertical-align:-0.1em!important; background:none!important; padding:0!important; }.wp-block-audio:where(figcaption){color:#555;font-size:13px;text-align:center}.is-dark-theme.wp-block-audio:where(figcaption){color:#ffffffa6}.wp-block-audio{margin:001em}.wp-block-code{border:1pxsolid#ccc;border-radius:4px;font-family:Menlo,Consolas,monaco,monospace;padding:.8em1em}.wp-block-embed:where(figcaption){color:#555;font-size:13px;text-align:center}.is-dark-theme.wp-block-embed:where(figcaption){color:#ffffffa6}.wp-block-embed{margin:001em}.blocks-gallery-caption{color:#555;font-size:13px;text-align:center}.is-dark-theme.blocks-gallery-caption{color:#ffffffa6}:root:where(.wp-block-imefigcaption){color:#555;font-size:13px;text-align:center}.is-dark-theme:root:where(.wp-block-imefigcaption){color:#ffffffa6}.wp-block-ime{margin:001em}.wp-block-pullquote{border-bottom:4pxsolid;border-top:4pxsolid;color:currentColor;margin-bottom:1.75em}.wp-block-pullquotecite,.wp-block-pullquotefooter,.wp-block-pullquote__citation{color:currentColor;font-size:.8125em;font-style:normal;text-transform:uppercase}.wp-block-quote{border-left:.25emsolid;margin:001.75em;padding-left:1em}.wp-block-quotecite,.wp-block-quotefooter{color:currentColor;font-size:.8125em;font-style:normal;position:relative}.wp-block-quote:where(.has-text-align-right){border-left:none;border-right:.25emsolid;padding-left:0;padding-right:1em}.wp-block-quote:where(.has-text-align-center){border:none;padding-left:0}.wp-block-quote.is-large,.wp-block-quote.is-style-large,.wp-block-quote:where(.is-style-plain){border:none}.wp-block-search.wp-block-search__label{font-weight:700}.wp-block-search__button{border:1pxsolid#ccc;padding:.375em.625em}:where(.wp-block-group.has-background){padding:1.25em2.375em}.wp-block-separator.has-css-opacity{opacity:.4}.wp-block-separator{border:none;border-bottom:2pxsolid;margin-left:auto;margin-right:auto}.wp-block-separator.has-alpha-channel-opacity{opacity:1}.wp-block-separator:not(.is-style-wide):not(.is-style-dots){width:100px}.wp-block-separator.has-background:not(.is-style-dots){border-bottom:none;height:1px}.wp-block-separator.has-background:not(.is-style-wide):not(.is-style-dots){height:2px}.wp-block-table{margin:001em}.wp-block-tabletd,.wp-block-tableth{word-break:normal}.wp-block-table:where(figcaption){color:#555;font-size:13px;text-align:center}.is-dark-theme.wp-block-table:where(figcaption){color:#ffffffa6}.wp-block-video:where(figcaption){color:#555;font-size:13px;text-align:center}.is-dark-theme.wp-block-video:where(figcaption){color:#ffffffa6}.wp-block-video{margin:001em}:root:where(.wp-block-template-part.has-background){margin-bottom:0;margin-top:0;padding:1.25em2.375em}/*!Thisfileisauto-generated*/.wp-block-button__link{color:#fff;background-color:#c;border-radius:9999px;box-shadow:none;text-decoration:none;padding:calc(.667em+2px)calc(1.333em+2px);font-size:1.125em}.wp-block-file__button{background:#c;color:#fff;text-decoration:none}:root{--wp--preset--aspect-ratio--square:1;--wp--preset--aspect-ratio--4-3:4/3;--wp--preset--aspect-ratio--3-4:3/4;--wp--preset--aspect-ratio--3-2:3/2;--wp--preset--aspect-ratio--2-3:2/3;--wp--preset--aspect-ratio--16-9:16/9;--wp--preset--aspect-ratio--9-16:9/16;--wp--preset--color--black:#;--wp--preset--color--cyan-bluish-gray:#abb8c3;--wp--preset--color--white:#fff;--wp--preset--color--pale-pink:#f78da7;--wp--preset--color--vivid-red:#cf2e2e;--wp--preset--color--luminous-vivid-orange:#ff6900;--wp--preset--color--luminous-vivid-amber:#fcb900;--wp--preset--color--light-green-cyan:#7bdcb5;--wp--preset--color--vivid-green-cyan:#00d084;--wp--preset--color--pale-cyan-blue:#8ed1fc;--wp--preset--color--vivid-cyan-blue:#0693e3;--wp--preset--color--vivid-purple:#9b51e0;--wp--preset--color--blue:#b;--wp--preset--color--dark-gray:#444;--wp--preset--color--medium-gray:#9f9f9f;--wp--preset--color--light-gray:#e6e6e6;--wp--preset--gradient--vivid-cyan-blue-to-vivid-purple:linear-gradient(135deg,rgba(6,147,227,1)0%,rgb(155,81,224)100%);--wp--preset--gradient--light-green-cyan-to-vivid-green-cyan:linear-gradient(135deg,rgb(122,220,180)0%,rgb(0,208,130)100%);--wp--preset--gradient--luminous-vivid-amber-to-luminous-vivid-orange:linear-gradient(135deg,rgba(252,185,0,1)0%,rgba(255,105,0,1)100%);--wp--preset--gradient--luminous-vivid-orange-to-vivid-red:linear-gradient(135deg,rgba(255,105,0,1)0%,rgb(207,46,46)100%);--wp--preset--gradient--very-light-gray-to-cyan-bluish-gray:linear-gradient(135deg,rgb(238,238,238)0%,rgb(169,184,195)100%);--wp--preset--gradient--cool-to-warm-spectrum:linear-gradient(135deg,rgb(74,234,220)0%,rgb(151,120,209)20%,rgb(207,42,186)40%,rgb(238,44,130)60%,rgb(251,105,98)80%,rgb(254,248,76)100%);--wp--preset--gradient--blush-light-purple:linear-gradient(135deg,rgb(255,206,236)0%,rgb(152,150,240)100%);--wp--preset--gradient--blush-bordeaux:linear-gradient(135deg,rgb(254,205,165)0%,rgb(254,45,45)50%,rgb(107,0,62)100%);--wp--preset--gradient--luminous-dusk:linear-gradient(135deg,rgb(255,203,112)0%,rgb(199,81,192)50%,rgb(65,88,208)100%);--wp--preset--gradient--pale-ocean:linear-gradient(135deg,rgb(255,245,203)0%,rgb(182,227,212)50%,rgb(51,167,181)100%);--wp--preset--gradient--electric-grass:linear-gradient(135deg,rgb(202,248,128)0%,rgb(113,206,126)100%);--wp--preset--gradient--midnight:linear-gradient(135deg,rgb(2,3,129)0%,rgb(40,116,252)100%);--wp--preset--font-size--small:13px;--wp--preset--font-size--medium:20px;--wp--preset--font-size--large:36px;--wp--preset--font-size--x-large:42px;--wp--preset--spacing--20:0.44rem;--wp--preset--spacing--30:0.67rem;--wp--preset--spacing--40:1rem;--wp--preset--spacing--50:1.5rem;--wp--preset--spacing--60:2.25rem;--wp--preset--spacing--70:3.38rem;--wp--preset--spacing--80:5.06rem;--wp--preset--shadow--natural:6px6px9pxrgba(0,0,0,0.2);--wp--preset--shadow--deep:12px12px50pxrgba(0,0,0,0.4);--wp--preset--shadow--sharp:6px6px0pxrgba(0,0,0,0.2);--wp--preset--shadow--outlined:6px6px0px-3pxrgba(255,255,255,1),6px6pxrgba(0,0,0,1);--wp--preset--shadow--crisp:6px6px0pxrgba(0,0,0,1);}:where(.is-layout-flex){gap:0.5em;}:where(.isSQL Shack - articoli su audit di database, prestazioni di server, recupero dati, e altro ancora-layout-grid){gap:0.5em;}body.is-layout-flex{display:flex;}.is-layout-flex{flex-wrap:wrap;align-items:center;}.is-layout-flex>:is(*,div){margin:0;}body.is-layout-grid{display:grid;}.is-layout-grid>:is(*,div){margin:0;}:where(.wp-block-columns.is-layout-flex){gap:2em;}:where(.wp-block-columns.is-layout-grid){gap:2em;}:where(.wp-block-post-template.is-layout-flex){gap:1.25em;}:where(.wp-block-post-template.is-layout-grid){gap:1.25em;}.has-black-color{color:var(--wp--preset--color--black)!important;}.has-cyan-bluish-gray-color{color:var(--wp--preset--color--cyan-bluish-gray)!important;}.has-white-color{color:var(--wp--preset--color--white)!important;}.has-pale-pink-color{color:var(--wp--preset--color--pale-pink)!important;}.has-vivid-red-color{color:var(--wp--preset--color--vivid-red)!important;}.has-luminous-vivid-orange-color{color:var(--wp--preset--color--luminous-vivid-orange)!important;}.has-luminous-vivid-amber-color{color:var(--wp--preset--color--luminous-vivid-amber)!important;}.has-light-green-cyan-color{color:var(--wp--preset--color--light-green-cyan)!important;}.has-vivid-green-cyan-color{color:var(--wp--preset--color--vivid-green-cyan)!important;}.has-pale-cyan-blue-color{color:var(--wp--preset--color--pale-cyan-blue)!important;}.has-vivid-cyan-blue-color{color:var(--wp--preset--color--vivid-cyan-blue)!important;}.has-vivid-purple-color{color:var(--wp--preset--color--vivid-purple)!important;}.has-black-background-color{background-color:var(--wp--preset--color--black)!important;}.has-cyan-bluish-gray-background-color{background-color:var(--wp--preset--color--cyan-bluish-gray)!important;}.has-white-background-color{background-color:var(--wp--preset--color--white)!important;}.has-pale-pink-background-color{background-color:var(--wp--preset--color--pale-pink)!important;}.has-vivid-red-background-color{background-color:var(--wp--preset--color--vivid-red)!important;}.has-luminous-vivid-orange-background-color{background-color:var(--wp--preset--color--luminous-vivid-orange)!important;}.has-luminous-vivid-amber-background-color{background-color:var(--wp--preset--color--luminous-vivid-amber)!important;}.has-light-green-cyan-background-color{background-color:var(--wp--preset--color--light-green-cyan)!important;}.has-vivid-green-cyan-background-color{background-color:var(--wp--preset--color--vivid-green-cyan)!important;}.has-pale-cyan-blue-background-color{background-color:var(--wp--preset--color--pale-cyan-blue)!important;}.has-vivid-cyan-blue-background-color{background-color:var(--wp--preset--color--vivid-cyan-blue)!important;}.has-vivid-purple-background-color{background-color:var(--wp--preset--color--vivid-purple)!important;}.has-black-border-color{border-color:var(--wp--preset--color--black)!important;}.has-cyan-bluish-gray-border-color{border-color:var(--wp--preset--color--cyan-bluish-gray)!important;}.has-white-border-color{border-color:var(--wp--preset--color--white)!important;}.has-pale-pink-border-color{border-color:var(--wp--preset--color--pale-pink)!important;}.has-vivid-red-border-color{border-color:var(--wp--preset--color--vivid-red)!important;}.has-luminous-vivid-orange-border-color{border-color:var(--wp--preset--color--luminous-vivid-orange)!important;}.has-luminous-vivid-amber-border-color{border-color:var(--wp--preset--color--luminous-vivid-amber)!important;}.has-light-green-cyan-border-color{border-color:var(--wp--preset--color--light-green-cyan)!important;}.has-vivid-green-cyan-border-color{border-color:var(--wp--preset--color--vivid-green-cyan)!important;}.has-pale-cyan-blue-border-color{border-color:var(--wp--preset--color--pale-cyan-blue)!important;}.has-vivid-cyan-blue-border-color{border-color:var(--wp--preset--color--vivid-cyan-blue)!important;}.has-vivid-purple-border-color{border-color:var(--wp--preset--color--vivid-purple)!important;}.has-vivid-cyan-blue-to-vivid-purple-gradient-background{background:var(--wp--preset--gradient--vivid-cyan-blue-to-vivid-purple)!important;}.has-light-green-cyan-to-vivid-green-cyan-gradient-background{background:var(--wp--preset--gradient--light-green-cyan-to-vivid-green-cyan)!important;}.has-luminous-vivid-amber-to-luminous-vivid-orange-gradient-background{background:var(--wp--preset--gradient--luminous-vivid-amber-to-luminous-vivid-orange)!important;}.has-luminous-vivid-orange-to-vivid-red-gradient-background{background:var(--wp--preset--gradient--luminous-vivid-orange-to-vivid-red)!important;}.has-very-light-gray-to-cyan-bluish-gray-gradient-background{background:var(--wp--preset--gradient--very-light-gray-to-cyan-bluish-gray)!important;}.has-cool-to-warm-spectrSQL Shack - articoli su audit di database, prestazioni di server, recupero dati, e altro ancoraum-gradient-background{background:var(--wp--preset--gradient--cool-to-warm-spectrum)!important;}.has-blush-light-purple-gradient-background{background:var(--wp--preset--gradient--blush-light-purple)!important;}.has-blush-bordeaux-gradient-background{background:var(--wp--preset--gradient--blush-bordeaux)!important;}.has-luminous-dusk-gradient-background{background:var(--wp--preset--gradient--luminous-dusk)!important;}.has-pale-ocean-gradient-background{background:var(--wp--preset--gradient--pale-ocean)!important;}.has-electric-grass-gradient-background{background:var(--wp--preset--gradient--electric-grass)!important;}.has-midnight-gradient-background{background:var(--wp--preset--gradient--midnight)!important;}.has-small-font-size{font-size:var(--wp--preset--font-size--small)!important;}.has-medium-font-size{font-size:var(--wp--preset--font-size--medium)!important;}.has-large-font-size{font-size:var(--wp--preset--font-size--large)!important;}.has-x-large-font-size{font-size:var(--wp--preset--font-size--x-large)!important;}:where(.wp-block-post-template.is-layout-flex){gap:1.25em;}:where(.wp-block-post-template.is-layout-grid){gap:1.25em;}:where(.wp-block-columns.is-layout-flex){gap:2em;}:where(.wp-block-columns.is-layout-grid){gap:2em;}:root:where(.wp-block-pullquote){font-size:1.5em;line-height:1.6;} .fancybox-slide--ime.fancybox-content{background-color:#FFFFFF}div.fancybox-caption{display:none!important;} img.fancybox-ime{border-width:10px;border-color:#FFFFFF;border-style:solid;} div.fancybox-bg{background-color:rgba(102,102,102,0.7);opacity:1!important;}div.fancybox-content{border-color:#FFFFFF} div#fancybox-title{background-color:#FFFFFF} div.fancybox-content{background-color:#FFFFFF} div#fancybox-title-inside{color:#} div.fancybox-captionp.caption-title{display:inline-block} div.fancybox-captionp.caption-title{font-size:14px} div.fancybox-captionp.caption-title{color:#} div.fancybox-caption{color:#}div.fancybox-captionp.caption-title{background:#fff;width:auto;padding:10px30px;}div.fancybox-contentp.caption-title{color:#;margin:0;padding:5px0;}body.fancybox-active.fancybox-container.fancybox-ste.fancybox-content.fancybox-close-small{display:block;} jQuery(function(){ varmobileOnly=false; if(mobileOnly){ return; } jQuery.fn.getTitle=function(){//CopythetitleofeveryIMGtandaddittoitsparentAsothatfancyboxcanshowtitles vararr=jQuery("a[data-fancybox]"); jQuery.each(arr,function(){ vartitle=jQuery(this).children("img").attr("title"); varcaption=jQuery(this).next("figcaption").html();if(caption&&title){jQuery(this).attr("title",title+""+caption)}elseif(title){jQuery(this).attr("title",title);}elseif(caption){jQuery(this).attr("title",caption);} }); } //Supportedfileextensions varthumbnails=jQuery("a:has(img)").not(".nolightbox").not('.envira-gallery-link').not('.ngg-simplelightbox').filter(function(){ return/\.(jpe?g|png|gif|mp4|webp|bmp)(\?[^/]*)*$/i.test(jQuery(this).attr('href')) }); //Adddata-typeiframeforlinksthatarenotimesorvideos. variframeLinks=jQuery('.fancyboxforwp').filter(function(){ return!/\.(jpe?g|png|gif|mp4|webp|bmp|pdf)(\?[^/]*)*$/i.test(jQuery(this).attr('href')) }).filter(function(){ return!/vimeo|youtube/i.test(jQuery(this).attr('href')) }); iframeLinks.attr({"data-type":"iframe"}).getTitle(); //GalleryAll thumbnails.addClass("fancyboxforwp").attr("data-fancybox","gallery").getTitle(); iframeLinks.attr({"data-fancybox":"gallery"}).getTitle(); //GallerytypeNONE //Callfancyboxandapplyitonanylinkwitharelatributethatstartswith"fancybox",withtheoptionssetontheadminpanel jQuery("a.fancyboxforwp").fancyboxforwp({ loop:false, smallBtn:true, zoomOpacity:"auto", animationEffect:"fade", animationDuration:500, transitionEffect:"fade", transitionDuration:"300", overlayShow:true, overlayOpacity:"0.7", titleShow:true, titlePosition:"inside", keyboard:true, showCloseButton:true, arrows:true, clickContent:false, clickSlide:"close", mobile:{ clickContent:function(current,event){ returncurrent.type==="ime"?"toggleControls":false; }, clickSlide:function(current,event){ returncurrent.type==="ime"?"close":"close"; }, }, wheel:false, toolbar:true, preventCaptionOverlap:true, onInit:function(){}, onDeactivate :function(){}, beforeClose:function(){}, afterShow:function(instance){jQuery(".fancybox-ime").on("click",function(){(instance.isScaledDown())?instance.scaleToActual():instance.scaleToFit()})}, afterClose:function(){}, caption:function(instance,item){vartitle="";if("undefined"!=typeofjQuery(this).context){vartitle=jQuery(this).context.title;}else{vartitle=("undefined"!=typeofjQuery(this).attr("title"))?jQuery(this).attr("title"):false;}varcaption=jQuery(this).data('caption')||'';if(item.type==='ime'&&title.length){caption=(caption.length?caption+'':'')+''+title+'';}returncaption;}, afterLoad:function(instance,current){current.$content.append(''+current.opts.caption+'');}, }) ; }) .wp-peni { font-size:12px!important; } if(window.addthis_product===undefined){window.addthis_product="wpp";}if(window.wp_product_version===undefined){window.wp_product_version="wpp-6.2.7";}if(window.addthis_share===undefined){window.addthis_share={"passthrough":{"twitter":{"via":"SQLShack"}},"url_transforms":{"shorten":{"twitter":"bitly"}},"shorteners":{"bitly":{}}};}if(window.addthis_config===undefined){window.addthis_config={"data_track_clickback":true,"data_ga_property":"UA--1","data_ga_social":true,"ui_atversion":300,"ui_508_compliant":true};}if(window.addthis_plugin_info===undefined){window.addthis_plugin_info={"info_status":"enabled","cms_name":"WordPress","plugin_name":"ShareButtonsbyAddThis","plugin_version":"6.2.7","plugin_mode":"AddThis","anonymous_profile_id":"wp-c0ad93f1f4460a20fdbfc6120b3c5723","pe_info":{"template":"home","post_type":""},"sharing_enabled_on_post_via_metabox":false};}(function(){varfirst_load_interval_id=setInterval(function(){if(typeofwindow.addthis!=='undefined'){window.clearInterval(first_load_interval_id);if(typeofwindow.addthis_layers!=='undefined'&&Object.getOwnPropertyNames(window.addthis_layers).length>0){window.addthis.layers(window.addthis_layers);}if(Array.isArray(window.addthis_layers_tools)){for(i=0;i.entry-header.entry-title{font-size:2em;}.entry-contenth2{ font-size:27px; color:#337ab7; font-weight:normal;}.entry-contenth3{ font-size:22px; color:black; font-weight:normal;}.entry-contenth4{ font-size:18px; color:#1f4d78; font-weight:normal;}#cookiesWarning{/*min-height:170px;*/position:fixed;left:0px;right:0px;bottom:0px;background-color:#fff;z-index:999;box-sizing:border-box;display:block;font-family:"SegoeUI",Tahoma,arial,sans-serif;font-size:12px;line-height:1.;color:rgb(51,51,51);-webkit-tap-highlight-color:rgba(0,0,0,0);text-size-adjust:100%;}#cookiesWarningActive{margin-top:auto;margin-bottom:auto;border-top:solid1px#f0f0f0;}@media(min-width:992px)and(max-width:1165px){#cookiesWarning{/*min-height:190px;*/}#textp{margin-bottom:12px;}#cookiesOK{margin:24px;}.cookieBtn{margin-left:200px!important;}.emptySpace1,.emptySpace2{display:none;}.cookieTxt{margin:0pxauto;float:left;}.contCookie{width:100%;}}@media(max-width:991px){#cookiesWarning{/*min-height:250px;*/}#textp{margin:12px;}#cookiesOK{margin:12px;}.cookieBtn{margin-top:0px!important;margin-left:0px!important;margin-right:50px!important;}.emptySpace1,.emptySpace2{display:none;}.cookieTxt{float:left;width:450px!important;}.contCookie{width:600px!important;}}@media(max-width:460px){#cookiesWarning{/*min-height:300px;*/}#cookiesOK{margin-top:10px;}.cookieTxt{float:left;width:275px!important;}.contCookie{width:350px!important;}#textp{margin:12px;}.cookieBtn{margin-top:-290px!important;}}.emptySpace1{/*float:left;*/width:20%;padding:5px;}.cookieTxt{width:600px;/*padding:10px;*/font-family:"SegoeUI",Tahoma,arial,sans-serif;font-size:14px;margin-top:4px;}.cookieBtn{/*text-align:center;*/float:right;width:70px;padding:10px;margin-top:-130px;/*margin-left:120px;*/}.contCookie{width:760px;margin:0auto;}.emptySpace2{float:left;width:25%;padding:5px;}#cookiesOK{height:36px;width:70px;border-radius:4px;font-size:14px;background-color:#888;color:#fff;background-ime:none;border:1pxsolidtransparent;}#cookiesOK:hover{background-color:#;color:white;}SQLShackSkiptocontentSQLServertraining EspañoljQuery(document).ready(function(SQL Shack - articoli su audit di database, prestazioni di server, recupero dati, e altro ancora){varshow_box=true;//Handleclickonsearchhide/showbuttonjQuery('#mysearchsubmit').click(function(){if(show_box){jQuery('.search-input').css('display','flex');jQuery('#s').focus();show_box=false;}else{jQuery('.search-input').hide();show_box=true;}});//HandleclickonsearchbuttonjQuery('#mysubmitbutton').click(function(){jQuery('.search-input').hide();show_box=true;window.location.href="/?s="+jQuery("#s").val();});//EnablethatwecanactivatesearchbyhittingenterbuttonjQuery(document).on('keypress',function(e){//helpervariablevardummyEl=document.getElementById('s');//checkforfocusofactiveelementvarisFocused=(document.activeElement===dummyEl);if(e.which==13&&isFocused){jQuery('#mysubmitbutton').click();}});//CheckforclickoutsideofsearchelementsforhidingsearchjQuery(document).click(function(e){if(e.target.id!=="mysubmitbutton"&&e.target.id!=="mysearchsubmit"&&e.target.id!=="s"&&show_box==false){jQuery('.search-input').hide();show_box=true;}});}); UnderstandingPostgreSQLSUBSTRINGfunction September21,2024 byRajendraGupta PostgreSQLisanopen-source,object-orientedrelationaldatabasesystemwithreliability,performance,androbustness.ItsupportsSQL(relational)andJSON(non-relational)queries.PostgreSQL8217;spopularfeaturesincludeMulti-VersionConcurrencyControl(MVCC),point-in-timerecovery,granularaccesscontrols,tablespaces,andasynchronousreplication.Readmore» Development,PostgreSQL HowtocreateandquerythePythonPostgreSQLdatabase August15,2024 byHaroonAshraf ThisarticleisallaboutcreatingandqueryingPythonPostgreSQLdatabaseinasimpleandeasyway.Readmore» PostgreSQL,Python DifferentwaystoidentifyandchangecompatibilitylevelsinSQLServer July22,2024 byNisargUpadhyay CompatibilitylevelinSQLServerreferstoadatabasepropertythatdeterminesthesyntaxandbehiorofthedatabase,allowingittobecompatiblewithearlierversionsofSQLServer.EachversionofSQLServerintroducesnewfeatures,improvements,andchangestothequeryoptimizer,whichmayaffecthowqueriesareexecutedandhowresultsarereturned.Readmore» Development,Generaldatabasedesign OracleSubstringfunctionoverviewwithexamples June19,2024 byGauriMahajan Inthisarticle,wewilllearnhowtosetupanOracleinstance,createsampledataandunderstandtheuseofthesubstringfunction.Readmore» Oracle ConfigurebackupstoreredundancyforAzureCosmosDBaccount May15,2024 byManvendraSingh ThisarticlewillexplainbackupstoreredundancyforAzureCosmosDB.Backupsareacriticalfeaturetokeepcopiesofourdatatoensuredataprotectionandrecoverabilityincaseofanyaccidentaldeletion,updating,oranykindofdisaster.Butthisisnotenoughtorunbackupsonlytoseitscopies.Wemustalsoprotectthosebackupcopiesfromaccidentaldeletesorcorruptionandensuretheirproperresiliencyshouldbeinplacetokeepbackupssafefromanyunforeseencircumstances.Itdependsonthecriticalityofyourdatawhetheryouwanttokeepthemlocallytowanttoreplicatetheminotherlocationsorregionstoensuretheirresiliencies.Readmore» AzureCosmosDB SQLPerformanceTuningtipsfornewbies April15,2024 byEsatErkec ThepurposeofthisarticleistogivenewbiessomebasicadviceaboutSQLperformancetuningthathelpstoimprovetheirquerytuningskillsinSQLServer.Readmore» Monitoring,Performance UnderstandingtheSQLINoperatorwithexamples March19,2024 byArindamMondal TodaywewilllearnabouttheSQLINoperator.TheRDBMSsystemsareverypopulartodayintermsofdatastore,datasecurity,anddataanalysis.SQLstandsforStructuredQueryLanguewhichisusedtocreate,update,orretrievedatainRDBMSorRelationalDatabaseManementSystemslikeSQLServer,Oracle,MicrosoftAccess,MySQL,andPostgreSQL.Readmore» T-SQL FindingDuplicatesinSQL February7,2024 byRahulMehta ThisarticlewillprovideanunderstandingofidentifyingduplicatevaluesinSQL.Readmore» T-SQL DifferencebetweenSQLSELECTUNIQUEandSELECTDISTINCT January16,2024 byManvendraSingh Today,wewilllearnthedifferencebetweenSQLSELECTUNIQUEandSELECTDISTINCTinthisarticle.AsweallknowthatSQLisaquerylanguethatisusedtoaccess,create,delete,andmodifydatastoredinadatabasesystemlikeSQLServer,Oracle,MySQL,etc.AllthesedatabasesystemshetheirquerylanguelikeTSQL,PLSQL,etc.ThesequerylanguesarebasedonANSIstandardSQLlanguewhichcanalsobeusedinthesedatabasesystemstoperformanytransaction.Readmore» T-SQL AnoverviewofSQLServermonitoringtools December12,2023 byHadiFadlallah ThisarticleexplainssomeofthepopularSQLServermonitoringtoolsandtechniques.Readmore» Monitoring,Performance PostgreSQLtutorialtocreateauser November12,2023 byDanielCalbimonte IntroductiontothePostgreSQLtutorialtocreateauserInthisarticle,wewillshowaPostgreSQLtutorialtocreateauserusingPgAdminandPL/PgSQL.Readmore» PostgreSQL MySQLsubstringuseswithexamples October14,2023 byRahulMehta ThisarticlewillprovideanunderstandingofdifferentwaystousesubstringinMySQL.Readmore» MySQL AnintroductiontoPostgreSQLDataTypeswithexamples September15,2023 byArindamMondal ThisarticlewillshowPostgreSQLDataTypeswithvariousexamples.Readmore» Datatypes SQLUnitTestingreferenceguideforbeginners August11,2023 byEsatErkec Inthisarticle,wearegoingtolearnthebasicsofSQLunittestingandhowtowriteaSQLunittestthroughthetSQLtframework.Readmore» SQLunittesting,Testing HowtoinstallPostgreSQLonUbuntu July13,2023 byRajendraGupta ThisarticlecoversthedifferentmethodstoinstallPostgresonUbuntu.Readmore» Development,PostgreSQL DifferentmethodsformonitoringMongoDBdatabases June14,2023 byHadiFadlallah Thisarticleexplainswhatdatabasemonitoringisandwhyitisessential.Then,itillustratesthedifferentmethodsformonitoringMongoDBNoSQLdatabases.Readmore» Monitoring,Performancecounters SQLMachineLearninginsimplewords May15,2023 byHaroonAshraf ThisarticleisaboutSQLMachineLearningwhichisoneofthemostinterestingtopicsequallyattractivetobothbeginnersandprofessionalsofdifferentareasofexpertise.Readmore» Machinelearning,Python IntroductiontotheSQLStandardDeviationfunction April21,2023 byGauriMahajan Inthisarticle,wewilllearnaboutoneoftheimportantstatisticalfunctions,theSQLStandardDeviationfunction.Readmore» Functions,T-SQL Howtodoagroupbyclause April12,2023 byManvendraSingh Today,IamgoingtoexplainhowtodoagroupbyclauseinyourSQLqueries.SQL(StructuredQueryLangue)isaverypopularquerylanguethatiswidelyusedtoaccessandmanipulaterecordsstoredinadatabase.TheGROUPBYclauseisalsoaSQLstatementthatisusedtogroupidenticalvalues.Let’sfirstunderstandthisclausewhatitdoesandwhyweusethisclauseinSQLqueries.Readmore» T-SQL PostgreSQLTutorialforbeginners April6,2023 byDanielCalbimonte IntroductiontothePostgreSQLtutorialInthisarticle,wewillheatutorialtolearnPostgreSQL.AccordingtoStatista,PostgreSQListhe4thmostpopulardatabaseintheworld(theotheronesareOracle,SQLServer,andMySQL).ThatiswhywethinkitisanimportantDBMStolearn.Readmore» PostgreSQL MySQLgroup_concat()functionoverview March28,2023 byRahulMehta ThisarticlewillprovideanunderstandingofhowtoeffectivelyusegroupconcatenationinMySQL.Readmore» MySQL,StringConcatenation UnderstandingSubstringinOracleSQL March22,2023 byArindamMondal TheOracleSQLdatabaseprovidesmanyusefulfunctionstousewithyourqueryorprogramming.TheSUBSTRfunctionisoneofthemostusedstringfunctionsintheOracleSQLdatabase.IwillalsodiscussafewimportantstringfunctionsTRIM,UPPER,andLOWERwhichcanbeusedalongwithsubstringfunctions.Inthisarticle,wewilldiscusssubstringinOracleSQL.Readmore» Oracle PostgreSQLvsMySQL:Understandingtheirdifferences March13,2023 byManvendraSingh Today,wewillcomparethetwomostpopulardatabaseproductsPostgreSQLvsMySQL,andexplainthedifferencesbetweentheminthisarticle.Therearemanydatabasesystemsbasedontherelationsdatabasemanementsystem(RDBMS)conceptinthemarket.SomeofthemareOracle,SQLServer,MySQL,PostgreSQL,etc.It’sreallyimportanttounderstandthedifferencesbetweenthembeforeselectinganydatabaseproductforyourapplication.Keepingthisinmind,Iamwritingthisarticletoexplainthesetwodatabasesystemsi.e.,PostgreSQLvsMySQL,andcomparethemfromvariousaspectssothatyoucanunderstandthembeforetakinganydecisionforyourrequirements.Readmore» MySQL,PostgreSQL UnderstandingtheScalabilityinOracleDatabase March9,2023 byRandheerParmar Whenanapplicationgrowstheassociateddatabasegrowsautomatically.Itneedstobescaledtoalargermachineorserverandoverallconfigurationneedstobeincreasedtohandletheapplicationanddatabaseperformancerequirement.Readmore» Databasedevelopment,Oracle LearnSQL:Insertmultiplerowscommands March6,2023 byHadiFadlallah ThisarticleexplainsthedifferentapproachesusedtoinsertmultiplerowsintoSQLServertables.Readmore» T-SQL Pe1of10512345...102030...»Last» Followus! PopularSQLPARTITIONBYClauseoverviewSQLConvertDatefunctionsandformatsSQLVariables:BasicsanduseDifferentwaystoSQLdeleteduplicaterowsfromaSQLTableSQLWHILEloopwithsimpleexamplesSQLServertablehints–WITH(NOLOCK)bestpracticesOverviewofSQLRANKfunctionsUnderstandingtheSQLMERGEstatementTheTableVariableinSQLServerSELECTINTOTEMPTABLEstatementinSQLServerHowtoidentifyandresolveSQLServerIndexFrmentationSQLServerfunctionsforconvertingaStringtoaDateHowtoUPDATEfromaSELECTstatementinSQLServerSQLmultiplejoinsforbeginnerswithexamplesUnderstandingtheSQLDecimaldatatypeSQLBooleanTutorialHowtobackupandrestoreMySQLdatabasesusingthemysqldumpcommandSQLCROSSJOINwithexamplesImplementingSlowlyChangingDimensions(SCDs)inDataWarehousesSQLServerCommonTableExpressions(CTE)TrendingSQLServerTransactionLogBackup,TruncateandShrinkOperationsSixdifferentmethodstocopytablesbetweendatabasesinSQLServerHowtoimplementerrorhandlinginSQLServerWorkingwiththeSQLServercommandline(sqlcmd)MethodstooidtheSQLdividebyzeroerrorQueryoptimizationtechniquesinSQLServer:tipsandtricksHowtocreateandconfigurealinkedserverinSQLServerManementStudioSQLreplace:HowtoreplaceASCIIspecialcharactersinSQLServerHowtoidentifyslowrunningqueriesinSQLServerSQLvarchardatatypedeepdiveHowtoimplementarray-likefunctionalityinSQLServerAllaboutlockinginSQLServerSQLServerstoredproceduresforbeginnersDatabasetablepartitioninginSQLServerHowtodroptemptablesinSQLServerHowtodeterminefreespaceandfilesizeforSQLServerdatabasesUsingPowerShelltosplitastringintoanarrayKILLSPIDcommandinSQLServerHowtoinstallSQLServerExpresseditionSQLUnionoverview,useandexamplesSolutionsReadaSQLServertransactionlogSQLServerdatabaseauditingtechniquesHowtorecoverSQLServerdatafromaccidentalUPDATEandDELETEoperationsHowtoquicklysearchforSQLdatabasedataandobjectsSynchronizeSQLServerdatabasesindifferentremotesourcesRecoverSQLdatafromadroppedtablewithoutbackupsHowtorestorespecifictable(s)fromaSQLServerdatabasebackupRecoverdeletedSQLdatafromtransactionlogsHowtorecoverSQLServerdatafromaccidentalupdateswithoutbackupsAutomaticallycompareandsynchronizeSQLServerdataOpenLDFfileandviewLDFfilecontentQuicklyconvertSQLcodetolangue-specificclientcodeHowtorecoverasingletablefromaSQLServerdatabasebackupRecoverdatalostduetoaTRUNCATEoperationwithoutbackupsHowtorecoverSQLServerdatafromaccidentalDELETE,TRUNCATEandDROPoperationsRevertingyourSQLServerdatabasebacktoaspecificpointintimeHowtocreateSSISpackedocumentationMigrateaSQLServerdatabasetoanewerversionofSQLServerHowtorestoreaSQLServerdatabasebackuptoanolderversionofSQLServerHelpersandbestpracticesBIperformancecounters SQLcodesmellsrulesSQLServerwaittypes  ©QuestSoftwareInc.ALLRIGHTSRESERVED. | GDPR | TermsofUse | Privacy /**//**/(function(){ varexpirationDate=newDate(); expirationDate.setTime(expirationDate.getTime()+*1000); document.cookie="pll_langue=en;expires="+expirationDate.toUTCString()+";path=/;SameSite=Lax"; }()); checkCookieExist();varbeforeBannner=jQuery("#custom_html-2");varbeforeBannnerHeight=jQuery("#custom_html-2").height();jQuery(window).on('scroll',function(){ if(jQuery(window).width()>=1001) { jQuery(window).scroll(function(){ varbanner=jQuery('#text-7'); varwindow_offset=banner.offset().top-jQuery(window).scrollTop(); if(window_offset=0){ jQuery('#text-7').css('position','relative'); jQuery('#text-7').css('top',''); } }); } });