SQL Server

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

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…

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…

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…

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…

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…

MS SQL Server Compatibility with Gallagher Command Center

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

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

Reinstalled SQLNCLI by SQL Server Hotfix

First, installed Microsoft SQL Server 2017 Database Engine which included shared component SQLNCLI. The found Microsoft SQL Server 2012 Native Client (SQLNCLI) was EOL, so successful uninstall it. After that, a Windows Update include Microsoft SQL Server…

How do I get SSRS version 15.0.1102.1047 from the Feb 2023 version

Please assist. I'm facing the challenges with deploying the reporting services. the newer versions of SSRS fail with the encryption key backup operations. Please can anyone share a link to this version? MS does not keep older versions. Anyone with a copy…

Alternatives to Crystal Reports for .NET compatible paginated reporting tools?

We're looking at tools for creating paginated reports. We have a couple of parameters: There needs to be up-to-date .NET libraries so we can have run the reports via C# wrappers in our code. Allows for pulling data from SQL Server We're…

Performance Regression Observed on SQL Server 2025 Running on Windows Server 2025

A reproducible performance degradation is observed when executing an identical SQL workload through SQL Server Management Studio (SSMS) on SQL Server 2025 running on Windows Server 2025. The workload consists of inserting 200,000 records into a table…

SQL Server: Index creation and conversion issues with columnstore indexes — Encountering internal query processor errors

Problem description I am experiencing issues when creating or converting indexes on a table with existing data in SQL Server running on an Azure VM. Specifically, when I attempt to create or modify clustered columnstore indexes with options like…

SQL Server 2022 Always On metadata calls slow after patching

Following recent patching of our on-premises SQL Server 2022 environment, transaction log backups have become significantly slower than before the patch.   The servers are configured with SQL Server Always On Availability Groups. The issue affects…

Cannot successfully install SQL Server 2025 Developer Standard Edition due to Engine Services Feature failure

Attempted to install SQL Server 2025, but was provided with the error details listed below. It should be noted that previous versions of SQL Server, 2019 and 2022, were installed in the past, but are now removed from the device. Attempted repair resulted…

SQL Server new Python version?

We are running SQL Server 2022 with machine learning services to execute python scripts. At the moment we are using the supported Python version 3.10 but this version is End Of Life. Microsoft is not supporting a new version? What is the path to take on…

C# script task error(binary code for the script is not found)

Our SSIS package is successfully running in Production environment. We received a request to add some extractions in the same package and the existing package has many C# script task. Now we are trying to modify and runs the package the package in…

Could you confirm whether the sold core packs cover 2 physical cores (which equals 4 vCPUs)?

i have updated visual studio ,after updating all my packages in project are not opening

i have updated visual studio ,after updating all my packages in project are not opening

how many databases can be backed up by default for a Single SQL server

Dealing with an issue where a user has a SQL server hosting 920 databases and is ruuning into errors when attempting to backup. Error being received is as follows: SQL Server has ~940 user databases. During the Ninja Image Backup, SqlServerWriter.txt…