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
One of the answers was accepted by the question author.
table deletes are very slow
Hi All, Have some questions LOB data. One of the table with below schema has reached to 500GB. Application team is trying to delete some data from this table and it is taking more time. We aren’t sure what is really happening. The deletes are getting…
![](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(217.60000000000002, 34%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
Automation for stop SAP System and shutdown VM, power onf VM and satrt SAP Instance.
What would be the correct way to create automation: stop the SAP system services and shut down the VM? Turn on the VM and start the SAP system services? To turn it on and off I imported the Runbooks gallery: Shutdown / Start VMs by tag, By Gisela…
asked 2020-08-25T22:15:51.483+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(281.6, 94%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERA%3C/text%3E%3C/svg%3E)
Rubens Abibe
21
Reputation points
accepted 2020-11-05T18:36:40.173+00:00
Rubens Abibe
21
Reputation points
2 answers
Xamarin Android & IOS build fails on pipeline giving error The process '/Library/Frameworks/Mono.framework/Versions/5_16_0_0/bin/msbuild' failed with exit code 1
vm image : 'macOS-10.14' Log: 2020-11-04T08:03:29.7795280Z ##[section]Starting: Build Application 2020-11-04T08:03:29.7807080Z ============================================================================== 2020-11-04T08:03:29.7807490Z…
asked 2020-11-04T16:59:14.623+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(224.00000000000003, 8%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVS%3C/text%3E%3C/svg%3E)
Vedant Shyam Gawade
1
Reputation point
answered 2020-11-05T18:36:38.557+00:00
Leon Laude
85,881
Reputation points
3 answers
One of the answers was accepted by the question author.
Did the SharePoint Online Page Margins Change?
There was a little padding on the far left and far right side of the page for SharePoint Online Communication sites where the web part spans the width of the page. Did this change recently where Microsoft may have removed the padding? There isn't a…
asked 2020-11-04T18:59:49.15+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(25.6, 4%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEK%3C/text%3E%3C/svg%3E)
Eichler, Kurt
76
Reputation points
accepted 2020-11-05T18:28:25.617+00:00
Eichler, Kurt
76
Reputation points
1 answer
One of the answers was accepted by the question author.
Cert Testing issue
I am trying to view and sign up for a cert test and am getting this error: We can’t access your Microsoft profile to schedule your exam. To resolve the issue, try these steps in this order and return to the exam page to schedule the exam: Use…
![](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(208, 65%, 30%)' 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)
2 answers
One of the answers was accepted by the question author.
My web page is gone
Hi, I had a web app setup at paliscriptconverter.azurewebsites.net and that URL does not exist anymore. I cleaned up some services that I didn't use and kept that one only but somehow it does not exist anymore. I didn't get any notification from…
![](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(291.2, 89%, 38%)' 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)
1 answer
Cert Test Results not showing up after 72 + hrs
Hi I took a test early Monday morning and passed, it said it will take upto 48 hrs for it to show up, its been 72 and I don't see any record of passing the exam
asked 2020-11-05T17:43:51.787+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(259.20000000000005, 97%, 35%)' 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)
pcoelho
6
Reputation points
answered 2020-11-05T18:13:06.263+00:00
Leon Laude
85,881
Reputation points
1 answer
SQL Server on linux : PID
what's the difference between these two pid ? what the actual thing was running in these two different PID ?
0 answers
Azure Data Lake Gen2 - Use Case Advice
I am collecting weather data (history and forecast) from a third part web service. Since there will be a lot of data, and it will not have high use, I was planning to use Azure Data Lake Gen2 with blob storage, and storing the data in JSON files. My…
asked 2020-10-30T14:58:46.347+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(291.2, 27%, 38%)' 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)
Eric Maibach
1
Reputation point
commented 2020-11-05T18:02:15.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(192, 26%, 28%)' 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)
HimanshuSinha-msft
19,476
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Unable to use Azure Devops Teams Connector - Stuck in Sign-in loop
When I try to enable the Azure Devops connector in Microsoft Teams, it prompts for sign in, and then after I'm signed in, I'm taken back to the Teams app where it's still asking me to login. No error or anything. I've tried typical troubleshooting…
Microsoft Teams
Microsoft Teams
A Microsoft customizable chat-based workspace.
10,898 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(224.00000000000003, 83%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZE%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(240, 52%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWL%3C/text%3E%3C/svg%3E)
2 answers
One of the answers was accepted by the question author.
DBCC Page rowsize
I have a table with CREATE TABLE dbo.NOT_UNIQUE ( ID INT NULL , COL1 INT NULL, COL2 CHAR(10) NULL ); But why the rowsize is 33?? byte? int should be 4byte, CHAR(10) 10 bytes,,,, and including the uniqueidentifier hidden…
asked 2020-11-03T10:23:57.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(137.6, 40%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
sakuraime
2,336
Reputation points
commented 2020-11-05T17:54:05.487+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(35.2, 30%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETH%3C/text%3E%3C/svg%3E)
tibor_karaszi@hotmail.com
4,316
Reputation points
2 answers
One of the answers was accepted by the question author.
Are AAD security groups supported in Synapse Analytics (workspaces preview) SQL On-Demand Databases?
Trying to add a security group user (database level) results in an error: '' is not a valid login or you do not have permission. Are security groups not supported in preview? Will they be supported in GA?
asked 2020-10-28T14:25:26.627+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(220.8, 81%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVP%3C/text%3E%3C/svg%3E)
Valter Prykäri
126
Reputation points
commented 2020-11-05T17:48:46.773+00:00
HimanshuSinha-msft
19,476
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
Report to list all apps owned by an application registration or service principle
Hi, We have an application registered as a service principal that is used to create via automation other app registrations. When this is done, the owner of the app is this 'app' that is used for automation. When I try to list all apps 'owned' by…
asked 2020-11-04T15:53:58.153+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, 41%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKG%3C/text%3E%3C/svg%3E)
Komoroske, Gina
376
Reputation points
commented 2020-11-05T17:48:23.737+00:00
JamesTran-MSFT
36,811
Reputation points Microsoft Employee
1 answer
Azure Data Factory key column watermakr workflow?
How to Incrementally copy data using Identity column or incrementing key column instead of time-stamp. We checked many blogs but didn't find how to implement this. This mechanisms is going to be used for ‘N’ # of tables. How can we implement…
asked 2020-10-29T16:20:43.833+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, 35%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAG%3C/text%3E%3C/svg%3E)
Anmol Ganju
1
Reputation point
commented 2020-11-05T17:37:19.427+00:00
HimanshuSinha-msft
19,476
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
i have dome mcsa 2008 which certification should i do
i have done mcsa 2008 which certification should i do as far as far as new certification is concern i heard there is new road map please guide
asked 2020-11-05T17:07:41.057+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(60.8, 14.000000000000002%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMH%3C/text%3E%3C/svg%3E)
mery hesam
21
Reputation points
accepted 2020-11-05T17:18:03.16+00:00
mery hesam
21
Reputation points
1 answer
Wher should we update the new password for SCOrch Action account
Hi All, To increase complexity to the passwords, we want to change the password of SCOrch action account. Please let me know in which places it should be updated in SCOrch after changing the password in AD. It will help me to plan and make the change…
asked 2020-11-05T15:49:38.343+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(6.4, 61%, 10%)' 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)
Diana Shiny
1
Reputation point
commented 2020-11-05T17:16:49.99+00:00
Leon Laude
85,881
Reputation points
2 answers
One of the answers was accepted by the question author.
SCCM client over VPN
Hi Everyone, Hope you all are doing safe and sound :). Need your expertise regarding some task that we want to accomplish in this Covid and I hope someone's experience could help me out with it. from anyone's experience, what would be the best way…
asked 2020-10-30T16:26:51.32+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(256, 83%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESD%3C/text%3E%3C/svg%3E)
Shashi Dubey
376
Reputation points
commented 2020-11-05T17:16:25.247+00:00
Shashi Dubey
376
Reputation points
1 answer
Microsoft Edge 44.19041.1.0 para win 7 y win 10
donde puedo descargar Microsoft Edge 44.19041.1.0 para win 7 y win 10 o portable
asked 2020-11-04T15:29:44.347+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(118.4, 21%, 21%)' 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)
carlos rodriguez rojas
1
Reputation point
commented 2020-11-05T17:15:07.527+00:00
carlos rodriguez rojas
1
Reputation point
2 answers
One of the answers was accepted by the question author.
Focus Assist Crashes when wpnuserservice disabled or not available
I was hoping to avoid the whole unistack svcgroup service. wpnuserservice being one of them. But when you disable that service Focus Assist in Settings / System crashes. People have posted about why Focus Assist crashes. This may be one vector…
asked 2020-10-30T21:33:43.18+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(96, 85%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
Stan Kasper
1,426
Reputation points
accepted 2020-11-05T17:01:59.74+00:00
Stan Kasper
1,426
Reputation points
1 answer
One of the answers was accepted by the question author.
How to process multiple error codes from a database restore using TRY...CATCH?
So we have a homegrown hot-standby system (in case you're wondering why homegrown, it's because we've tried all the variations available from MS for SQL and TBH none have proven to meet our exacting standards) and we run the restore in a TRY...CATCH…
asked 2020-10-26T19:05:14.17+00:00
Michael MacGregor
86
Reputation points
commented 2020-11-05T16:49:23.75+00:00
tibor_karaszi@hotmail.com
4,316
Reputation points