Additional SQL Server features and topics not covered by specific categories
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
electronic signature report
Is there a report I can pull electronic signatures by provider in Expanse?
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.
AI answer
Request to speak to a representative about SQL express
I cannot install sql express. Can I speak to a representative?
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
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
Core component of SQL Server for storing, processing, and securing data
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
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
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
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.
AI answer
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
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
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
Core component of SQL Server for storing, processing, and securing data
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
Core component of SQL Server for storing, processing, and securing data
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
Core component of SQL Server for storing, processing, and securing data
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
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
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
Core component of SQL Server for storing, processing, and securing data
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
Additional SQL Server features and topics not covered by specific categories
AI answer
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
Additional SQL Server features and topics not covered by specific categories
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
Core component of SQL Server for storing, processing, and securing data
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
Core component of SQL Server for storing, processing, and securing data
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
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
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
Programming language used to interact with SQL Server databases
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
Additional SQL Server features and topics not covered by specific categories
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
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.