My website not indexing on Bing, core vitals went to 0 after change the webhost
I am facing some issues with coreweb vitals as well as bing indexing, I have tried to let bing get the index of the site and with no reason it keeps getting nothing. I checked if it had the sitemap and it does, also checked robots.txt to see if there was a “no crawl” option, and there is nothing of sorts. . On the other hand, the host of the site changed from Hostinger to Wordpress. After that, the coreweb vitals section went to 0, it used to be very well. How can we fix that? any recommendations would be greatly appreciated!"
SQL Server Stream Aggregate vs Hash match Aggregate
Hello, I am a new SQL Server engineer. While looking at the execution plan of a query that SUM() values of int type based on the range of a date column of datetime type, I discovered that SUM() processing is handled by Stream Aggregate and Hash match aggregate in each case. The table is composed of a Clustered Index with Date as the key. I think it changes to Hash match processing as the index search range increases, but I don't know the difference between the two processing methods and what criteria determine the processing method. Can you give me a good answer?Who can help? Bing bots refuse to crawl the content.
Bing support has been ignoring me for the past 9 months, repeatedly sending the same response: "The submitted URL is known to Bing but has some issues preventing indexing. We recommend following the Bing Webmaster guidelines to increase your chances of indexing." I discovered the issue and fixed it, but even after a long time, the site still hasn't been indexed. I have tried all the methods multiple times to speed up indexing, but it didn’t work. Bing is connected, but Bing bots refuse to crawl the content.
ghost index
Hi, I'm trying to optimize a query. Looking at the execution plan, I find that it suggests creating an index using 3 columns. Once the index was created, I rechecked the execution plan and again found the indication to create the same index even though I had already created it. it's as if he doesn't see it How is it possible? Thanks Andrea
View is taking more time and consuming 100% cpu utilization
We are using views on tables having huge records to display some information in our application but it is consuming 100% CPU utilization and taking more time to process the records. SELECT COUNT(*) FROM FRA_ITEM_FIELD_DEF--44 SELECT COUNT(*) FROM FRA_STAT_ITEM--59635520(59M) SELECT COUNT(*) FROM FRA_STAT_FIELD--536719680(536M) Available Indexes: FRA_STAT_ITEM: CREATE UNIQUE INDEX FRA_STITM_U1 ON FRA_STAT_ITEM (ID_ORIGINAL,ITEM_TYPE,SEQUENCE_NO) GO CREATE INDEX FRA_STITM_U2 ON FRA_STAT_ITEM (REFERENCE) GO FRA_STAT_FIELD: CREATE INDEX FRA_STFLD_OPT1 ON FRA_STAT_FIELD (ID_STAT_ITEM,ID_FIELD_DEF,TEXT_VALUE,DATETIME_VALUE,NUMBER_VALUE,DECIMAL_VALUE) GO FRA_STAT_FIELD: CREATE INDEX FRA_STFLD_OPT2 ON FRA_STAT_FIELD (ID_FIELD_DEF) INCLUDE (ID_STAT_ITEM,DATETIME_VALUE) GO CREATE INDEX FRA_STFLD_OPT3 ON FRA_STAT_FIELD (ID_FIELD_DEF) INCLUDE (ID_STAT_ITEM,TEXT_VALUE) GO Reported View: CREATE OR ALTER VIEW FRAUD_ALERT_STAT_HIT_VIEW AS SELECT DISTINCT STAT.ID AS ID, STAT.COMPANY AS COMPANY, STAT.TEXT_VALUE AS ACCOUNT, STAT.ITEM_TYPE AS FRAUD_ITEM_TYPE, STAT.DATETIME_VALUE AS VALUE_DATE, STAT.CREATION_TIME AS CREATION_TIME, STAT.PAYLOAD AS PAYLOAD, STAT.REFERENCE AS REFERENCE, STAT.SEQUENCE_NO AS SEQUENCE_NO, STAT.ID_MANDATOR AS ID_MANDATOR, STAT.ALERTED AS ALERTED, STAT.STATUS AS STATUS FROM ( SELECT DISTINCT FSI.ID, FSI.ITEM_TYPE, FSI1.DATETIME_VALUE, FSI2.TEXT_VALUE, FSI.COMPANY, FSI.CREATION_TIME, FSI.PAYLOAD, FSI.REFERENCE, FSI.SEQUENCE_NO, FSI.ID_MANDATOR, FSI.ALERTED, FSI.STATUS FROM FRA_STAT_ITEM FSI CROSS JOIN FRA_STAT_FIELD FSI1 CROSS JOIN FRA_STAT_FIELD FSI2 WHERE FSI1.ID_STAT_ITEM=FSI.ID AND FSI1.ID_FIELD_DEF IN (SELECT ID FROM FRA_ITEM_FIELD_DEF WHERE MAPPING='executionDate') AND FSI2.ID_STAT_ITEM=FSI.ID AND FSI2.ID_FIELD_DEF IN (SELECT ID FROM FRA_ITEM_FIELD_DEF WHERE MAPPING='debitAccount') UNION SELECT DISTINCT FSI.ID, FSI.ITEM_TYPE, FSI1.DATETIME_VALUE, FSI3.TEXT_VALUE, FSI.COMPANY, FSI.CREATION_TIME, FSI.PAYLOAD, FSI.REFERENCE, FSI.SEQUENCE_NO, FSI.ID_MANDATOR, FSI.ALERTED, FSI.STATUS FROM FRA_STAT_ITEM FSI CROSS JOIN FRA_STAT_FIELD FSI1 CROSS JOIN FRA_STAT_FIELD FSI3 WHERE FSI1.ID_STAT_ITEM=FSI.ID AND FSI1.ID_FIELD_DEF IN (SELECT ID FROM FRA_ITEM_FIELD_DEF WHERE MAPPING='executionDate') AND FSI3.ID_STAT_ITEM=FSI.ID AND FSI3.ID_FIELD_DEF IN (SELECT ID FROM FRA_ITEM_FIELD_DEF WHERE MAPPING='creditAccount') ) STAT GO Query to fetch and display record in GUI: WITH query AS (select ROW_NUMBER() OVER (order by fraudstats0_.id desc) as __hibernate_row_nr__, fraudstats0_.id as id64_, fraudstats0_.version as version64_, fraudstats0_.alert_type as alert3_64_, fraudstats0_.benef_cust_id as benef4_64_, fraudstats0_.blocked as blocked64_, fraudstats0_.company as company64_, fraudstats0_.creation_time as creation7_64_, fraudstats0_.id_mandator as id8_64_, fraudstats0_.ordering_cust_id as ordering9_64_, fraudstats0_.id_original as id10_64_, fraudstats0_.reference as reference64_, fraudstats0_.sequence_no as sequence12_64_, fraudstats0_.item_type as item13_64_, fraudstats0_.alerted as alerted64_, fraudstats0_.last_evaluation as last15_64_, fraudstats0_.last_eval_time as last16_64_, fraudstats0_.last_eval_user as last17_64_, fraudstats0_.id_live_item as id18_64_, fraudstats0_.payload as payload64_, fraudstats0_.status as status64_ from fra_stat_item fraudstats0_ where fraudstats0_.id in (select fraudstats1_.id from fraud_alert_stat_hit_view fraudstats1_ where fraudstats1_.fraud_item_type='profile.batch.trn.alert' and fraudstats1_.value_date>=@P0 and (fraudstats1_.account in (@P1 , @P2 , @P3) or fraudstats1_.account in (@P4 , @P5 , @P6))) ) SELECT * FROM query WHERE __hibernate_row_nr__ BETWEEN @P7 AND @P8 At present, Archiving/Purging the table is not possible by structure. Could anyone share some suggestion on fine tuning the view?Sharepoint Numbering Column won't let me have 001 or 012, it won't let me start with 0
Is there a way to set a SharePoint number column to allow numbers that start with 0? We're setting up an index system and for some reason it always removes the 0 and there doesn't seem to be a way to have it not do that. I also tried to use a text row instead, but even that converts 001 to 1.0000000
Index and Windows Search not working
Hello, I am on build 22000.469. The index engine does not work. More precisely, it is often in pause, and when done it is as if it had to index again all my files etc. When I run the "index and windows search utility" I am told that there are incorrect authorizations on the Windows search service. Any idea of what is going on? I have the same problem on two computers. I already did a clean reinstall which only temporarily solved the issue. Please help, thanksWindows 11 search, Music category, should show search results from online sources such as YouTube
When we click/tap on search and go to music tab, and enter a singer name or song's name, we should see search results from online sources such as YouTube and Spotify etc. Upvote this feedback in feedback hub: https://aka.ms/AAd5e17
Help reqd. in Index array function. Blank cells to be shown as "".
There are 2 screen shots.In pic 1 (Sheet name - "Emp") Referring $D$12 (Emp. code), I have displayed Dealer codes from H23 to H32 (as shown in pic) using below array formula. =IFERROR(INDEX(Main!$H$6:$H$2000,SMALL(IF($D$12=Main!$A$6:$A$2000,ROW(Main!$A$6:$A$2000)-MIN(ROW(Main!$A$6:$A$2000))+1,""),ROW(A1))),"") Purpose of using this array formula is to show max 10 dealer codes at a time. If there are less dealers, say 4 dealers, then 4 codes will be displayed. Referring pic 2 (Sheet name - "Main" in the same workbook) Emp. code is also driven by below formula from "Main" sheet =IFERROR(VLOOKUP($D5,CHOOSE({1,2},Main!$B:$B,Main!$A:$A),2,0),"") My problem is if an Emp. code is blank in "Main"sheet then $D$12 shows 0 (pic 3 & pic 4). And cell H23 to H32 still shows dealer codes calculating from H6 (from "Main" sheet) and so on.. I need if $D$12 is 0 or "-" or blank, H23 to H32 should be blank. If anybody can correct or simplify my formula, please help.
