21,834 questions with SQL Server-related tags

Sort by: Updated
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
Mauro Mariño 0 Reputation points
commented 2026-10-19T21:18:14.9633333+00:00
Erland Sommarskog 138.2K 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
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
miriam litwin 0 Reputation points
edited an answer 2026-10-19T17:04:23.55+00:00
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
asked 2026-03-24T22:21:49.96+00:00
Steve Margolis 30 Reputation points
answered 2026-10-19T15:24:38.8833333+00:00
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
Nitin Jain 0 Reputation points
answered 2026-10-19T14:21:52.2133333+00:00
Erland Sommarskog 138.2K 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
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
ahmed salah 3,216 Reputation points
commented 2026-10-17T23:15:32.8+00:00
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
asked 2026-08-21T14:07:13.2433333+00:00
Hubert 20 Reputation points
commented 2026-10-17T20:34:38.23+00:00
Erland Sommarskog 138.2K 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
asked 2026-10-14T13:28:50.75+00:00
David Spenner 5 Reputation points
recommended 2026-10-17T10:42:50.32+00:00
Erland Sommarskog 138.2K Reputation points MVP Volunteer Moderator
3 answers

Resolve Deadlocks on Transaction Tables

I configured high-traffic transaction tables for our corporate workstation applications and enterprise services. Not only was I not able to maintain normal query performance during peak business hours due to parallel execution deadlocks, I have been…

SQL Server Database Engine
asked 2026-10-13T16:34:07.7866667+00:00
Freya Davies 5 Reputation points
commented 2026-10-16T15:52:30.89+00:00
Erland Sommarskog 138.2K Reputation points MVP Volunteer Moderator
1 answer One of the answers was accepted by the question author.

I have been purchased Microsoft SQL Server Standard Edition 2025 downgrade Kit. But product license key is showing SQL Server Standard Edition 2019

I do require 2022 Product License Key. There is a mismatch with SQL Server Standard Edition 2025 downgrade kit and Product key license 2019

SQL Server Migration Assistant
SQL Server Migration Assistant

A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.

610 questions
asked 2026-10-16T13:04:16.5066667+00:00
Naveen C 20 Reputation points
commented 2026-10-16T15:27:19.02+00:00
Bruce (SqlWork.com) 85,621 Reputation points
2 answers

firewall rule preventing user login

I have a sql database "LIMLdb" running on "apgsystems01" sql server running on a virtual machine. I need to be able to have my users log in from different locations. When they try the are assigned a new ip and cannot log in until I…

SQL Server Database Engine
asked 2026-09-30T16:28:53.53+00:00
orville wright 0 Reputation points
edited an answer 2026-10-16T07:45:30.5366667+00:00
Ana Mihaila (BLUEHAWK LLC) 0 Reputation points Microsoft External Staff Moderator
1 answer

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
Shivam Singh 0 Reputation points
answered 2026-10-15T13:30:32.7+00:00

AI answer

2 answers

SQL Server 2022 Express download page (ID 104781) returns 404 – Is SQL Server 2022 Express still available?

Hello, We are trying to obtain the official installation media for Microsoft SQL Server 2022 Express, but we have found that the historical Microsoft Download Center page associated with SQL Server 2022 Express (Download ID 104781) is currently returning…

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,826 questions
asked 2026-09-25T20:45:35.3533333+00:00
Marc Castillo 0 Reputation points
answered 2026-10-14T13:26:33.8466667+00:00
Erland Sommarskog 138.2K Reputation points MVP Volunteer Moderator
1 answer

where to download sql server express 2022

Try to upgrade an older version of sql express 2017 to 2022. Where to download sql server express 2022, thanks

SQL Server Database Engine
asked 2026-10-13T19:03:52.4166667+00:00
AnneW 86 Reputation points
answered 2026-10-13T19:07:46.5566667+00:00
Mark Woods 10 Reputation points
1 answer One of the answers was accepted by the question author.

Rebuild Indexes vs Update Statistics

I have a 165TB database on SQL2022 server and is part of a DAG. ETL (load/delete) is done every night on 35k tables and the largest table average load is 5-6 million rows. The largest table is 6.5TB (30 tables over 1TB) and has six Non-Clustered indexes…

SQL Server Database Engine
asked 2026-10-13T16:13:04.51+00:00
Parsons, Tim 20 Reputation points
commented 2026-10-13T18:44:49+00:00
Erland Sommarskog 138.2K Reputation points MVP Volunteer Moderator
2 answers

Migration from SSRS to Power BI

Please assist with this. Requirement is analyzing existing SSRS reports and migrate appropriate reports to Power BI paginated or interactive reports based on business, formatting, export, and distribution requirements. Which tool is best and share the…

SQL Server Migration Assistant
SQL Server Migration Assistant

A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.

610 questions
asked 2026-10-12T23:51:59.3933333+00:00
Bhanu Nizampatnam 0 Reputation points
answered 2026-10-13T06:56:47.0066667+00:00
Erland Sommarskog 138.2K Reputation points MVP Volunteer Moderator
4 answers One of the answers was accepted by the question author.

T-SQL query takes 13 seconds to run in SQL Server Manager but 20 minutes as stored procedure

As per the title, I have a stored procedure that takes 20 minutes to run. In order to debug the reason I the put the sp into a query by just declaring the procedure parameters and ran it. It took only 13 seconds. The only difference is that one is a…

SQL Server | SQL Server Transact-SQL
asked 2026-10-10T16:40:31.9333333+00:00
OHPRS Admin 361 Reputation points
commented 2026-10-12T21:12:30.2833333+00:00
Erland Sommarskog 138.2K Reputation points MVP Volunteer Moderator
2 answers

MS SQL Server Compatibility with Gallagher Command Center

Is MS SQL Server 2025 compatible with Gallagher Command Center version 8.40 and 8.90?

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,826 questions
asked 2026-10-12T12:41:43.96+00:00
Khalid Khan Tareen 0 Reputation points
answered 2026-10-12T17:49:54.5933333+00:00
Deepesh Dhake 1,325 Reputation points
2 answers

TF400981: Failed to backup the Reporting Services encryption key.

TF400981: Failed to backup the Reporting Services encryption key. You can try using RSKEYMGMT command to backup the encryption key Completed Verify Backup Encryption Key Operation: Warning

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 2022-10-17T11:07:33.09+00:00
Pratik Makwana 1 Reputation point
commented 2026-10-09T21:23:23.1166667+00:00
Chidi Onwuchekwa 0 Reputation points