SQL Server | SQL Server Transact-SQL
Programming language used to interact with SQL Server databases
296 questions
2 answers
One of the answers was accepted by the question author.
How to measure the server execution time of SQL
I want to know how long it takes for the server to complete the SQL after it is sent to the server, so that I can determine whether the time consumed when the program executes it is mainly in SQL Server, the network, or the backend/frontend program.
SQL Server | SQL Server Transact-SQL
![](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' %3EA%3C/text%3E%3C/svg%3E)
2 answers
Get-AzDataMigrationAssessment Generates Inconsistent JSON Formats and an Additional HTML File.
Hello Microsoft Team, I am using the Get-AzDataMigrationAssessment PowerShell cmdlet from the Az.DataMigration module to generate SQL Server migration assessment reports. The assessment covers the following three scenarios: …
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,826 questions
asked
2026-10-15T13:29:15.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(243.2, 98%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Shivam Singh
0
Reputation points
answered
2026-10-21T17:55:02.7966667+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, 63%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDD%3C/text%3E%3C/svg%3E)
Deepesh Dhake
1,325
Reputation points
2 answers
One of the answers was accepted by the question author.
numMsgsRcvd:1 should be less than numMsgsSent:1
I was starting up my Program as the following error occured: E/AndroidRuntime: FATAL EXCEPTION: pool-2-thread-1 Process: de.heffnersoftware.hsproduction, PID: 8295 java.lang.AssertionError: numMsgsRcvd:1 should be less than numMsgsSent:1 at…
Developer technologies | Transact-SQL
Developer technologies | Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,717 questions
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,826 questions
asked
2021-06-08T16:10:00.403+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, 50%, 18%)' 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)
Alexander
21
Reputation points
commented
2026-10-21T15:51:33.3066667+00:00
David Engel
0
Reputation points Microsoft Employee
3 answers
Import and Export Data option greyed out in SSMS 22 with SQL Server 2025 Developer
Hello, I am using SQL Server 2025 (RTM) – 17.0.1000.7 (Enterprise Developer Edition, 64-bit) on Windows 10 Pro. I installed: Database Engine Services (Default instance: MSSQLSERVER) Integration Services (added later via “Add features to existing…
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,826 questions
asked
2026-02-22T20:30:09.4333333+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, 57.00000000000001%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESP%3C/text%3E%3C/svg%3E)
Sabyasachi Paul
0
Reputation points
commented
2026-10-20T13:37:39.8866667+00:00
Erland Sommarskog
138.3K
Reputation points MVP
Volunteer Moderator
1 answer
SSRS Permissions Issue: User Unable to View Reports despite Browser Role
Hello, I’m facing an issue with SQL Server Reporting Services (SSRS). I have a user who is assigned to the “Browser” role on the folder, but despite this, the user is unable to view the reports. The user receives the error: Does anyone have…
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,188 questions
asked
2025-04-28T08:26:50.4333333+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, 46%, 10%)' 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)
Swa1209
90
Reputation points
answered
2026-10-20T04:45:01.19+00:00
Rukshan edirisinghe
2,125
Reputation points
1 answer
PDF Export with a custom font giving the error "Cannont find or create the font 'xyz,Bold'."
I've ran into an issue I have never seen before, maybe somebody could help before I pull my hair out any more. We've got some reports we did for a customer in SSRS. They work fine and render fine. Recently the customer gave us a custom font their…
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,188 questions
asked
2025-04-30T21:12:59.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(204.8, 68%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERB%3C/text%3E%3C/svg%3E)
Ryan Brothers
0
Reputation points
answered
2026-10-20T04:42:54.9066667+00:00
Rukshan edirisinghe
2,125
Reputation points
1 answer
How to get audit details from sys.fn_get_audit_file, sys.dm_audit_class_type_map and sys.dm_audit_actions ?
Hi, I want to extract audit details by using following dmvs SELECT distinct event_time, succeeded, server_principal_name, database_name, object_name, statement,fng.action_id ,da.name,fng.class_type FROM sys.fn_get_audit_file('C:\Audit*.sqlaudit',…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
793 questions
asked
2025-04-30T10:31:00.4933333+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, 26%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYA%3C/text%3E%3C/svg%3E)
Yasir Anis Janjua
0
Reputation points
answered
2026-10-20T04:41:17.67+00:00
Rukshan edirisinghe
2,125
Reputation points
1 answer
Report server doesn't support schedule refresh when using SharePoint Online as the data souce
Hi team, According to this page, https://learn.microsoft.com/en-us/power-bi/report-server/data-sources. I noticed the power BI report server doesn't support schedule refresh when connecting to SharePoint Online related as the data source. Would there be…
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,188 questions
asked
2026-09-17T01:36:22.14+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, 83%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYZ%3C/text%3E%3C/svg%3E)
Yang Zhao
0
Reputation points
answered
2026-10-20T04:39:34.0433333+00:00
Rukshan edirisinghe
2,125
Reputation points
1 answer
Help with the Azure SQL DTU Calculator
I am trying to load a CSV file into the DTU Calculator without success. Refer https://dtucalc.azurewebsites.net/ I receive a generic error message: Error! An error occurred while processing your request. See below for the first few lines of the CSV file…
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,826 questions
asked
2026-09-17T23:24:19.2066667+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(307.2, 92%, 39%)' 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)
Alan Macdonald
0
Reputation points
answered
2026-10-20T04:38:11.76+00:00
Rukshan edirisinghe
2,125
Reputation points
1 answer
Need original microsoft hecksum value for latest Microsoft Command Line Utilities for SQL Server before downloading
Hi, I need to download the latest version of Microsoft Command Line Utilities x64 for SQL Server for Windows OS. I can see it is available here: https://learn.microsoft.com/en-us/sql/tools/bcp/bcp-download-install?view=sql-server-ver17 Before installing…
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,826 questions
asked
2026-09-22T12:47:14.6166667+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, 64%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EG%3C/text%3E%3C/svg%3E)
GVC
10
Reputation points
answered
2026-10-20T04:36:41.02+00:00
Rukshan edirisinghe
2,125
Reputation points
1 answer
Cube failure due to data length issue
Cube failure with below error “Errors in the OLAP storage engine: An error occurred while the 'Diagnosis' attribute of the 'DimUniqueDiagnosis' dimension from the 'CQMC_RBGBGWS_Analysis_Test' database was being processed.” We are doing SL3 to SL4 server…
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,380 questions
asked
2026-09-24T10:17:43.5566667+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(44.800000000000004, 93%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK%3C/text%3E%3C/svg%3E)
Kayal
0
Reputation points
answered
2026-10-20T04:34:57.0766667+00:00
Rukshan edirisinghe
2,125
Reputation points
1 answer
Problemas persistentes al instalar y desinstalar SQL Server: error en KERNELBASE.dll y bloqueo de sqlservr.exe
Estoy experimentando problemas persistentes al intentar instalar y ejecutar SQL Server en mi PC. El problema continúa incluso después de desinstalar y reinstalar SQL Server y eliminar las carpetas de instalación. Según el análisis realizado por el…
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,826 questions
asked
2026-10-19T20:58:44.25+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, 80%, 20%)' 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)
Mauro Mariño
0
Reputation points
commented
2026-10-19T21:18:14.9633333+00:00
Erland Sommarskog
138.3K
Reputation points MVP
Volunteer Moderator
1 answer
electronic signature report
Is there a report I can pull electronic signatures by provider in Expanse?
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,188 questions
asked
2026-10-19T18:44:03.38+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(92.8, 28.999999999999996%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBA%3C/text%3E%3C/svg%3E)
Block Alyssa
0
Reputation points
answered
2026-10-19T18:46:01.86+00:00
AI answer
2 answers
Request to speak to a representative about SQL express
I cannot install sql express. Can I speak to a representative?
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,826 questions
asked
2026-10-19T14:09:13.83+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(121.6, 22%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EML%3C/text%3E%3C/svg%3E)
miriam litwin
0
Reputation points
edited an answer
2026-10-19T17:04:23.55+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, 61%, 30%)' 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)
Bruce (SqlWork.com)
85,621
Reputation points
7 answers
One of the answers was accepted by the question author.
Where are the SQL Server developer edition downloads
Where are the developer edition download files for SQL Server 2022, SQL Server 2019, and SQL Server 2017?
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
793 questions
asked
2026-03-24T22:21:49.96+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(272, 35%, 36%)' 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)
Steve Margolis
35
Reputation points
answered
2026-10-19T15:24:38.8833333+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, 92%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERC%3C/text%3E%3C/svg%3E)
Reich, Christian
0
Reputation points
2 answers
Non-User Account Information
Currently can export the report for one owner only. We need requirement to pull this report for Level6 Org. ?Can we have this feature?
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,188 questions
asked
2026-10-19T13:24:31.3566667+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, 59%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENJ%3C/text%3E%3C/svg%3E)
Nitin Jain
0
Reputation points
answered
2026-10-19T14:21:52.2133333+00:00
Erland Sommarskog
138.3K
Reputation points MVP
Volunteer Moderator
1 answer
How to avoid refreshing full data everytime on refreshing in on premises PowerBI Dashboards
I work in a finance corporate where there is a lot of data in our on premises PowerBI dashboards from either sql or excel, so on regular basis we face challenges on refreshing all the dashboards as every time it refreshes from the beginning, so I want a…
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,380 questions
asked
2026-10-19T11:28:50.89+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(16, 6%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESU%3C/text%3E%3C/svg%3E)
Syed Uzair
0
Reputation points
answered
2026-10-19T11:30:58.0933333+00:00
AI answer
1 answer
One of the answers was accepted by the question author.
How to Replace %S with Feature Value on Feature String Based on Feature Name and partid?
I work on sql server 2017 i need write select query Replace %S with Feature Value on Column Feature String Based On partid and Feature Name Related . as example partid 1211 have Feature String AC(%S)Boil(%S)Temp(%S) I need to replace %S…
Developer technologies | Transact-SQL
Developer technologies | Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,717 questions
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,826 questions
asked
2022-06-09T17:50:14.997+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, 77%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
ahmed salah
3,216
Reputation points
commented
2026-10-17T23:15:32.8+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(144, 99%, 23%)' 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)
jenari millender
0
Reputation points
1 answer
One of the answers was accepted by the question author.
New CE ignores statistics for LIKE predicates on varchar columns with UTF-8 collations — fixed 9% guess (partially fixed in CE 170, `%x%` still affected, no backport)
SUMMARY For varchar columns using any UTF-8 collation (collation name ending in _UTF8), the modern cardinality estimator (CE model 120 to 160) never consults the histogram or string statistics for LIKE predicates. Every "LIKE 'prefix%'" and…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
793 questions
asked
2026-08-21T14:07:13.2433333+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, 98%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH%3C/text%3E%3C/svg%3E)
Hubert
20
Reputation points
commented
2026-10-17T20:34:38.23+00:00
Erland Sommarskog
138.3K
Reputation points MVP
Volunteer Moderator
1 answer
SQL Server connect error with SSL Cert
Hello, I get this error when logging in to an SQL Server instance: ssl provider error 0 an existing connection was forcibly closed by the remote host error 10054 That happened after I added a certificate to that instance. The same certificate works…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
793 questions
asked
2026-10-14T13:28:50.75+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, 52%, 37%)' 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)
David Spenner
5
Reputation points
recommended
2026-10-17T10:42:50.32+00:00
Erland Sommarskog
138.3K
Reputation points MVP
Volunteer Moderator