SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,020 questions
4 answers
update stats
one of our applications that selects data from tables using multiple joins only work when update stats is performed on all underlying tables. we had to update stats like evry 5 mins. what could be the reason stats needing update for the query to…
asked 2020-09-24T21:41:40.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(172.8, 99%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN%3C/text%3E%3C/svg%3E)
NeophyteSQL
241
Reputation points
commented 2020-09-28T01:21:54.06+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, 78%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECZ%3C/text%3E%3C/svg%3E)
Cris Zhan-MSFT
6,636
Reputation points
4 answers
Stored Procedure count of records only once
Hi, I am using below stored procedure it works fine,but for each call I want only once the count of records. how can I achieve this ? How should I modify my code logic. Sometimes the records in the table are not starting from 0 So if Poll is 0....I am…
asked 2020-09-24T21:34:48.687+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, 97%, 25%)' 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)
Rock Hitman
46
Reputation points
commented 2020-09-28T01:21:46.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(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,581
Reputation points
3 answers
How to detect Ctrl kkey Down ?
Hello & Thanks , win 10 vs 2019 vb.net .vb WebBrowser app . I am trying to detect Ctrl key pressed . For some sites , in this case pbskids.org , I am unable to make a click on image-link work . But in 'Sub TimerStatus_Tick' hover over…
asked 2020-09-21T21:18:33.507+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(86.4, 17%, 18%)' 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)
vmars316
621
Reputation points
commented 2020-09-28T01:21:27.42+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(19.2, 7.000000000000001%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDZ%3C/text%3E%3C/svg%3E)
Daniel Zhang-MSFT
9,626
Reputation points
4 answers
Adjusting start and end dates sql
Given a data set in MS SQL Server 2016 StoreID PurchaseID ShopID LocationID Starttime Endtime 1020 20200102 9856 0010 2020-01-08 09:08:53 2020-01-08 09:11:52 1021 20200102 9856 0020 2020-01-08 09:09:48 2020-01-08…
asked 2020-09-23T21:23:35.507+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(198.4, 61%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
red
21
Reputation points
commented 2020-09-28T01:19:59.233+00:00
EchoLiu-MSFT
14,581
Reputation points
2 answers
One of the answers was accepted by the question author.
unable to schedule the AZ900 exam .in certification dashboard cant restore my discounts please provide the support
Pearson VUE customer support we have restored that voucher already. To get it reinstated to your email address again you need to contact Microsoft and they will help you with this. the exam was canceled by Pearson VUE due to a technical issue. The…
asked 2020-09-27T07:29:15.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(32, 20%, 13%)' 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)
yogapriya sampath kumar
121
Reputation points
commented 2020-09-28T01:16:40.447+00:00
yogapriya sampath kumar
121
Reputation points
1 answer
Microsoft Interop Assembly for Excel Fails
Does Microsoft.Office.Interop.Excel work in x64 and Any CPU modes after updating MS Office 2019? My application fails when attempting to add a workbook with: Unable to cast COM object of type 'Microsoft.Office.Interop.Excel.ApplicationClass' to interface…
asked 2020-09-25T20:22:31.843+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(32, 98%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAB%3C/text%3E%3C/svg%3E)
a b
1
Reputation point
commented 2020-09-28T01:16:04.37+00:00
Emily Hua-MSFT
27,651
Reputation points
2 answers
Active Directory Authentication to SQL Server
I would like to Windows Authentication for our SQL Servers. In the past I would add the user window login to the Logins for SQL Server but maintenance was an ordeal. Is it possible to have SQL Server use AD or AAD to authenticate to the database. So…
asked 2020-09-23T19:50:25.223+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, 65%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
Hannah Melton
51
Reputation points
commented 2020-09-28T01:15:13.723+00:00
Cris Zhan-MSFT
6,636
Reputation points
2 answers
Where is my certificate
Hi, I've just passed in the Microsoft 70-761 Exam, but I can't get the certificate. Every time I click on "view certificates" it goes to an empty page and keep running forever. Could anybody help me on that please? Thanks Eduardo
asked 2020-09-21T12:04:29.157+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(140.8, 74%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEG%3C/text%3E%3C/svg%3E)
Eduardo Godoy
1
Reputation point
commented 2020-09-28T01:13:28.057+00:00
Cris Zhan-MSFT
6,636
Reputation points
3 answers
Should the AlwaysOn Listener be displayed as a cluster resource?
Once the SQL listener is configured in a SQL Server Always On Availability Group, it also becomes a cluster resource. That in the failover cluster manager under roles it should be listed. Is this true? If it is true what would cause the listener not…
asked 2020-09-24T14:06:12.123+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, 75%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELS%3C/text%3E%3C/svg%3E)
Lehr, Sherry (work)
1
Reputation point
commented 2020-09-28T01:07:19.13+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,986
Reputation points Microsoft Vendor
1 answer
Queation about WSUS Content Location Selection
Hi, Currently our SCCM infra is a standalone Primary site server with one Software Update Point. We are installing a new SUP on a remote site system server. So the new SUP will be a downstream to the SUP on the Primary site server. While installing…
asked 2020-09-17T13:55:17.717+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, 71%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELD%3C/text%3E%3C/svg%3E)
Lorin Davis
21
Reputation points
commented 2020-09-28T01:07:00.737+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,641
Reputation points
0 answers
WSUS administration console was unable to connect to the WSUS Server via the remote API.
i am receiving below error on one of the WSUS Slave server. Master have multiple Slaves. Other slaves are working fine but this one started giving below error The WSUS administration console was unable to connect to the WSUS Server via the remote…
asked 2020-09-17T12:51:12.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(12.8, 69%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDS%3C/text%3E%3C/svg%3E)
Dinesh Sawarkar
1
Reputation point
commented 2020-09-28T01:06:01.107+00:00
Rita Hu -MSFT
9,641
Reputation points
2 answers
SQL Injection
What is SQL Injection and How to Prevent Attacks?
asked 2020-09-21T05:16:19.28+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(9.6, 86%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPI%3C/text%3E%3C/svg%3E)
Prancer Io
21
Reputation points
commented 2020-09-28T01:04:54.76+00:00
AmeliaGu-MSFT
13,986
Reputation points Microsoft Vendor
1 answer
issue: gpupdate /sync error
Hello, When I perform a gpupdate /sync I get the error: "Failed to set policy mode. Error - The system cannot find the file specified" and gpupdate /force or boot works correctl. I run the cmd as administrator. Can anyone assist me? …
Windows
Windows
A family of Microsoft operating systems that run across personal computers, tablets, laptops, phones, internet of things devices, self-contained mixed reality headsets, large collaboration screens, and other devices.
5,515 questions
![](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(9.6, 1%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFB%3C/text%3E%3C/svg%3E)
![](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, 96%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFF%3C/text%3E%3C/svg%3E)
1 answer
Updating Dnssuffix in AOVPN xml
Hi Team We wanted to update multiple DNS names in AOVPN profile xml file to include in DNS Suffix but could not find any reference. We are trying with below currently but its not working …
asked 2020-09-08T17:37:10.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(204.8, 41%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMA%3C/text%3E%3C/svg%3E)
Mahesh Aralelemath
386
Reputation points
commented 2020-09-28T00:31:16.497+00:00
Candy Luo
12,711
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
Missing VfW methods.
In which DLL are the following VfW methods (Vfw.h) located? /**************************************************************************** * * call these to start stop using VfW from your app. * …
![](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(169.60000000000002, 7.000000000000001%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET%3C/text%3E%3C/svg%3E)
2 answers
One of the answers was accepted by the question author.
Why can I not install Security Update for Windows KB4566425?
I am trying to install this update on Windows 8.1 x64bit. I manually downloaded the file and tried to run it, but the installation fails. I initially tried to install it through the windows update form where it was automatically downloaded, but it also…
Windows
Windows
A family of Microsoft operating systems that run across personal computers, tablets, laptops, phones, internet of things devices, self-contained mixed reality headsets, large collaboration screens, and other devices.
5,515 questions
asked 2020-09-25T00:36:57.283+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(28.799999999999997, 4%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAV%3C/text%3E%3C/svg%3E)
Anthi Valavani
26
Reputation points
accepted 2020-09-27T22:08:19.903+00:00
Anthi Valavani
26
Reputation points
2 answers
One of the answers was accepted by the question author.
Missed exam
I missed my exam and that Is completely on me. I did purchase the replay voucher and would like to use that but I am currently unable to schedule using the voucher due to the current test enrollment still being open. What do I need to do in order to…
asked 2020-09-26T17:43:31.813+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(198.4, 16%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECR%3C/text%3E%3C/svg%3E)
Christopher Rossiter
21
Reputation points
accepted 2020-09-27T21:54:56.393+00:00
Christopher Rossiter
21
Reputation points
2 answers
Microsoft teams most recent update has serious bugs in linux
I'm using teams on linux, it's been working just fine until last night when I updated it, now when I join a group call it works for a moment and then it kicks me out and crashes, plus if someone shares his screen, I can't see it, please help this is…
asked 2020-09-17T18:12:11.78+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(80, 57.99999999999999%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBH%3C/text%3E%3C/svg%3E)
Boughraira, Hamza
16
Reputation points
answered 2020-09-27T21:34:43.673+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, 0%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMJ%3C/text%3E%3C/svg%3E)
Marian Javorka - MSFT
936
Reputation points Microsoft Employee
4 answers
Accessing RDP server from a trusted site
Hello, we have 2 trusted sites. Site 1 and Site 2. Site 1 has an RDP server. How can I have users from Site 2 login to the RDP server on Site 1? I cannot add the users from Site 2 to the RDP Server user group. Thank you
asked 2020-09-19T14:14:04.853+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, 48%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECG%3C/text%3E%3C/svg%3E)
Computer Gladiator
441
Reputation points
commented 2020-09-27T21:32:18.997+00:00
Computer Gladiator
441
Reputation points
1 answer
Install client on server
should i create a separate client push account for installing sccm client on servers? what is the best way to deploy sccm client on existiing servers? what is the best way to deploy sccm client on new servers? what ports need to be opened for…
asked 2020-09-27T01:45:13.183+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(140.8, 83%, 23%)' 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)
Karun Khanna
46
Reputation points
answered 2020-09-27T20:22:33.863+00:00
Jason Sandys
31,311
Reputation points Microsoft Employee