Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,690 questions
4 answers
Quick in code, very slow in SP
Hi everybody, We have a very slow stored procedure. I worked on optimizing its code. I ran multiple tests of the code of the procedure against production (not as a procedure, but using code inside) and I got my results in 2 minutes as the worst result.…
asked 2021-03-19T14:23:40.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(137.6, 31%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENN%3C/text%3E%3C/svg%3E)
Naomi Nosonovsky
8,146
Reputation points
commented 2021-03-26T08:27:33.907+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(236.8, 76%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEM%3C/text%3E%3C/svg%3E)
EchoLiu-MSFT
14,601
Reputation points
1 answer
MECM/SCCM Orchestration group
I was wondering if anyone has set up Orchestration groups for their server patching? We are looking at switching to using Orchestration, but had some questions: If you put the servers in the order that you want them patched, is there any check to see…
asked 2021-03-25T15:37:37.027+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(83.2, 80%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
MaryP
6
Reputation points
answered 2021-03-26T08:24:25.333+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(262.40000000000003, 23%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
SunnyNiu-MSFT
1,701
Reputation points
1 answer
Windows Licensing for 2 windows VM + 1 Linux VM
Hi, So we bought a server with 2 sockets 16 core machine. i know we need to buy 2 x 8 core license which can accommodate 2 VM. But can i install additional Linux VM, will be considered as a 3rd VM and need additional licensing ? so our idea is to…
asked 2021-03-26T04:17:25.907+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(262.40000000000003, 75%, 35%)' 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)
Saravanan Balasubramanian
266
Reputation points
answered 2021-03-26T08:22:00.757+00:00
JiayaoZhu
3,911
Reputation points
2 answers
Does the Display Field work inthe Unattend?
I've never used the Display settings in 7.) Oobe System before. I entered 144 in DPI (which I found is 150%, I added 1920 horiz and 1200 vert. These settings do not get applied. Is this setting just not functional anymore? I have one Task Seq where…
asked 2021-03-23T19:33:19.66+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(211.20000000000002, 99%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERS%3C/text%3E%3C/svg%3E)
Rick Someone
411
Reputation points
commented 2021-03-26T08:11:50.077+00:00
AllenLiu-MSFT
47,971
Reputation points Microsoft Vendor
9 answers
Still having PS issues with upgrading software based on version
I just don't know the syntax to make this end. It does its job; it takes Office from 1705 to 2008 by version #, but once it does, it continues an endless loop of "Checking for Updates." Also, after the first run through, a popup comes up…
asked 2021-03-17T17:34:04.037+00:00
Rick Someone
411
Reputation points
commented 2021-03-26T08:09:59.287+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, 94%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIX%3C/text%3E%3C/svg%3E)
Ian Xue
39,471
Reputation points Microsoft Vendor
0 answers
SslStream TLSv1.2 client instance in MMC snap-in without modifying Windows config: can it be done?
We have a legacy MMC snap-in developed with the MMC Class Library. The snap-in assembly targets .NET Framework 4.7. We have a requirement to create TLSv1.2-enabled SSL client connections from the snap-in. Using a freshly installed Windows 10.0.19042…
Windows API - Win32
Windows API - Win32
A core set of Windows application programming interfaces (APIs) for desktop and server applications. Previously known as Win32 API.
2,737 questions
.NET Runtime
.NET Runtime
.NET: Microsoft Technologies based on the .NET software framework.Runtime: An environment required to run apps that aren't compiled to machine language.
1,195 questions
Windows 10 Security
Windows 10 Security
Windows 10: A Microsoft operating system that runs on personal computers and tablets.Security: The precautions taken to guard against crime, attack, sabotage, espionage, or another threat.
3,004 questions
asked 2021-03-25T20:36:16.95+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(51.2, 99%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EW6%3C/text%3E%3C/svg%3E)
WalterGoodwin-6869
1
Reputation point
commented 2021-03-26T08:08:26.21+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, 28.999999999999996%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EXZ%3C/text%3E%3C/svg%3E)
Xingyu Zhao-MSFT
5,371
Reputation points
2 answers
One of the answers was accepted by the question author.
Driver Power State Failure Help (Yes, another one)
I have been having this error pop up for about a year now after one of the major feature updates for windows. I forget which one, but I have tried many different methods to remedy this problem and none of them have worked. I was hoping someone could look…
asked 2021-03-25T19:21:04.45+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(278.4, 96%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
mrsinuschill
21
Reputation points
accepted 2021-03-26T08:06:19.773+00:00
mrsinuschill
21
Reputation points
0 answers
How to handle the authentication for Apps within OneLogin?
My company uses Office 365 within OneLogin. Therefore I need to log in to OneLogin first then sign into Office 365 (OneDrive). My question is how do I do the authentication for this in Python? I want to read the excel file stored in OneDrive directly. I…
asked 2021-03-26T01:19:37.77+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(249.60000000000002, 55.00000000000001%, 34%)' 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)
王 碩琛
1
Reputation point
commented 2021-03-26T08:02:44.72+00:00
Emi Zhang-MSFT
27,871
Reputation points Microsoft Vendor
2 answers
problem for creating a PDF file with reportviewer
hello, I would like to report a problem with the method render of reportviewer in a winform for PDF files The last version downloaded from package nuget "Microsoft.reportingServices.ReportViewerControl.Winforms" v150.1440.0 return an error for…
asked 2021-03-25T08:13:10.417+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(275.2, 89%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMD%3C/text%3E%3C/svg%3E)
Michel Drotkowski
1
Reputation point
answered 2021-03-26T08:00:17.207+00:00
Michel Drotkowski
1
Reputation point
1 answer
How to automate apply changes to child dlp policies those are done in master dlp policy using powershell?
Hi Team, How to automate apply changes to child dlp policies those are done in master dlp policy using powershell? Example: In case of any rule or action change in master policy we have find out the changes on periodic basis and need to apply them to…
asked 2021-03-16T05:26:32.467+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(99.2, 79%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKK%3C/text%3E%3C/svg%3E)
Koteswararao Kata
1
Reputation point
commented 2021-03-26T07:59:02.847+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(284.8, 17%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYS%3C/text%3E%3C/svg%3E)
Yuki Sun-MSFT
41,216
Reputation points Microsoft Vendor
0 answers
ETL TMF/PDB for SRCore.dll to read recovery restore logs
Hi, tl;dr: could you publish the ETL TMF/PDB for SRCore.dll 10.0.19041.1 providers, in particular: 18db3c95-39dd-3d64-f822-09d100573aae 57f88c3d-a6e5-34d7-e6ea-ccb24957812b 6159a5aa-b80b-3284-78fc-75a5764023f2 …
asked 2021-03-25T17:00:24.753+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, 47%, 39%)' 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)
Alexandre
1
Reputation point
commented 2021-03-26T07:55:44.02+00:00
Xiaowei He
9,926
Reputation points
0 answers
Need help in sending MMS picture via code
Hello all, I need some assistance in sending an MMS. I have some code That is based off of this code base: https://github.com/ceakins001/AndoidMobileAppTesting/tree/master/AndroidTest However, I replaced the Android.Net.Uri.Builder with the…
asked 2021-03-22T19:28:03.61+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(240, 86%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPM%3C/text%3E%3C/svg%3E)
Phillip Mobley
51
Reputation points
commented 2021-03-26T07:54:54.65+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(12.8, 87%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
JarvanZhang
23,966
Reputation points
2 answers
One of the answers was accepted by the question author.
Unable to create Azure VM backup. Stuck on Loading Select Backup Policy
I am trying to create a backup on a fresh azure VM (ubuntu) But the entry beside "Select Backup policy" is stuck on Loading. Hitting the enable button below just instructs me to Fix the errors…
asked 2021-03-24T14:19:14.643+00:00
David Brewster
31
Reputation points
answered 2021-03-26T07:54:46.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(22.400000000000002, 45%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESA%3C/text%3E%3C/svg%3E)
Seshadri Allimani
1
Reputation point
1 answer
Azure AD MFA for SharePoint Server Sites
Hi All, We have a customer who has a SharePoint Server 2019 installation in Azure VM which is domain joined to Azure AD. There is no Windows AD present. As per new security rules, they are trying to enable MFA for SharePoint Sites so that whenever the…
asked 2021-03-25T05:59:28.79+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(12.8, 8%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPS%3C/text%3E%3C/svg%3E)
Priyaranjan Sathyavrathan
1
Reputation point
commented 2021-03-26T07:50:48.787+00:00
Priyaranjan Sathyavrathan
1
Reputation point
0 answers
Showstopper: Problem with EWS requests to Office365 Public Folders
Hi guys, approximately 2 days ago our customers clashed with 2 problems during access to Office 365 Public Folders via EWS API. One of problem is described here https://github.com/OfficeDev/ews-managed-api/issues/263 when enumerating public…
asked 2021-03-26T07:06:16.04+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(268.8, 25%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EV%3C/text%3E%3C/svg%3E)
val19680507
1
Reputation point
commented 2021-03-26T07:48:44.373+00:00
Emi Zhang-MSFT
27,871
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
Create a Custom keyboard like google Keyboard in iOS
I know that there are ways to create custom keyboards for Xamarin.Forms & Xamarin.Android. Is there anywhere that I can find any good tutorials and/or documentation on how to do this? Thanks.
asked 2021-03-25T20:29:40.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(124.80000000000001, 92%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAN%3C/text%3E%3C/svg%3E)
anass nassim
41
Reputation points
commented 2021-03-26T07:41:49.32+00:00
anass nassim
41
Reputation points
2 answers
Are you not support windows 10 after 2025? i really don't want it to go and fade away.
After 2025 you said windows 10 will be vulnerable for attacks and gets me worry got this version 20h2 of windows
asked 2021-03-24T23:58:47.51+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, 36%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAC%3C/text%3E%3C/svg%3E)
Anthony Cruz
21
Reputation points
commented 2021-03-26T07:41:21.113+00:00
Teemo Tang
11,441
Reputation points
1 answer
One of the answers was accepted by the question author.
Updating an #microsoft.graph.openTypeExtension for message inside recoverableitemsdeletions folder
I added an #microsoft.graph.openTypeExtension to a message in inbox folder, then I deleted the message and it arrived to recoverableitemsdeletions folder. now I am trying to update(patch) this extension and I am getting: { "error": { …
asked 2021-03-22T09:32:31.187+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(192, 9%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIG%3C/text%3E%3C/svg%3E)
Idan Gazit
21
Reputation points
accepted 2021-03-26T07:40:54.327+00:00
Idan Gazit
21
Reputation points
1 answer
How to set enabled services for O365 license in C#
Can anyone provide me with some basic directions on how to turn specific enables servers off/on for an Office 365 A1 license? When I create a user and add the license to the that new user, all of the enabled services are set to on. I have researched this…
asked 2021-03-24T17:29:57.803+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(48, 56.00000000000001%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHU%3C/text%3E%3C/svg%3E)
Hiram Upchurch
1
Reputation point
commented 2021-03-26T07:39:13.3+00:00
Erin Ding-MSFT
4,461
Reputation points
0 answers
Does Downstream Replica WSUS server have to join the domain?
I want to set up a Downstream Replica WSUS on DMZ for external domain computers to get updates. Does Downstream Replica WSUS have to be a member server of the same domain with the upstream WSUS server? Can it be a standalone server? Thanks,
asked 2021-03-25T06:37:31.933+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(12.8, 71%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGY%3C/text%3E%3C/svg%3E)
Grace Yin
111
Reputation points
commented 2021-03-26T07:29:56.74+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(297.6, 24%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERH%3C/text%3E%3C/svg%3E)
Rita Hu -MSFT
9,646
Reputation points