SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,627 questions
10 answers
One of the answers was accepted by the question author.
Improve the execution time for a complex SQL Query from 25 seconds to be under 1 second in SQL Server Enterprise 2019
How can I improve the execution time for a query where the initial Rows in the view were: 16000 and the query worked resonable ( under 1 second ), but now there are : 42487 rows in the View and the execution time is over 25 seconds ... which is not…
asked 2020-08-24T15:44:09.817+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 68%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELP%3C/text%3E%3C/svg%3E)
Lucian Parvu
21
Reputation points
accepted 2020-08-28T11:22:09.907+00:00
Lucian Parvu
21
Reputation points
1 answer
Regarding azure certification voucher AZ-900
I had attended workshop of azure fundamentals part 1 and 2 ,and was given a voucher for AZ-900 certification,but while opening the link I am not able to schedule the exam since nothing is getting displayed . Kindly help me in scheduling the certification…
asked 2020-08-28T10:33:27.87+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(246.4, 24%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
Akanksha Kumari
1
Reputation point
answered 2020-08-28T10:50:59.793+00:00
Vaibhav Chaudhari
38,721
Reputation points
1 answer
I created a Microsoft Teams from existing Team Site, But i want only the associated team needs to be deleted without O365 group and Team site?
I have created by using the option "create team" which will appear in a team site,but i want other team to use for my folders and content. Please suggest the steps on How to Delete only The Microsoft Team created without deleting the…
Microsoft Teams
Microsoft Teams
A Microsoft customizable chat-based workspace.
9,913 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,610 questions
asked 2020-08-21T04:12:13.99+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(233.6, 18%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESB%3C/text%3E%3C/svg%3E)
Srinivas Bhumadi
1
Reputation point
commented 2020-08-28T10:24:03.787+00:00
JoyZ
18,066
Reputation points
1 answer
Can't send email
Good morning sirs, My Outlook 2019 has an IMAP and an Exchange account. I'm able to receive but not to send. Mail are blocked into the outbox folder. Using mobile I have no problem with both. The mail of test that is automatically sent…
asked 2020-08-21T15:48:58.903+00:00
Andrea Vironda
816
Reputation points
commented 2020-08-28T10:14:10.777+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 22%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELL%3C/text%3E%3C/svg%3E)
Lucas Liu-MSFT
6,166
Reputation points
4 answers
Receive spoofed email
Hi, we have two exchange servers. first is the mailbox server and the second is the Edge server. we configured and set up SPF,DMARK, and sender ID on the Edge Server. but when I test my domain with send-MailMessage command as an example send a spoof…
asked 2020-08-16T11:20:23.34+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(64, 0%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Amir
6
Reputation points
commented 2020-08-28T10:12:18.99+00:00
Lucas Liu-MSFT
6,166
Reputation points
4 answers
System state backup fails : Event 517 : 0x80070020 : Windows Server 2016
Hello, Am trying to perform System State backup on server. The error is: The process cannot access the file because it is being used by another process. I know that it is possible to use Process Monitor to identify when a file is being accessed by…
asked 2020-08-22T00:22:07.603+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 66%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVW%3C/text%3E%3C/svg%3E)
Vaughan Wickham
141
Reputation points
answered 2020-08-28T10:04:10.777+00:00
Vaughan Wickham
141
Reputation points
1 answer
Deployment Planner Incorrect OS Type
Hi, We ran the Deployment Planner and when the report came up on some servers (they all are Windows Server 2016) shows Windows 10 64bit on the OS Type, my doubt is why it shows another OS Type as the servers are Windows 2016?
asked 2020-07-06T16:11:08.433+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(201.6, 28.000000000000004%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBR%3C/text%3E%3C/svg%3E)
Brenda Rojas
1
Reputation point
commented 2020-08-28T10:00:58.633+00:00
SadiqhAhmed-MSFT
44,251
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
Azure Backup Agent Backup Failed Inconsistencies in the backup data 0x3D093
Hello, The full error message presented in the UI is: "The operation failed because backup has detected inconsistencies in the backup data. Please contact Microsoft Support (0x3D093)" I have a remote worker who is getting this error. I…
asked 2020-08-06T16:39:56.323+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(304, 41%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWS%3C/text%3E%3C/svg%3E)
Warren Sampson
21
Reputation points
commented 2020-08-28T09:57:04.137+00:00
SadiqhAhmed-MSFT
44,251
Reputation points Microsoft Employee
1 answer
Aplicación Teams Bucle de Carga Windows X
Tengo problemas para iniciar Teams en mi pc ya que la aplicación no carga, intenta cargar y se cierra, repitiendo el proceso una y otra vez. Ya desinstalé y volví a instalar la aplicación en dos ocasiones y sigue igual. Probé con un inicio limpio de…
Microsoft Teams
Microsoft Teams
A Microsoft customizable chat-based workspace.
9,913 questions
asked 2020-08-25T03:26:10.327+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 74%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
ALVARO MERCADO CRUZ
1
Reputation point
commented 2020-08-28T09:52:54.56+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(112.00000000000001, 24%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJM%3C/text%3E%3C/svg%3E)
JimmyYang-MSFT
51,716
Reputation points Microsoft Vendor
5 answers
pkg goes down because a connection cant be found
hi we run 2014 standard and develop in vs 2013. i deployed a pkg that has no connector called xxxxxxxx.yyyyyyyyyyy but i get the error the connction xxxxxxxx.yyyyyyyyyyy is not found...oxc001000e...this error is thrown by connections collection when…
asked 2020-08-26T22:22:34.637+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(41.6, 70%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
db042190
1,516
Reputation points
commented 2020-08-28T09:46:43.12+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(294.40000000000003, 37%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
Monalv-MSFT
5,896
Reputation points
1 answer
OneDrive Let people outside your organization Access your Site option missing in O365 Admin Center
Hi, I recently turned off the option: Let people outside your organization access your site in O365 Admin Center>Active Users>%Username%>OneDrive>Manage External Sharing Now, this particular setting is missing for this user. Other user's…
asked 2020-08-20T15:53:09.033+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(150.4, 67%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAD%3C/text%3E%3C/svg%3E)
Alejandro Deniz
1
Reputation point
commented 2020-08-28T09:33:13.723+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(313.6, 51%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EED%3C/text%3E%3C/svg%3E)
Emily Du-MSFT
45,581
Reputation points Microsoft Vendor
1 answer
How to migrate SharePoint designer 2010 workflow
How to migrate SharePoint designer 2010 List workflow ? Save workflow as template is disable When i copy paste content in reusable workflow its all lookup not working,
asked 2020-08-20T07:03:11.487+00:00
Shiv Sharma
1
Reputation point
commented 2020-08-28T09:32:52.873+00:00
Emily Du-MSFT
45,581
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
Difference between MS Access 365 && 2016
What are the differences between MS Access in the Office 365 suite and Access 2016? My co-worker insists that we have to update to Access 2016 and I keep telling him that we already have Access 2016 in our Office 365 suite. When I look at my account it…
Office Management
Office Management
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Management: The act or process of organizing, handling, directing or controlling something.
2,114 questions
asked 2020-08-24T16:41:06.22+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(316.8, 35%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELM%3C/text%3E%3C/svg%3E)
Lindstrom, Melissa
21
Reputation points
commented 2020-08-28T09:31:21.6+00:00
Emi Zhang-MSFT
24,441
Reputation points Microsoft Vendor
2 answers
One of the answers was accepted by the question author.
View conversations does not work for Inbox on Microsoft 365 app (outlook)
I installed Outlook via Microsoft 365 apps for one of my colleagues. Now the view conversations works for sub folders or shared mailboxes but not for the inbox. You can see several mails in the inbox with the same subject. Also the view…
2 answers
Mein Konto lässt keine Bearbeitung auf einem Mac zu
Hallo, beim Öffnen eines Dokumentes in Word (Version für Studierende) wird mir in einem gelben Banner folgender Text angezeigt: "Ihr Konto ... lässt keine Bearbeitung auf einem Mac zu. Wenn Sie mehr erfahren wollen fragen Sie ihren Administrator…
asked 2020-08-07T08:29:22.427+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(156.8, 6%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Alena
1
Reputation point
commented 2020-08-28T09:24:38.857+00:00
Emi Zhang-MSFT
24,441
Reputation points Microsoft Vendor
2 answers
One of the answers was accepted by the question author.
Power BI without Office 365 sub ?
Hi, I am about to deploy Power BI in my company to share reports with my team. I understand that all users / viewers need a Power BI Pro licence, but I don't understand if all of them also need an Office 365 subscription? Or can they just get the Pro…
Office Management
Office Management
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Management: The act or process of organizing, handling, directing or controlling something.
2,114 questions
asked 2020-08-19T10:01:41.4+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 8%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJC%3C/text%3E%3C/svg%3E)
Jonathan Chrq
21
Reputation points
answered 2020-08-28T09:19:47.153+00:00
Emi Zhang-MSFT
24,441
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
Outlook 2016 Autodiscover Exchange 2013 over Always On VPN
When creating an Outlook profile for Exchange 2013 while onsite, the autodiscover process works completely. If I am off-site and connected using Microsoft Always On VPN the process fails as per the following: Autodiscover gets correct email address…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(230.39999999999998, 73%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
1 answer
Forward meeting other domain exchang 2016
Hi all, Currently I'm having some trouble settings some things up, please refer below for an environment sketch and question. At my company we use 2 domain with both an separate Exchange environment. Domain A has no public exchange links while…
asked 2020-08-10T09:11:39.077+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(294.40000000000003, 50%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDM%3C/text%3E%3C/svg%3E)
David Mertens
1
Reputation point
commented 2020-08-28T09:12:46.28+00:00
KyleXu-MSFT
26,256
Reputation points
4 answers
One of the answers was accepted by the question author.
SCCM 2019 - Installation of WSUS - SQL
Dear all, I am trying to install SCCM as we aquired the licences. Now what I am trying to do is to install the WSUS role in the "SCCM Server". I can successfully connect to the sqlserver\sccm (the instance) but then when I launch…
asked 2020-08-26T16:05:33.823+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(70.4, 70%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELV%3C/text%3E%3C/svg%3E)
Lucas Vorms
251
Reputation points
answered 2020-08-28T09:09:37.467+00:00
Lucas Vorms
251
Reputation points
1 answer
SQLExpress 2017 upgrade to SQLExpress 2019 fails with message "Microsoft.SqlServer.Configuration.Sco.SqlRegistryException: More data is available"
20573-summary.txtI am trying to upgrade my SQLExpress 2017 to SQLExpress 2019. It failed due to Microsoft.SqlServer.Configuration.Sco.SqlRegistryException: More data is available. It looks like failed to open, create and copy registry between…
asked 2020-08-25T16:51:08.59+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 79%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKW%3C/text%3E%3C/svg%3E)
Kevin Wang
1
Reputation point
commented 2020-08-28T09:09:25.077+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 46%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
AmeliaGu-MSFT
13,976
Reputation points Microsoft Vendor