SQL Shack - Artikel über Datenbankprüfung, Serverleistung, Datenwiederaufnahme und mehr

etwa 5000~500000

181

Ruhm und Reichtum. Wohlstand und Reichtum Ji

1

3.136.173.2

(window.NREUM||(NREUM={})).init={privacy:{cookies_enabled:true},ajax:{deny_list:["bam.nr-data.net"]},distributed_tracing:{enabled:true}};(window.NREUM||(NREUM={})).loader_config={entID:"69",accountID:"",trustKey:"",xpid:"VgYHVVBbChABU1ZXDwMPUlAB",licenseKey:"c27add20bd",applicationID:"40"};;/*!Forlicenseinformationpleaseseenr-loader-spa-1.261.2.min.js.LICENSE.txt*/(()=>{vare,t,r={2983:(e,t,r)=>{"usestrict";r.d(t,{D0:()=>v,gD:()=>y,Vp:()=>s,oC:()=>x,fr:()=>_,jD:()=>C,hR:()=>T,xN:()=>b,x1:()=>c,aN:()=>A,V:()=>j});varn=r(384),i=r(7864);consto={beacon:n.NT.beacon,errorBeacon:n.NT.errorBeacon,licenseKey:void0,applicationID:void0,sa:void0,queueTime:void0,applicationTime:void0,ttGuid:void0,user:void0,account:void0,product:void0,extra:void0,jsAttributes:{},userAttributes:void0,atts:void0,transactionName:void0,tNamePlain:void0},a={};functions(e){if(!e)thrownewError("Allinfoobjectsrequireanentidentifier!");if(!a[e])thrownewError("Infofor".concat(e,"wasneverset"));returna[e]}functionc(e,t){if(!e)thrownewError("Allinfoobjectsrequireanentidentifier!");a[e]=(0,i.a)(t,o);constr=(0,n.nY)(e);r&&(r.info=a[e])}varu=r(993);constd=e=>{if(!e||"string"!=typeofe)return!1;try{document.createDocumentFrment().querySelector(e)}catch{return!1}return!0};varl=r(2614),f=r(944);consth="[data-nr-mask]",g=()=>{conste={mask_selector:"*",block_selector:"[data-nr-block]",mask_input_options:{color:!1,date:!1,"datetime-local":!1,email:!1,month:!1,number:!1,range:!1,search:!1,tel:!1,text:!1,time:!1,url:!1,week:!1,textarea:!1,select:!1,password:!0}};return{ajax:{deny_list:void0,block_internal:!0,enabled:!0,harvestTimeSeconds:10,autoStart:!0},distributed_tracing:{enabled:void0,exclude_newrelic_header:void0,cors_use_newrelic_header:void0,cors_use_tracecontext_headers:void0,allowed_origins:void0},feature_fls:[],harvest:{tooManyRequestsDelay:60},jserrors:{enabled:!0,harvestTimeSeconds:10,autoStart:!0},logging:{enabled:!0,harvestTimeSeconds:10,autoStart:!0,level:u.p_.INFO},metrics:{enabled:!0,autoStart:!0},obfuscate:void0,pe_action:{enabled:!0,harvestTimeSeconds:30,autoStart:!0},pe_view_event:{enabled:!0,autoStart:!0},pe_view_timing:{enabled:!0,harvestTimeSeconds:30,long_task:!1,autoStart:!0},privacy:{cookies_enabled:!0},proxy:{assets:void0,beacon:void0},session:{expiresMs:l.wk,inactiveMs:l.BB},session_replay:{autoStart:!0,enabled:!1,harvestTimeSeconds:60,preload:!1,sampling_rate:10,error_sampling_rate:100,collect_fonts:!1,inline_imes:!1,inline_stylesheet:!0,mask_all_inputs:!0,getmask_text_selector(){returne.mask_selector},setmask_text_selector(t){d(t)?e.mask_selector="".concat(t,",").concat(h):""===t||null===t?e.mask_selector=h:(0,f.R)("Aninvalidsession_replay.mask_selectorwasprovided.'*'willbeused.",t)},getblock_class(){return"nr-block"},getignore_class(){return"nr-ignore"},getmask_text_class(){return"nr-mask"},getblock_selector(){returne.block_selector},setblock_selector(t){d(t)?e.block_selector+=",".concat(t):""!==t&&(0,f.R)("Aninvalidsession_replay.block_selectorwasprovidedandwillnotbeused",t)},getmask_input_options(){returne.mask_input_options},setmask_input_options(t){t&&"object"==typeoft?e.mask_input_options={...t,password:!0}:(0,f.R)("Aninvalidsession_replay.mask_input_optionwasprovidedandwillnotbeused",t)}},session_trace:{enabled:!0,harvestTimeSeconds:10,autoStart:!0},soft_nigations:{enabled:!0,harvestTimeSeconds:10,autoStart:!0},spa:{enabled:!0,harvestTimeSeconds:10,autoStart:!0},ssl:void0}},p={},m="Allconfigurationobjectsrequireanentidentifier!";functionv(e){if(!e)thrownewError(m);if(!p[e])thrownewError("Configurationfor".concat(e,"wasneverset"));returnp[e]}functionb(e,t){if(!e)thrownewError(m);p[e]=(0,i.a)(t,g());constr=(0,n.nY)(e);r&&(r.init=p[e])}functiony(e,t){if(!e)thrownewError(m);varr=v(e);if(r){for(varn=t.split("."),i=0;i{"usestrict";r.d(t,{a:()=>i});varn=r(944);functioni(e,t){try{if(!e||"object"!=typeofe)return(0,n.R)("SettingaConfigurablerequiresanobjectasinput");if(!t||"object"!=typeoft)return(0,n.R)("SettingaConfigurablerequiresamodeltosetitsinitialproperties");constr=Object.create(Object.getPrototypeOf(t),Object.getOwnPropertyDescriptors(t)),o=0===Object.keys(r).length?e:r;for(letaino)if(void0!==e[a])try{if(null===e[a]){r[a]=null;continue}Array.isArray(e[a])&&Array.isArray(t[a])?r[a]=Array.from(newSet([...e[a],...t[a]])):"object"==typeofe[a]&&"object"==typeoft[a]?r[a]=i(e[a],t[a]):r[a]=e[a]}catch(e){(0,n.R)("AnerroroccurredwhilesettingapropertyofaConfigurable",e)}returnr}catch(e){(0,n.R)("AnerroroccuredwhilesettingaConfigurable",e)}}},9324:(e,t,r)=>{"usestrict";r.d(t,{F3:()=>i,Xs:()=>o,Yq:()=>a,xv:()=>n});constn="1.261.2",i="PROD",o="CDN",a="2.0.0-alpha.12"},6154:(e,t,r)=>{"usestrict";r.d(t,{A4:()=>s,OF:()=>d,RI:()=>i,Vr:()=>g,WN:()=>p,bv:()=>o,gm:()=>a,lR:()=>f,lT:()=>h,m:()=>u,mw:()=>c,sb:()=>l});varn=r(1863);consti="undefined"!=typeofwindow&&!!window.document,o="undefined"!=typeofWorkerGlobalScope&&("undefined"!=typeofself&&selfinstanceofWorkerGlobalScope&&self.nigatorinstanceofWorkerNigator||"undefined"!=typeofglobalThis&&globalThisinstanceofWorkerGlobalScope&&globalThis.nigatorinstanceofWorkerNigator),a=i?window:"undefined"!=typeofWorkerGlobalScope&&("undefined"!=typeofself&&selfinstanceofWorkerGlobalScope&&self||"undefined"!=typeofglobalThis&&globalThisinstanceofWorkerGlobalScope&&globalThis),s="complete"===a?.document?.readyState,c=Boolean("hidden"===a?.document?.visibilityState),u=""+a?.location,d=/iPad|iPhone|iPod/.test(a.nigator?.userent),l=d&&"undefined"==typeofSharedWorker,f=(()=>{conste=a.nigator?.userent?.match(/Firefox[/\s](\d+\.\d+)/);returnArray.isArray(e)&&e.length>=2?+e[1]:0})(),h=Boolean(i&&window.document.documentMode),g=!!a.nigator?.sendBeacon,p=Date.now()-(0,n.t)()},4777:(e,t,r)=>{"usestrict";r.d(t,{J:()=>o});varn=r(944);consti={entIdentifier:"",ee:void0};classo{constructor(e){try{if("object"!=typeofe)return(0,n.R)("sharedcontextrequiresanobjectasinput");this.sharedContext={},Object.assign(this.sharedContext,i),Object.entries(e).forEach((e=>{let[t,r]=e;Object.keys(i).includes(t)&&(this.sharedContext[t]=r)}))}catch(e){(0,n.R)("AnerroroccurredwhilesettingSharedContext",e)}}}},7295:(e,t,r)=>{"usestrict";r.d(t,{Xv:()=>a,gX:()=>i,iW:()=>o});varn=[];functioni(e){if(!e||o(e))return!1;if(0===n.length)return!0;for(vart=0;tt.length)&&t.indexOf(e)===t.length-e.length}functionc(e,t){return0===e.indexOf("/")&&(e=e.substring(1)),0===t.indexOf("/")&&(t=t.substring(1)),""===e||e===t}},1687:(e,t,r)=>{"usestrict";r.d(t,{Ak:()=>c,Ze:()=>l,x3:()=>u});varn=r(7836),i=r(1478),o=r(3606),a=r(860);consts={};functionc(e,t){constr={sted:!1,priority:a.P[t]||0};d(e),s[e].get(t)||s[e].set(t,r)}functionu(e,t){d(e),s[e].get(t)&&s[e].delete(t),s[e].size&&f(e)}functiond(e){if(!e)thrownewError("entIdentifierrequired");s[e]||(s[e]=newMap)}functionl(){lete=arguments.length>0&&void0!==arguments[0]?arguments[0]:"",t=arguments.length>1&&void0!==arguments[1]?arguments[1]:"feature",r=arguments.length>2&&void0!==arguments[2]&&arguments[2];if(d(e),!e||!s[e].get(t)||r)returnh(e,t);s[e].get(t).sted=!0,f(e)}functionf(e){constt=Array.from(s[e]);t.every((e=>{let[t,r]=e;returnr.sted}))&&(t.sort(((e,t)=>e[1].priority-t[1].priority)),t.forEach((t=>{let[r]=t;s[e].delete(r),h(e,r)})))}functionh(e,t){constr=e?n.ee.get(e):n.ee,a=o.i.handlers;if(r.backlog&&a){vars=r.backlog[t],c=a[t];if(c){for(varu=0;s&&u{"usestrict";r.d(t,{P:()=>c,ee:()=>u});varn=r(384),i=r(8990),o=r(2983),a=r(2646),s=r(5607);constc="nr@context:".concat(s.W),u=functione(t,r){varn={},s={},d={},l=!1;try{l=16===r.length&&(0,o.fr)(r).isolatedBacklog}catch(e){}varf={on:g,addEventListener:g,removeEventListener:function(e,t){varr=n[e];if(!r)return;for(vari=0;i{deletef.backlog[e]}))},isBuffering:function(e){return!!v()[s[e]]},debugId:r,backlog:l?{}:t&&"object"==typeoft.backlog?t.backlog:{},isolatedBacklog:l};returnObject.defineProperty(f,"aborted",{get:()=>{lete=f._aborted||!1;returne||(t&&(e=t.aborted),e)}}),f;functionh(e){returne&&einstanceofa.y?e:e?(0,i.I)(e,c,(()=>newa.y(c))):newa.y(c)}functiong(e,t){n[e]=p(e).concat(t)}functionp(e){returnn[e]||[]}functionm(t){returnd[t]=d[t]||e(f,t)}functionv(){returnf.backlog}}(void0,"globalEE"),d=(0,n.Zm)();d.ee||(d.ee=u)},2646:(e,t,r)=>{"usestrict";r.d(t,{y:()=>n});classn{constructor(e){this.contextId=e}}},9908:(e,t,r)=>{"usestrict";r.d(t,{d:()=>n,p:()=>i});varn=r(7836).ee.get("handle");functioni(e,t,r,i,o){o?(o.buffer([e],i),o.emit(e,t,r)):(n.buffer([e],i),n.emit(e,t,r))}},3606:(e,t,r)=>{"usestrict";r.d(t,{i:()=>o});varn=r(9908);o.on=a;vari=o.handlers={};functiono(e,t,r,o){a(o||n.d,i,e,t,r)}functiona(e,t,r,i,o){o||(o="feature"),e||(e=n.d);vara=t[o]=t[o]||{};(a[r]=a[r]||[]).push([e,i])}},3878:(e,t,r)=>{"usestrict";r.d(t,{DD:()=>c,jT:()=>a,sp:()=>s});varn=r(6154);leti=!1,o=!1;try{conste={getpassive(){returni=!0,!1},getsignal(){returno=!0,!1}};n.gm.addEventListener("test",null,e),n.gm.removeEventListener("test",null,e)}catch(e){}functiona(e,t){returni||o?{capture:!!e,passive:i,signal:t}:!!e}functions(e,t){letr=arguments.length>2&&void0!==arguments[2]&&arguments[2],n=arguments.length>3?arguments[3]:void0;window.addEventListener(e,t,a(r,n))}functionc(e,t){letr=arguments.length>2&&void0!==arguments[2]&&arguments[2],n=arguments.length>3?arguments[3]:void0;document.addEventListener(e,t,a(r,n))}},5607:(e,t,r)=>{"usestrict";r.d(t,{W:()=>n});constn=(0,r(9566).bz)()},9566:(e,t,r)=>{"usestrict";r.d(t,{LA:()=>s,ZF:()=>c,bz:()=>a,el:()=>u});varn=r(6154);consti="xxxxxxxx-xxxx-4xxx-yxxx-xxxxxxxxxxxx";functiono(e,t){returne?15&e[t]:16*Math.random()|0}functiona(){conste=n.gm?.crypto||n.gm?.msCrypto;lett,r=0;returne&&e.getRandomValues&&(t=e.getRandomValues(newUint8Array(30))),i.split("").map((e=>"x"===e?o(t,r++).toString(16):"y"===e?(3&o()|8).toString(16):e)).join("")}functions(e){constt=n.gm?.crypto||n.gm?.msCrypto;letr,i=0;t&&t.getRandomValues&&(r=t.getRandomValues(newUint8Array(e)));consta=[];for(vars=0;s{"usestrict";r.d(t,{BB:()=>a,H3:()=>n,g:()=>u,iL:()=>c,tS:()=>s,uh:()=>i,wk:()=>o});constn="NRBA",i="SESSION",o=144e5,a=18e5,s={STARTED:"session-started",PAUSE:"session-pause",RESET:"session-reset",RESUME:"session-resume",UPDATE:"session-update"},c={SAME_TAB:"same-tab",CROSS_TAB:"cross-tab"},u={OFF:0,FULL:1,ERROR:2}},1863:(e,t,r)=>{"usestrict";functionn(){returnMath.floor(performance.now())}r.d(t,{t:()=>n})},7485:(e,t,r)=>{"usestrict";r.d(t,{D:()=>i});varn=r(6154);functioni(e){if(0===(e||"").indexOf("data:"))return{protocol:"data"};try{constt=newURL(e,location.href),r={port:t.port,hostname:t.hostname,pathname:t.pathname,search:t.search,protocol:t.protocol.slice(0,t.protocol.indexOf(":")),sameOrigin:t.protocol===n.gm?.location?.protocol&&t.host===n.gm?.location?.host};returnr.port&&""!==r.port||("http:"===t.protocol&&(r.port="80"),":"===t.protocol&&(r.port="443")),r.pathname&&""!==r.pathname?r.pathname.startsWith("/")||(r.pathname="/".concat(r.pathname)):r.pathname="/",r}catch(e){return{}}}},944:(e,t,r)=>{"usestrict";functionn(e,t){"function"==typeofconsole.warn&&(console.warn("NewRelic:".concat(e)),t&&console.warn(t))}r.d(t,{R:()=>n})},5284:(e,t,r)=>{"usestrict";r.d(t,{t:()=>c,B:()=>s});varn=r(7836),i=r(6154);consto="newrelic";consta=newSet,s={};functionc(e,t){constr=n.ee.get(t);s[t]??={},e&&"object"==typeofe&&(a.has(t)||(r.emit("rumresp",[e]),s[t]=e,a.add(t),function(){lete=arguments.length>0&&void0!==arguments[0]?arguments[0]:{};try{i.gm.dispatchEvent(newCustomEvent(SQL Shack - Artikel über Datenbankprüfung, Serverleistung, Datenwiederaufnahme und mehro,{detail:e}))}catch(e){}}({loaded:!0})))}},8990:(e,t,r)=>{"usestrict";r.d(t,{I:()=>i});varn=Object.prototype.hasOwnProperty;functioni(e,t,r){if(n.call(e,t))returne[t];vari=r();if(Object.defineProperty&&Object.keys)try{returnObject.defineProperty(e,t,{value:i,writable:!0,enumerable:!1}),i}catch(e){}returne[t]=i,i}},6389:(e,t,r)=>{"usestrict";functionn(e){vart=this;letr=arguments.length>1&&void0!==arguments[1]?arguments[1]:500,n=arguments.length>2&&void0!==arguments[2]?arguments[2]:{};consti=n?.leading||!1;leto;returnfunction(){for(varn=arguments.length,a=newArray(n),s=0;s{o=clearTimeout(o)}),r)),i||(clearTimeout(o),o=setTimeout((()=>{e.apply(t,a)}),r))}}functioni(e){vart=this;letr=!1;returnfunction(){if(!r){r=!0;for(varn=arguments.length,i=newArray(n),o=0;oi,s:()=>n})},1478:(e,t,r)=>{"usestrict";r.d(t,{$:()=>n});constn=(e,t)=>Object.entries(e||{}).map((e=>{let[r,n]=e;returnt(r,n)}))},3304:(e,t,r)=>{"usestrict";r.d(t,{A:()=>o});varn=r(7836);consti=()=>{conste=newWeakSet;return(t,r)=>{if("object"==typeofr&&null!==r){if(e.has(r))return;e.add(r)}returnr}};functiono(e){try{returnJSON.stringify(e,i())}catch(e){try{n.ee.emit("internal-error",[e])}catch(e){}}}},5289:(e,t,r)=>{"usestrict";r.d(t,{GG:()=>o,sB:()=>a});varn=r(3878);functioni(){return"undefined"==typeofdocument||"complete"===document.readyState}functiono(e,t){if(i())returne();(0,n.sp)("load",e,t)}functiona(e){if(i())returne();(0,n.DD)("DOMContentLoaded",e)}},384:(e,t,r)=>{"usestrict";r.d(t,{NT:()=>o,US:()=>d,Zm:()=>a,bQ:()=>c,dV:()=>s,nY:()=>u,pV:()=>l});varn=r(6154),i=r(1863);consto={beacon:"bam.nr-data.net",errorBeacon:"bam.nr-data.net"};functiona(){returnn.gm.NREUM||(n.gm.NREUM={}),void0===n.gm.newrelic&&(n.gm.newrelic=n.gm.NREUM),n.gm.NREUM}functions(){lete=a();returne.o||(e.o={ST:n.gm.setTimeout,SI:n.gm.setImmediate,CT:n.gm.clearTimeout,XHR:n.gm.XML,REQ:n.gm.Request,EV:n.gm.Event,PR:n.gm.Promise,MO:n.gm.MutationObserver,FETCH:n.gm.fetch}),e}functionc(e,t){letr=a();r.initializedents??={},t.initializedAt={ms:(0,i.t)(),date:newDate},r.initializedents[e]=t}functionu(e){lett=a();returnt.initializedents?.[e]}functiond(e,t){a()[e]=t}functionl(){returnfunction(){lete=a();constt=e.info||{};e.info={beacon:o.beacon,errorBeacon:o.errorBeacon,...t}}(),function(){lete=a();constt=e.init||{};e.init={...t}}(),s(),function(){lete=a();constt=e.loader_config||{};e.loader_config={...t}}(),a()}},2843:(e,t,r)=>{"usestrict";r.d(t,{u:()=>i});varn=r(3878);functioni(e){lett=arguments.length>1&&void0!==arguments[1]&&arguments[1],r=arguments.length>2?arguments[2]:void0,i=arguments.length>3?arguments[3]:void0;(0,n.DD)("visibilitychange",(function(){if(t)returnvoid("hidden"===document.visibilityState&&e());e(document.visibilityState)}),r,i)}},8941:(e,t,r)=>{"usestrict";r.d(t,{um:()=>f,NZ:()=>R,vC:()=>T,Ri:()=>O,Ak:()=>_,o8:()=>C,MO:()=>K,bX:()=>V});varn=r(7836),i=r(3434),o=r(8990),a=r(6154);consts={},c=a.gm.XML,u="addEventListener",d="removeEventListener",l="nr@wrapped:".concat(n.P);functionf(e){vart=function(e){return(e||n.ee).get("events")}(e);if(s[t.debugId]++)returnt;s[t.debugId]=1;varr=(0,i.YM)(t,!0);functionf(e){r.inPlace(e,[u,d],"-",g)}functiong(e,t){returne[1]}return"getPrototypeOf"inObject&&(a.RI&&h(document,f),h(a.gm,f),h(c.prototype,f)),t.on(u+"-start",(function(e,t){varn=e[1];if(null!==n&&("function"==typeofn||"object"==typeofn)){vari=(0,o.I)(n,l,(function(){vare={object:function(){if("function"!=typeofn.handleEvent)return;returnn.handleEvent.apply(n,arguments)},function:n}[typeofn];returne?r(e,"fn-",null,e.name||"anonymous"):n}));this.wrapped=e[1]=i}})),t.on(d+"-start",(function(e){e[1]=this.wrapped||e[1]})),t}functionh(e,t){letr=e;for(;"object"==typeofr&&!Object.prototype.hasOwnProperty.call(r,u);)r=Object.getPrototypeOf(r);for(varn=arguments.length,i=newArray(n>2?n-2:0),o=2;o{r(v[y],e,p),r(b[y],e,p)})),r(a.gm,"fetch",g),t.on(g+"end",(function(e,r){varn=this;if(r){vari=r.headers.get("content-length");null!==i&&(n.rxSize=i),t.emit(g+"done",[null,r],n)}elset.emit(g+"done",[e],n)})),t}constx={},A=["pushState","replaceState"];functionT(e){constt=function(e){return(e||n.ee).get("history")}(e);return!a.RI||x[t.debugId]++||(x[t.debugId]=1,(0,i.YM)(t).inPlace(window.history,A,"-")),t}varE=r(3878);constS={},N=["appendChild","insertBefore","replaceChild"];functionO(e){constt=function(e){return(e||n.ee).get("jsonp")}(e);if(!a.RI||S[t.debugId])returnt;S[t.debugId]=!0;varr=(0,i.YM)(t),o=/[?&](?:callback|cb)=([^]+)/,s=/(.*)\.([^.]+)/,c=/^(\w+)(\.|$)(.*)$/;functionu(e,t){if(!e)returnt;constr=e.match(c),n=r[1];returnu(r[3],t[n])}returnr.inPlace(Node.prototype,N,"dom-"),t.on("dom-start",(function(e){!function(e){if(!e||"string"!=typeofe.nodeName||"script"!==e.nodeName.toLowerCase())return;if("function"!=typeofe.addEventListener)return;varn=(i=e.src,a=i.match(o),a?a[1]:null);vari,a;if(!n)return;varc=function(e){vart=e.match(s);if(t&&t.length>=3)return{key:t[2],parent:u(t[1],window)};return{key:e,parent:window}}(n);if("function"!=typeofc.parent[c.key])return;vard={};functionl(){t.emit("jsonp-end",[],d),e.removeEventListener("load",l,(0,E.jT)(!1)),e.removeEventListener("error",f,(0,E.jT)(!1))}functionf(){t.emit("jsonp-error",[],d),t.emit("jsonp-end",[],d),e.removeEventListener("load",l,(0,E.jT)(!1)),e.removeEventListener("error",f,(0,E.jT)(!1))}r.inPlace(c.parent,[c.key],"cb-",d),e.addEventListener("load",l,(0,E.jT)(!1)),e.addEventListener("error",f,(0,E.jT)(!1)),t.emit("new-jsonp",[e.src],d)}(e[0])})),t}constI={};function_(e){constt=function(e){return(e||n.ee).get("mutation")}(e);if(!a.RI||I[t.debugId])returnt;I[t.debugId]=!0;varr=(0,i.YM)(t),o=a.gm.MutationObserver;returno&&(window.MutationObserver=function(e){returnthisinstanceofo?newo(r(e,"fn-")):o.apply(this,arguments)},MutationObserver.prototype=o.prototype),t}constj={};functionC(e){constt=function(e){return(e||n.ee).get("promise")}(e);if(j[t.debugId])returnt;j[t.debugId]=!0;varr=t.context,o=(0,i.YM)(t),s=a.gm.Promise;returns&&function(){functione(r){varn=t.context(),i=o(r,"executor-",n,null,!1);consta=Reflect.construct(s,[i],e);returnt.context(a).getCtx=function(){returnn},a}a.gm.Promise=e,Object.defineProperty(e,"name",{value:"Promise"}),e.toString=function(){returns.toString()},Object.setPrototypeOf(e,s),["all","race"].forEach((function(r){constn=s[r];e[r]=function(e){leti=!1;[...e||[]].forEach((e=>{this.resolve(e).then(a("all"===r),a(!1))}));consto=n.apply(this,arguments);returno;functiona(e){returnfunction(){t.emit("propate",[null,!i],o,!1,!1),i=i||!e}}}})),["resolve","reject"].forEach((function(r){constn=s[r];e[r]=function(e){constr=n.apply(this,arguments);returne!==r&&t.emit("propate",[e,!0],r,!1,!1),r}})),e.prototype=s.prototype;constn=s.prototype.then;s.prototype.then=function(){vare=this,i=r(e);i.promise=e;for(vara=arguments.length,s=newArray(a),c=0;c3&&!i.resolved&&(i.resolved=!0,r.emit("xhr-resolved",[],e)),o.inPlace(e,h,"fn-",R)}),(0,E.jT)(!1))}catch(e){(0,F.R)("AnerroroccurredwhileinterceptingXHR",e);try{r.emit("internal-error",[e])}catch(e){}}vari;returnt};functionm(e,t){o.inPlace(t,["onreadystatechange"],"fn-",R)}if(function(e,t){for(varrine)t[r]=e[r]}(s,p),p.prototype=s.prototype,o.inPlace(p.prototype,G,"-xhr-",R),r.on("send-xhr-start",(function(e,t){m(e,t),function(e){g.push(e),c&&(v?v.then(w):d?d(w):(b=-b,y.data=b))}(t)})),r.on("open-xhr-start",m),c){varv=u&&u.resolve();if(!d&&!u){varb=1,y=document.createTextNode(b);newc(w).observe(y,{characterData:!0})}}elset.on("fn-end",(function(e){e[0]&&e[0].type===l||w()}));functionw(){for(vare=0;e{"usestrict";r.d(t,{Jt:()=>o,YM:()=>c});varn=r(7836),i=r(5607);consto="nr@original:".concat(i.W);vara=Object.prototype.hasOwnProperty,s=!1;functionc(e,t){returne||(e=n.ee),r.inPlace=function(e,t,n,i,o){n||(n="");consta="-"===n.charAt(0);for(lets=0;s{"usestrict";r.d(t,{T:()=>n});constn=r(860).K.ajax},6774:(e,t,r)=>{"usestrict";r.d(t,{T:()=>n});constn=r(860).K.jserrors},993:(e,t,r)=>{"usestrict";r.d(t,{ET:()=>o,It:()=>s,TZ:()=>a,YY:()=>u,bu:()=>c,p_:()=>i,zk:()=>d});varn=r(860);consti={ERROR:"ERROR",WARN:"WARN",INFO:"INFO",DEBUG:"DEBUG",TRACE:"TRACE"},o="log",a=n.K.logging,s=1e6,c="failedtowraplogger:",u="invalidloglevel:",d="ignoredlog:"},3785:(e,t,r)=>{"usestrict";r.d(t,{R:()=>d,b:()=>l});varn=r(9908),i=r(1863),o=r(944),a=r(3304),s=r(860),c=r(3969),u=r(993);functiond(e,t){letr=arguments.length>2&&void0!==arguments[2]?arguments[2]:{},d=arguments.length>3&&void0!==arguments[3]?arguments[3]:u.p_.INFO;try{if("string"!=typeoft){conste=(0,a.A)(t);t=e&&"{}"!==e?e:String(t)}}catch(e){returnvoid(0,o.R)("couldnotcastlogmessetostring",t)}(0,n.p)(c.xV,["API/logging/".concat(d.toLowerCase(),"/called")],void0,s.K.metrics,e),(0,n.p)(u.ET,[(0,i.t)(),t,r,d],void0,s.K.logging,e)}functionl(e){return"string"==typeofe&&Object.values(u.p_).some((t=>t.toUpperCase()===e.toUpperCase()))}},3969:(e,t,r)=>{"usestrict";r.d(t,{TZ:()=>n,XG:()=>s,rs:()=>i,xV:()=>a,z_:()=>o});constn=r(860).K.metrics,i="sm",o="cm",a="storeSupportabilityMetrics",s="storeEventMetrics"},8166:(e,t,r)=>{"usestrict";r.d(t,{T:()=>n});constn=r(860).K.peAction},6630:(e,t,r)=>{"usestrict";r.d(t,{T:()=>n});constn=r(860).K.peViewEvent},782:(e,t,r)=>{"usestrict";r.d(t,{T:()=>n});constn=r(860).K.peViewTiming},6344:(e,t,r)=>{"usestrict";r.d(t,{BB:()=>f,G4:()=>o,It:()=>c,No:()=>u,Qb:()=>h,TZ:()=>i,Ug:()=>a,_s:()=>s,bc:()=>l,yP:()=>d});varn=r(2614);consti=r(860).K.sessionReplay,o={RECORD:"recordReplay",PAUSE:"pauseReplay",REPLAY_RUNNING:"replayRunning",ERROR_DURING_REPLAY:"errorDuringReplay"},a=.12,s={DomContentLoaded:0,Load:1,FullSnapshot:2,IncrementalSnapshot:3,Meta:4,Custom:5},c=1e6,u=64e3,d={[n.g.ERROR]:15e3,[n.g.FULL]:3e5,[n.g.OFF]:0},l={RESET:{messe:"Sessionwasreset",sm:"Reset"},IMPORT:{messe:"Recorderfailedtoimport",sm:"Import"},TOO_MANY:{messe:"429:TooManyRequests",sm:"Too-Many"},TOO_BIG:{messe:"Payloadwastoolarge",sm:"Too-Big"},CROSS_TAB:{messe:"SessionEntitywassettoOFFonanothertab",sm:"Cross-Tab"},ENTITLEMENTS:{messe:"SessionReplayisnotallowedandwillnotbestarted",sm:"Entitlement"}},f=5e3,h={API:"api"}},5270:(e,t,r)=>{"usestrict";r.d(t,{Aw:()=>s,CT:()=>c,SR:()=>a});varn=r(2983),i=r(7767),o=r(6154);functiona(e){return!!n.hR.MO&&(0,i.V)(e)&&!0===(0,n.gD)(e,"session_trace.enabled")}functions(e){return!0===(0,n.gD)(e,"session_replay.preload")&&a(e)}functionc(e,t){constr=t.correctAbsoluteTimestamp(e);return{originalTimestamp:e,correctedTimestamp:r,timestampDiff:e-r,originTime:o.WN,correctedOriginTime:t.correctedOriginTime,originTimeDiff:Math.floor(o.WN-t.correctedOriginTime)}}},3738:(e,t,r)=>{"usestrict";r.d(t,{He:()=>i,Kp:()=>s,Lc:()=>u,Rz:()=>d,TZ:()=>n,bD:()=>o,d3:()=>a,jx:()=>l,uP:()=>c});constn=r(860).K.sessionTrace,i="bstResource",o="resource",a="-start",s="-end",c="fn"+a,u="fn"+s,d="pushState",l=1e3},3962:(e,t,r)=>{"usestrict";r.d(t,{AM:()=>o,O2:()=>s,Qu:()=>c,TZ:()=>a,ih:()=>u,tC:()=>i});varn=r(860);consti=["click","keydown","submit"],o="api",a=n.K.softN,s={INITIAL_PE_LOAD:"",ROUTE_CHANGE:1,UNSPECIFIED:2},c={INTERACTION:1,AJAX:2,CUSTOM_END:3,CUSTOM_TRACER:4},u={IP:"inprogress",FIN:"finished",CAN:"cancelled"}},7378:(e,t,r)=>{"usestrict";r.d(t,{$p:()=>x,BR:()=>b,Kp:()=>R,L3:()=>y,Lc:()=>c,NC:()=>o,SG:()=>d,TZ:()=>i,U6:()=>g,UT:()=>m,d3:()=>w,dT:()=>f,e5:()=>T,gx:()=>v,l9:()=>l,oW:()=>h,op:()=>p,rw:()=>u,tH:()=>E,uP:()=>s,wW:()=>A,xq:()=>a});varn=r(2983);consti=r(860).K.spa,o=["click","submit","keypress","keydown","keyup","change"],a=999,s="fn-start",c="fn-end",u="cb-start",d="api-ixn-",l="remaining",f="interaction",h="spaNode",g="jsonpNode",p="fetch-start",m="fetch-done",v="fetch-body-",b="jsonp-end",y=n.hR.ST,w="-start",R="-end",x="-body",A="cb"+R,T="jsTime",E="fetch"},4234:(e,t,r)=>{"usestrict";r.d(t,{W:()=>i});varn=r(7836);classi{constructor(e,t,r){this.entIdentifier=e,this.gregator=t,this.ee=n.ee.get(e),this.featureName=r,this.blocked=!1}}},7767:(e,t,r)=>{"usestrict";r.d(t,{V:()=>o});varn=r(2983),i=r(6154);consto=e=>i.RI&&!0===(0,n.gD)(e,"privacy.cookies_enabled")},425:(e,t,r)=>{"usestrict";r.d(t,{j:()=>O});varn=r(860),i=r(2983),o=r(9908),a=r(7836),s=r(1687),c=r(5289),u=r(6154),d=r(944),l=r(3969),f=r(384),h=r(6344);constg=["setErrorHandler","finished","addToTrace","addRelease","addPeAction","setCurrentRouteName","setPeViewName","setCustomAttribute","interaction","noticeError","setUserId","setApplicationVersion","start",h.G4.RECORD,h.G4.PAUSE,"log","wrapLogger"],p=["setErrorHandler","finished","addToTrace","addRelease"];varm=r(1863),v=r(2614),b=r(993),y=r(3785),w=r(2646),R=r(3434);functionx(e,t,r,n){consti=function(e){return(e||a.ee).get("logger")}(e),o=(0,R.YM)(i),s=neww.y(a.P);returns.level=n.level,s.customAttributes=n.customAttributes,o.inPlace(t,[r],"wrap-logger-",s),i}functionA(){conste=(0,f.pV)();g.forEach((t=>{e[t]=function(){for(varr=arguments.length,n=newArray(r),i=0;i1?r-1:0),i=1;i{e.exposed&&e.api[t]&&o.push(e.api[t](...n))})),o.length>1?o:o[0]}(t,...n)}}))}constT={};varE=r(5284);constS=e=>{constt=e.startsWith("http");e+="/",r.p=t?e:""+e};letN=!1;functionO(e){lett=arguments.length>1&&void0!==arguments[1]?arguments[1]:{},g=arguments.length>2?arguments[2]:void0,w=arguments.length>3?arguments[3]:void0,{init:R,info:O,loader_config:I,runtime:_={loaderType:g},exposed:j=!0}=t;constC=(0,f.pV)();O||(R=C.init,O=C.info,I=C.loader_config),(0,i.xN)(e.entIdentifier,R||{}),(0,i.aN)(e.entIdentifier,I||{}),O.jsAttributes??={},u.bv&&(O.jsAttributes.isWorker=!0),(0,i.x1)(e.entIdentifier,O);constP=(0,i.D0)(e.entIdentifier),k=[O.beacon,O.errorBeacon];N||(P.proxy.assets&&(S(P.proxy.assets),k.push(P.proxy.assets)),P.proxy.beacon&&k.push(P.proxy.beacon),A(),(0,f.US)("activatedFeatures",E.B),e.runSoftNOverSpa&&=!0===P.soft_nigations.enabled&&P.feature_fls.includes("soft_n")),_.denyList=[...P.ajax.deny_list||[],...P.ajax.block_internal?k:[]],_.ptid=e.entIdentifier,(0,i.V)(e.entIdentifier,_),void0===e.api&&(e.api=function(e,t){letf=arguments.length>2&&void0!==arguments[2]&&arguments[2];t||(0,s.Ak)(e,"api");constg={};varw=a.ee.get(e),R=w.get("tracer");T[e]=v.g.OFF,w.on(h.G4.REPLAY_RUNNING,(t=>{T[e]=t}));varA="api-",E=A+"ixn-";functionS(t,r,n,o){consta=(0,i.Vp)(e);returnnull===r?deletea.jsAttributes[t]:(0,i.x1)(e,{...a,jsAttributes:{...a.jsAttributes,[t]:r}}),I(A,n,!0,o||null===r?"session":void0)(t,r)}functionN(){}g.log=function(e){let{customAttributes:t={},level:r=b.p_.INFO}=arguments.length>1&&void0!==arguments[1]?arguments[1]:{};returnt&&"object"==typeoft||(t={}),"string"==typeofe&&e?(0,y.b)(r)?e.length>b.It?(0,d.R)(b.zk+">"+b.It+"bytes:",e.slice(0,25)+"..."):void(0,y.R)(w,e,t,r.toUpperCase()):(0,d.R)(b.YY+r,b.p_):(0,d.R)(b.zk+"invalidmesse")},g.wrapLogger=function(e,t){let{customAttributes:r={},level:n=b.p_.INFO}=arguments.length>2&&void0!==arguments[2]?arguments[2]:{};returnr&&"object"==typeofr||(r={}),"object"==typeofe&&e&&"string"==typeoft&&t&&"function"==typeofe[t]&&"object"==typeofr?(0,y.b)(n)?voidx(w,e,t,{customAttributes:r,level:n.toUpperCase()}):(0,d.R)(b.bu+b.YY+n,b.p_):(0,d.R)(b.bu+"invalidargument(s)")},p.forEach((e=>{g[e]=I(A,e,!0,"api")})),g.addPeAction=I(A,"addPeAction",!0,n.K.peAction),g.setPeViewName=function(t,r){if("string"==typeoft)return"/"!==t.charAt(0)&&(t="/"+t),(0,i.fr)(e).customTransaction=(r||"httpcustom.transaction")+t,I(A,"setPeViewName",!0)()},g.setCustomAttribute=function(e,t){letr=arguments.length>2&&void0!==arguments[2]&&arguments[2];if("string"==typeofe){if(["string","number","boolean"].includes(typeoft)||null===t)returnS(e,t,"setCustomAttribute",r);(0,d.R)("FailedtoexecutesetCustomAttribute.\nNon-nullvaluemustbeastring,numberorbooleantype,butatypeofwasprovided."))}else(0,d.R)("FailedtoexecutesetCustomAttribute.\nNamemustbeastringtype,butatypeofwasprovided."))},g.setUserId=function(e){if("string"==typeofe||null===e)returnS("enduser.id",e,"setUserId",!0);(0,d.R)("FailedtoexecutesetUserId.\nNon-nullvaluemustbeastringtype,butatypeofwasprovided."))},g.setApplicationVersion=function(e){if("string"==typeofe||null===e)returnS("application.version",e,"setApplicationVersion",!1);(0,d.R)("FailedtoexecutesetApplicationVersion.Expected,butgot."))},g.start=()=>{try{(0,o.p)(l.xV,["API/start/called"],void0,n.K.metrics,w),w.emit("manual-start-all")}catch(e){(0,d.R)("Anunexpectedissueoccurred",e)}},g[h.G4.RECORD]=function(){(0,o.p)(l.xV,["API/recordReplay/called"],void0,n.K.metrics,w),(0,o.p)(h.G4.RECORD,[],void0,n.K.sessionReplay,w)},g[h.G4.PAUSE]=function(){(0,o.p)(l.xV,["API/pauseReplay/called"],void0,n.K.metrics,w),(0,o.p)(h.G4.PAUSE,[],void0,n.K.sessionReplay,w)},g.interaction=function(e){return(newN).get("object"==typeofe?e:{})};constO=N.prototype={createTracer:function(e,t){varr={},i=this,a="function"==typeoft;return(0,o.p)(l.xV,["API/createTracer/called"],void0,n.K.metrics,w),f||(0,o.p)(E+"tracer",[(0,m.t)(),e,r],i,n.K.spa,w),function(){if(R.emit((a?"":"no-")+"fn-start",[(0,m.t)(),i,a],r),a)try{returnt.apply(this,arguments)}catch(e){constt="string"==typeofe?newError(e):e;throwR.emit("fn-err",[arguments,this,t],r),t}finally{R.emit("fn-end",[(0,m.t)()],r)}}}};functionI(e,t,r,i){returnfunction(){return(0,o.p)(l.xV,["API/"+t+"/called"],void0,n.K.metrics,w),i&&(0,o.p)(e+t,[(0,m.t)(),...arguments],r?null:this,i,w),r?void0:this}}function_(){r.e(478).then(r.bind(r,8778)).then((t=>{let{setAPI:r}=t;r(e),(0,s.Ze)(e,"api")})).catch((e=>{(0,d.R)("DownloadingruntimeAPIsfailed...",e),w.abort()}))}return["actionText","setName","setAttribute","se","ignore","onEnd","getContext","end","get"].forEach((e=>{O[e]=I(E,e,void0,f?n.K.softN:n.K.spa)})),g.setCurrentRouteName=f?I(E,"routeName",void0,n.K.softN):I(A,"routeName",!0,n.K.spa),g.noticeError=function(t,r){"string"==typeoft&&(t=newError(t)),(0,o.p)(l.xV,["API/noticeError/called"],void0,n.K.metrics,w),(0,o.p)("err",[t,(0,m.t)(),!1,r,!!T[e]],void0,n.K.jserrors,w)},u.RI?(0,c.GG)((()=>_()),!0):_(),g}(e.entIdentifier,w,e.runSoftNOverSpa)),void0===e.exposed&&(e.exposed=j),N=!0}},8374:(e,t,r)=>{r.nc=(()=>{try{returndocument?.currentScript?.nonce}catch(e){}return""})()},860:(e,t,r)=>{"usestrict";r.d(t,{K:()=>n,P:()=>i});constn={ajax:"ajax",jserrors:"jserrors",logging:"logging",metrics:"metrics",peAction:"pe_action",peViewEvent:"pe_view_event",peViewTiming:"pe_view_timing",sessionReplay:"session_replay",sessionTrace:"session_trace",softN:"soft_nigations",spa:"spa"},i={[n.peViewEvent]:1,[n.peViewTiming]:2,[n.metrics]:3,[n.jserrors]:4,[n.spa]:5,[n.ajax]:6,[n.sessionTrace]:7,[n.peAction]:8,[n.softN]:9,[n.sessionReplay]:10,[n.logging]:11}}},n={};functioni(e){vart=n[e];if(void0!==t)returnt.exports;varo=n[e]={exports:{}};returnr[e](o,o.exports,i),o.exports}i.m=r,i.d=(e,t)=>{for(varrint)i.o(t,r)&&!i.o(e,r)&&Object.defineProperty(e,r,{enumerable:!0,get:t[r]})},i.f={},i.e=e=>Promise.all(Object.keys(i.f).reduce(((t,r)=>(i.f[r](e,t),t)),[])),i.u=e=>({212:"nr-spa-compressor",249:"nr-spa-recorder",478:"nr-spa"}[e]+"-1.261.2.min.js"),i.o=(e,t)=>Object.prototype.hasOwnProperty.call(e,t),e={},t="NRBA-1.261.2.PROD:",i.l=(r,n,o,a)=>{if(e[r])e[r].push(n);else{vars,c;if(void0!==o)for(varu=document.getElementsByTName("script"),d=0;d{s.onerror=s.onload=null,clearTimeout(g);vari=e[r];if(deletee[r],s.parentNode&&s.parentNode.removeChild(s),i&&i.forEach((e=>e(n))),t)returnt(n)},g=setTimeout(h.bind(null,void0,{type:"timeout",target:s}),12e4);s.onerror=h.bind(null,s.onerror),s.onload=h.bind(null,s.onload),c&&document.head.appendChild(s)}},i.r=e=>{"undefined"!=typeofSymbol&&Symbol.toStringT&&Object.defineProperty(e,Symbol.toStringT,{value:"Module"}),Object.defineProperty(e,"__esModule",{value:!0})},i.p="js-ent.newrelic.com/",(()=>{vare={38:0,788:0};i.f.j=(t,r)=>{varn=i.o(e,t)?e[t]:void0;if(0!==n)if(n)r.push(n[2]);else{varo=newPromise(((r,i)=>n=e[t]=[r,i]));r.push(n[2]=o);vara=i.p+i.u(t),s=newError;i.l(a,(r=>{if(i.o(e,t)&&(0!==(n=e[t])&&(e[t]=void0),n)){varo=r&&("load"===r.type?"missing":r.type),a=r&&r.target&&r.target.src;s.messe="Loadingchunk"+t+"failed.\n("+o+":"+a+")",s.name="ChunkLoadError",s.type=o,s.request=a,n[1](s)}}),"chunk-"+t,t)}};vart=(t,r)=>{varn,o,[a,s,c]=r,u=0;if(a.some((t=>0!==e[t]))){for(nins)i.o(s,n)&&(i.m[n]=s[n]);if(c)c(i)}for(t&&t(r);u{"usestrict";i(8374);vare=i(944),t=i(6344),r=i(9566),n=i(7836);classo{entIdentifier;constructor(){lete=arguments.length>0&&void0!==arguments[0]?arguments[0]:(0,r.LA)(16);this.entIdentifier=e,this.ee=n.ee.get(e)}#e(t){for(varr=arguments.length,n=newArray(r>1?r-1:0),i=1;i{t[r]=function(e,t){return!0===(0,s.gD)(t,"".concat(e,".enabled"))}(r,e)})),t}vard=i(425);varl=i(1687),f=i(4234),h=i(5289),g=i(6154),p=i(5270),m=i(7767),v=i(6389);classbextendsf.W{constructor(e,t,r){letn=!(arguments.length>3&&void0!==arguments[3])||arguments[3];super(e,t,r),this.auto=n,this.abortHandler=void0,this.featgregate=void0,this.ongregateImported=void0,!1===(0,s.gD)(this.entIdentifier,"".concat(this.featureName,".autoStart"))&&(this.auto=!1),this.auto?(0,l.Ak)(e,r):this.ee.on("manual-start-all",(0,v.J)((()=>{(0,l.Ak)(this.entIdentifier,this.featureName),this.auto=!0,this.importgregator()})))}importgregator(){lett,r=arguments.length>0&&void0!==arguments[0]?arguments[0]:{};if(this.featgregate||!this.auto)return;this.ongregateImported=newPromise((e=>{t=e}));constn=async()=>{letn;try{if((0,m.V)(this.entIdentifier)){const{setupentSession:e}=awaiti.e(478).then(i.bind(i,6526));n=e(this.entIdentifier)}}catch(t){(0,e.R)("Aproblemoccurredwhenstartingupsessionmaner.Thispewillnotstartorextendanysession.",t),this.ee.emit("internal-error",[t]),this.featureName===a.K.sessionReplay&&this.abortHandler?.()}try{if(!this.#t(this.featureName,n))return(0,l.Ze)(this.entIdentifier,this.featureName),voidt(!1);const{lazyFeatureLoader:e}=awaiti.e(478).then(i.bind(i,6103)),{gregate:o}=awaite(this.featureName,"gregate");this.featgregate=newo(this.entIdentifier,this.gregator,r),t(!0)}catch(r){(0,e.R)("Downloadingandinitializing".concat(this.featureName,"failed..."),r),this.abortHandler?.(),(0,l.Ze)(this.entIdentifier,this.featureName,!0),t(!1),this.ee&&this.ee.abort()}};g.RI?(0,h.GG)((()=>n()),!0):n()}#t(e,t){switch(e){casea.K.sessionReplay:return(0,p.SR)(this.entIdentifier)&&!!t;casea.K.sessionTrace:return!!t;default:return!0}}}vary=i(6630);classwextendsb{staticfeatureName=y.T;constructor(e,t){letr=!(arguments.length>2&&void0!==arguments[2])||arguments[2];super(e,t,y.T,r),this.importgregator()}}varR=i(4777),x=i(1478);classAextendsR.J{constructor(e){super(e),this.gregatedData={}}store(e,t,r,n,i){varo=this.getBucket(e,t,r,i);returno.metrics=function(e,t){t||(t={count:0});returnt.count+=1,(0,x.$)(e,(function(e,r){t[e]=T(r,t[e])})),t}(n,o.metrics),o}merge(e,t,r,n,i){varo=this.getBucket(e,t,n,i);if(o.metrics){vara=o.metrics;a.count+=r.count,(0,x.$)(r,(function(e,t){if("count"!==e){varn=a[e],i=r[e];i&&!i.c?a[e]=T(i.t,n):a[e]=function(e,t){if(!t)returne;t.c||(t=E(t.t));returnt.min=Math.min(e.min,t.min),t.max=Math.max(e.max,t.max),t.t+=e.t,t.sos+=e.sos,t.c+=e.c,t}(i,a[e])}}))}elseo.metrics=r}storeMetric(e,t,r,n){vari=this.getBucket(e,t,r);returni.stats=T(n,i.stats),i}getBucket(e,t,r,n){this.gregatedData[e]||(this.gregatedData[e]={});vari=this.gregatedData[e][t];returni||(i=this.gregatedData[e][t]={params:r||{}},n&&(i.custom=n)),i}get(e,t){returnt?this.gregatedData[e]&&this.gregatedData[e][t]:this.gregatedData[e]}take(e){for(vart={},r="",n=!1,i=0;it.max&&(t.max=e),e2&&void0!==arguments[2])||arguments[2];super(e,t,j.T,r),g.RI&&((0,I.u)((()=>(0,O.p)("docHidden",[(0,C.t)()],void0,j.T,this.ee)),!0),(0,_.sp)("pehide",(()=>(0,O.p)("winPehide",[(0,C.t)()],void0,j.T,this.ee))),this.importgregator())}}vark=i(3969);classLextendsb{staticfeatureName=k.TZ;constructor(e,t){letr=!(arguments.length>2&&void0!==arguments[2])||arguments[2];super(e,t,k.TZ,r),this.importgregator()}}varD=i(6774);classH{constructor(e,t,r,n,i){this.name="UncaughtError",this.messe="string"==typeofe?e:(0,N.A)(e),this.sourceURL=t,this.line=r,this.column=n,this.__newrelic=i}}functionM(e){returnF(e)?e:newH(void0!==e?.messe?e.messe:e,e?.filename||e?.sourceURL,e?.lineno||e?.line,e?.colno||e?.col,e?.__newrelic)}functionU(e){lett="UnhandledPromiseRejection";if(F(e?.reason))try{returne.reason.messe=t+":"+e.reason.messe,M(e.reason)}catch(t){returnM(e.reason)}if(void0===e.reason)returnM(t);constr=M(e.reason);returnr.messe=t+":"+r?.messe,r}functionK(e){if(e.errorinstanceofSyntaxError&&!/:\d+$/.test(e.error.stack?.trim())){constt=newH(e.messe,e.filename,e.lineno,e.colno,e.error.__newrelic);returnt.name=SyntaxError.name,t}returnF(e.error)?e.error:M(e)}functionF(e){returneinstanceofError&&!!e.stack}classBextendsb{staticfeatureName=D.T;#r=!1;constructor(e,r){letn=!(arguments.length>2&&void0!==arguments[2])||arguments[2];super(e,r,D.T,n);try{this.removeOnAbort=newAbortController}catch(e){}this.ee.on("internal-error",(e=>{this.abortHandler&&(0,O.p)("ierr",[M(e),(0,C.t)(),!0,{},this.#r],void0,this.featureName,this.ee)})),this.ee.on(t.G4.REPLAY_RUNNING,(e=>{this.#r=e})),g.gm.addEventListener("unhandledrejection",(e=>{this.abortHandler&&(0,O.p)("err",[U(e),(0,C.t)(),!1,{unhandledPromiseRejection:1},this.#r],void0,this.featureName,this.ee)}),(0,_.jT)(!1,this.removeOnAbort?.signal)),g.gm.addEventListener("error",(e=>{this.abortHandler&&(0,O.p)("err",[K(e),(0,C.t)(),!1,{},this.#r],void0,this.featureName,this.ee)}),(0,_.jT)(!1,this.removeOnAbort?.signal)),this.abortHandler=this.#n,this.importgregator()}#n(){this.removeOnAbort?.abort(),this.abortHandler=void0}}varG=i(8990);letV=1;constz="nr@id";functionW(e){constt=typeofe;return!e||"object"!==t&&"function"!==t?-1:e===g.gm?0:(0,G.I)(e,z,(function(){returnV++}))}functionq(e){if("string"==typeofe&&e.length)returne.length;if("object"==typeofe){if("undefined"!=typeofArrayBuffer&&einstanceofArrayBuffer&&e.byteLength)returne.byteLength;if("undefined"!=typeofBlob&&einstanceofBlob&&e.size)returne.size;if(!("undefined"!=typeofFormData&&einstanceofFormData))try{return(0,N.A)(e).length}catch(e){return}}}varY=i(8941),Z=i(7485);classX{constructor(e){this.entIdentifier=e}generateTracePayload(e){if(!this.shouldGenerateTrace(e))returnnull;vart=(0,s.oC)(this.entIdentifier);if(!t)returnnull;varn=(t.accountID||"").toString()||null,i=(t.entID||"").toString()||null,o=(t.trustKey||"").toString()||null;if(!n||!i)returnnull;vara=(0,r.ZF)(),c=(0,r.el)(),u=Date.now(),d={spanId:a,traceId:c,timestamp:u};return(e.sameOrigin||this.isAllowedOrigin(e)&&this.useTraceContextHeadersForCors())&&(d.traceContextParentHeader=this.generateTraceContextParentHeader(a,c),d.traceContextStateHeader=this.generateTraceContextStateHeader(a,u,n,i,o)),(e.sameOrigin&&!this.excludeNewrelicHeader()||!e.sameOrigin&&this.isAllowedOrigin(e)&&this.useNewrelicHeaderForCors())&&(d.newrelicHeader=this.generateTraceHeader(a,c,u,n,i,o)),d}generateTraceContextParentHeader(e,t){return"00-"+t+"-"+e+"-01"}generateTraceContextStateHeader(e,t,r,n,i){returni+"@nr=0-1-"+r+"-"+n+"-"+e+"----"+t}generateTraceHeader(e,t,r,n,i,o){if(!("function"==typeofg.gm?.btoa))returnnull;vara={v:[0,1],d:{ty:"Browser",ac:n,ap:i,id:e,tr:t,ti:r}};returno&&n!==o&&(a.d.tk=o),btoa((0,N.A)(a))}shouldGenerateTrace(e){returnthis.isDtEnabled()&&this.isAllowedOrigin(e)}isAllowedOrigin(e){vart=!1,r={};if((0,s.gD)(this.entIdentifier,"distributed_tracing")&&(r=(0,s.D0)(this.entIdentifier).distributed_tracing),e.sameOrigin)t=!0;elseif(r.allowed_originsinstanceofArray)for(varn=0;n2&&void0!==arguments[2])||arguments[2];super(e,t,J.T,r),this.dt=newX(e),this.handler=(e,t,r,n)=>(0,O.p)(e,t,r,n,this.ee);try{conste={xml:"xhr",fetch:"fetch",beacon:"beacon"};g.gm?.performance?.getEntriesByType("resource").forEach((t=>{if(t.initiatorTypeine&&0!==t.responseStatus){constr={status:t.responseStatus},n={rxSize:t.transferSize,duration:Math.floor(t.duration),cbTime:0};oe(r,t.name),this.handler("xhr",[r,n,t.startTime,t.responseEnd,e[t.initiatorType]],void0,a.K.ajax)}}))}catch(e){}(0,Y.NZ)(this.ee),(0,Y.bX)(this.ee),function(e,t,r,n){functioni(e){vart=this;t.totalCbs=0,t.called=0,t.cbTime=0,t.end=x,t.ended=!1,t.xhrGuids={},t.lastSize=null,t.loadCaptureCalled=!1,t.params=this.params||{},t.metrics=this.metrics||{},e.addEventListener("load",(function(r){A(t,e)}),(0,_.jT)(!1)),g.lR||e.addEventListener("progress",(function(e){t.lastSize=e.loaded}),(0,_.jT)(!1))}functiono(e){this.params={method:e[0]},oe(this,e[1]),this.metrics={}}functionc(t,r){vari=(0,s.oC)(e);i.xpid&&this.sameOrigin&&r.setRequestHeader("X-NewRelic-ID",i.xpid);varo=n.generateTracePayload(this.parsedOrigin);if(o){vara=!1;o.newrelicHeader&&(r.setRequestHeader("newrelic",o.newrelicHeader),a=!0),o.traceContextParentHeader&&(r.setRequestHeader("traceparent",o.traceContextParentHeader),o.traceContextStateHeader&&r.setRequestHeader("tracestate",o.traceContextStateHeader),a=!0),a&&(this.dt=o)}}functionu(e,r){varn=this.metrics,i=e[0],o=this;if(n&&i){vara=q(i);a&&(n.txSize=a)}this.startTime=(0,C.t)(),this.body=i,this.listener=function(e){try{"abort"!==e.type||o.loadCaptureCalled||(o.params.aborted=!0),("load"!==e.type||o.called===o.totalCbs&&(o.onloadCalled||"function"!=typeofr.onload)&&"function"==typeofo.end)&&o.end(r)}catch(e){try{t.emit("internal-error",[e])}catch(e){}}};for(vars=0;s1?e[1]=o:e.push(o)}}functions(e,t){varr=!1;returnt.newrelicHeader&&(e.set("newrelic",t.newrelicHeader),r=!0),t.traceContextParentHeader&&(e.set("traceparent",t.traceContextParentHeader),t.traceContextStateHeader&&e.set("tracestate",t.traceContextStateHeader),r=!0),r}}functionw(e,t){this.params={},this.metrics={},this.startTime=(0,C.t)(),this.dt=t,e.length>=1&&(this.target=e[0]),e.length>=2&&(this.opts=e[1]);varr,n=this.opts||{},i=this.target;"string"==typeofi?r=i:"object"==typeofi&&iinstanceofre?r=i.url:g.gm?.URL&&"object"==typeofi&&iinstanceofURL&&(r=i.href),oe(this,r);varo=(""+(i&&iinstanceofre&&i.method||n.method||"GET")).toUpperCase();this.params.method=o,this.body=n.body,this.txSize=q(n.body)||0}functionR(e,t){if(this.endTime=(0,C.t)(),this.params||(this.params={}),(0,Q.iW)(this.params))return;letn;this.params.status=t?t.status:0,"string"==typeofthis.rxSize&&this.rxSize.length>0&&(n=+this.rxSize);consti={txSize:this.txSize,rxSize:n,duration:(0,C.t)()-this.startTime};r("xhr",[this.params,i,this.startTime,this.endTime,"fetch"],this,a.K.ajax)}functionx(e){constt=this.params,n=this.metrics;if(!this.ended){this.ended=!0;for(lett=0;t2&&void0!==arguments[2])||arguments[2];super(e,r,t.TZ,i),this.replayRunning=!1;try{n=JSON.parse(localStore.getItem("".concat(pe.H3,"_").concat(pe.uh)))}catch(e){}(0,p.SR)(e)&&this.ee.on(t.G4.RECORD,(()=>this.#o())),this.#a(n)?(this.#i=n?.sessionReplayMode,this.#s()):this.importgregator(),this.ee.on("err",(e=>{this.replayRunning&&(this.errorNoticed=!0,(0,O.p)(t.G4.ERROR_DURING_REPLAY,[e],void0,this.featureName,this.ee))})),this.ee.on(t.G4.REPLAY_RUNNING,(e=>{this.replayRunning=e}))}#a(e){returne&&(e.sessionReplayMode===pe.g.FULL||e.sessionReplayMode===pe.g.ERROR)||(0,p.Aw)(this.entIdentifier)}#c=!1;async#s(e){if(!this.#c){this.#c=!0;try{const{Recorder:t}=awaitPromise.all([i.e(478),i.e(249)]).then(i.bind(i,2496));this.recorder??=newt({mode:this.#i,entIdentifier:this.entIdentifier,trigger:e,ee:this.ee}),this.recorder.startRecording(),this.abortHandler=this.recorder.stopRecording}catch(e){}this.importgregator({recorder:this.recorder,errorNoticed:this.errorNoticed})}}#o(){this.featgregate?this.featgregate.mode!==pe.g.FULL&&this.featgregate.initializeRecording(pe.g.FULL,!0):(this.#i=pe.g.FULL,this.#s(t.Qb.API),this.recorder&&this.recorder.parent.mode!==pe.g.FULL&&(this.recorder.parent.mode=pe.g.FULL,this.recorder.stopRecording(),this.recorder.startRecording(),this.abortHandler=this.recorder.stopRecording))}}varve=i(3962);classbeextendsb{staticfeatureName=ve.TZ;constructor(e,t){letr=!(arguments.length>2&&void0!==arguments[2])||arguments[2];if(super(e,t,ve.TZ,r),!g.RI||!s.hR.MO)return;constn=(0,Y.vC)(this.ee),i=(0,Y.um)(this.ee),o=()=>(0,O.p)("newURL",[(0,C.t)(),""+window.location],void0,this.featureName,this.ee);n.on("pushState-end",o),n.on("replaceState-end",o);try{this.removeOnAbort=newAbortController}catch(e){}(0,_.sp)("popstate",(e=>(0,O.p)("newURL",[e.timeStamp,""+window.location],void0,this.featureName,this.ee)),!0,this.removeOnAbort?.signal);leta=!1;constc=news.hR.MO(((e,t)=>{a||(a=!0,requestAnimationFrame((()=>{(0,O.p)("newDom",[(0,C.t)()],void0,this.featureName,this.ee),a=!1})))})),u=(0,v.s)((e=>{(0,O.p)("newUIEvent",[e],void0,this.featureName,this.ee),c.observe(document.body,{attributes:!0,childList:!0,subtree:!0,characterData:!0})}),100,{leading:!0});i.on("fn-start",(e=>{let[t]=e;ve.tC.includes(t?.type)&&u(t)}));for(leteofve.tC)document.addEventListener(e,(()=>{}));this.abortHandler=function(){this.removeOnAbort?.abort(),c.disconnect(),this.abortHandler=void0},this.importgregator({domObserver:c})}}varye=i(7378);const{TZ:we,d3:Re,Kp:xe,$p:Ae,wW:Te,e5:Ee,tH:Se,uP:Ne,rw:Oe,Lc:Ie}=ye;var_e=i(8166);classjeextendsb{staticfeatureName=_e.T;constructor(e,t){letr=!(arguments.length>2&&void0!==arguments[2])||arguments[2];super(e,t,_e.T,r),this.importgregator()}}varCe=i(993),Pe=i(3785);classkeextendsb{staticfeatureName=Ce.TZ;constructor(e,t){letr=!(arguments.length>2&&void0!==arguments[2])||arguments[2];super(e,t,Ce.TZ,r);constn=this.ee;this.ee.on("wrap-logger-end",(function(e){let[t]=e;const{level:r,customAttributes:i}=this;(0,Pe.R)(n,t,i,r)})),this.importgregator()}}newclassextendso{constructor(t,r){super(r),g.gm?(this.sharedgregator=newA({entIdentifier:this.entIdentifier}),this.features={},(0,S.bQ)(this.entIdentifier,this),this.desiredFeatures=newSet(t.features||[]),this.desiredFeatures.add(w),this.runSoftNOverSpa=[...this.desiredFeatures].some((e=>e.featureName===a.K.softN)),(0,d.j)(this,t,t.loaderType||"ent"),this.run()):(0,e.R)("Failedtoinitializetheent.Couldnotdeterminetheruntimeenvironment.")}getconfig(){return{info:this.info,init:this.init,loader_config:this.loader_config,runtime:this.runtime}}run(){try{constt=u(this.entIdentifier),r=[...this.desiredFeatures];r.sort(((e,t)=>a.P[e.featureName]-a.P[t.featureName])),r.forEach((r=>{if(!t[r.featureName]&&r.featureName!==a.K.peViewEvent)return;if(this.runSoftNOverSpa&&r.featureName===a.K.spa)return;if(!this.runSoftNOverSpa&&r.featureName===a.K.softN)return;constn=function(e){switch(e){casea.K.ajax:return[a.K.jserrors];casea.K.sessionTrace:return[a.K.ajax,a.K.peViewEvent];casea.K.sessionReplay:return[a.K.sessionTrace];casea.K.peViewTiming:return[a.K.peViewEvent];default:return[]}}(r.featureName);n.every((e=>einthis.features))||(0,e.R)("".concat(r.featureName,"isenabledbutoneormoredependentfeatureshasnotbeeninitialized(").concat((0,N.A)(n),").Thismaycauseunintendedconsequencesormissingdata...")),this.features[r.featureName]=newr(this.entIdentifier,this.sharedgregator)}))}catch(t){(0,e.R)("Failedtoinitializeallenabledinstrumentclasses(entaborted)-",t);for(consteinthis.features)this.features[e].abortHandler?.();constr=(0,S.Zm)();deleter.initializedents[this.entIdentifier]?.api,deleter.initializedents[this.entIdentifier]?.features,deletethis.sharedgregator;returnr.ee.get(this.entIdentifier).abort(),!1}}}({features:[ie,w,P,classextendsb{staticfeatureName=le;constructor(e,t){super(e,t,le,!(arguments.length>2&&void0!==arguments[2])||arguments[2]);if(!(0,m.V)(this.entIdentifier))returnvoid(0,l.x3)(this.entIdentifier,this.featureName);constr=this.ee;letn;(0,Y.vC)(r),this.eventsEE=(0,Y.um)(r),this.eventsEE.on(he,(function(e,t){this.bstStart=(0,C.t)()})),this.eventsEE.on(fe,(function(e,t){(0,O.p)("bst",[e[0],t,this.bstStart,(0,C.t)()],void0,a.K.sessionTrace,r)})),r.on(ge+ue,(function(e){this.time=(0,C.t)(),this.startPath=location.pathname+location.hash})),r.on(ge+de,(function(e){(0,O.p)("bstHist",[location.pathname+location.hash,this.startPath,this.time],void0,a.K.sessionTrace,r)}));try{n=newPerformanceObserver((e=>{constt=e.getEntries();(0,O.p)(se,[t],void0,a.K.sessionTrace,r)})),n.observe({type:ce,buffered:!0})}catch(e){}this.importgregator({resourceObserver:n})}},me,L,je,B,ke,be,classextendsb{staticfeatureName=we;constructor(e,t){varr;if(super(e,t,we,!(arguments.length>2&&void0!==arguments[2])||arguments[2]),r=this,!g.RI)return;try{this.removeOnAbort=newAbortController}catch(e){}letn,i=0;consto=this.ee.get("tracer"),a=(0,Y.Ri)(this.ee),s=(0,Y.o8)(this.ee),c=(0,Y.MO)(this.ee),u=(0,Y.bX)(this.ee),d=this.ee.get("events"),l=(0,Y.NZ)(this.ee),f=(0,Y.vC)(this.ee),h=(0,Y.Ak)(this.ee);functionp(e,t){f.emit("newURL",[""+window.location,t])}functionm(){i++,n=window.location.hash,this[Ne]=(0,C.t)()}functionv(){i--,window.location.hash!==n&&p(0,!0);vare=(0,C.t)();this[Ee]=~~this[Ee]+e-this[Ne],this[Ie]=e}functionb(e,t){e.on(t,(function(){this[t]=(0,C.t)()}))}this.ee.on(Ne,m),s.on(Oe,m),a.on(Oe,m),this.ee.on(Ie,v),s.on(Te,v),a.on(Te,v),this.ee.on("fn-err",(function(){for(vart=arguments.length,n=newArray(t),i=0;i1)}),(0,_.jT)(!0,this.removeOnAbort?.signal)),this.abortHandler=this.#n,this.importgregator()}#n(){this.removeOnAbort?.abort(),this.abortHandler=void0}}],loaderType:"spa"})})()})(); 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-audiofigcaption{color:#555;font-size:13px;text-align:center}.is-dark-theme.wp-block-audiofigcaption{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-embedfigcaption{color:#555;font-size:13px;text-align:center}.is-dark-theme.wp-block-embedfigcaption{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}.wp-block-imefigcaption{color:#555;font-size:13px;text-align:center}.is-dark-theme.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.has-text-align-right{border-left:none;border-right:.25emsolid;padding-left:0;padding-right:1em}.wp-block-quote.has-text-align-center{border:none;padding-left:0}.wp-block-quote.is-large,.wp-block-quote.is-style-large,.wp-block-quote.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-tablefigcaption{color:#555;font-size:13px;text-align:center}.is-dark-theme.wp-SQL Shack - Artikel über Datenbankprüfung, Serverleistung, Datenwiederaufnahme und mehrblock-tablefigcaption{color:#ffffffa6}.wp-block-videofigcaption{color:#555;font-size:13px;text-align:center}.is-dark-theme.wp-block-videofigcaption{color:#ffffffa6}.wp-block-video{margin:001em}.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}body{--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(.is-layout-grid){gap:0.5em;}body.is-layout-flex{display:flex;}body.is-layout-flex{flex-wrap:wrap;align-items:center;}body.is-layout-flex>*{margin:0;}body.is-layout-grid{display:grid;}body.is-layout-grid>*{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-spectrum-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;}.wp-block-nigationa:where(:not(.wp-element-button)){color:inherit;}: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;}.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(){SQL Shack - Artikel über Datenbankprüfung, Serverleistung, Datenwiederaufnahme und mehr}, 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(){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;}});}); 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 MySQLClusterinsimplewords February23,2023 byHaroonAshraf ThisarticleprovidesanoverviewofMySQLClusterinasimpleunderstandablemannersuitableforbothdatabasebeginnersandprofessionals.Readmore» Generaldatabasedesign,MySQL SQLCheatSheetforNewbies February21,2023 byEsatErkec InthisSQLcheatsheet,we8217;lllookatsampleSQLqueriesthatcanhelpyoulearnbasicT-SQLqueriesasquicklyaspossible.Readmore» SQLcommands,T-SQL HowtousetheCROSSTABfunctioninPostgreSQL February17,2023 byRajendraGupta ThisarticlewillexploretheuseoftheCROSSTABfunctioninPostgreSQL.Readmore» PostgreSQL,SQLcommands Pe1of10512345...102030...»Last» Followus! PopularSQLPARTITIONBYClauseoverviewDifferentwaystoSQLdeleteduplicaterowsfromaSQLTableSQLConvertDatefunctionsandformatsSQLVariables:BasicsanduseSQLServertablehints–WITH(NOLOCK)bestpracticesSQLWHILEloopwithsimpleexamplesHowtobackupandrestoreMySQLdatabasesusingthemysqldumpcommandSQLServerfunctionsforconvertingaStringtoaDateSELECTINTOTEMPTABLEstatementinSQLServerHowtoUPDATEfromaSELECTstatementinSQLServerOverviewofSQLRANKfunctionsUnderstandingtheSQLMERGEstatementSQLLfunctionoverviewandexamplesTheTableVariableinSQLServerHowtoidentifyandresolveSQLServerIndexFrmentationSQLmultiplejoinsforbeginnerswithexamplesCASEstatementinSQLSQLServerCommonTableExpressions(CTE)UnderstandingtheSQLDecimaldatatypeSQLpercentecalculationexamplesinSQLServerTrendingSQLServerTransactionLogBackup,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=/;secure;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',''); } }); } });