19,170 questions with SQL Server-related tags

Sort by: Updated
0 answers

Which recommended included columns to really include in indexes?

Greetings. I just ran sql logScout and sql nexus against a heavily used reporting server during a peak time of day for 10 minutes just to see what it comes back with. About 20 indexes were recommended for the same table. Over the years Ive come to use…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,759 questions
asked 2024-10-01T17:46:42.66+00:00
chrisrdba 411 Reputation points
2 answers One of the answers was accepted by the question author.

Is my Resource Governor set up correctly?

Greetings. I have a particular server configured as follows: DB1 -- this guy is the Subscriber of a transaction replication topology. DB2 -- this guy is a Data Warehouse (using that term loosely). If queries data from DB1, as well as other sources…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,759 questions
asked 2024-09-18T18:01:13.3533333+00:00
chrisrdba 411 Reputation points
commented 2024-10-01T17:30:33.97+00:00
chrisrdba 411 Reputation points
0 answers

TLS 1.0 and TLS 1.1 deprecation ,Will it Stop Azure VM internal servers communication

Hi, We have two servers running on Azure. Both servers are running on Windows Server 2008 R2. One server is configured as an IIS server, and the other is a legacy SQL Server. Both servers communicate with each other using TLS 1.0 and 1.1. My question is:…

Internet Information Services
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,759 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
13,027 questions
Windows Server Security
Windows Server Security
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.Security: The precautions taken to guard against crime, attack, sabotage, espionage, or another threat.
1,829 questions
asked 2024-10-01T11:12:34.7633333+00:00
Rashid Ahmed Qazi 20 Reputation points
edited the question 2024-10-01T17:14:23.86+00:00
Grmacjon-MSFT 17,886 Reputation points
2 answers

Is it good to use single database connection for all database operations in one API request?

In general, I know the best practice while handling database connections in C#/ADO.NET is to open Db connection just before querying the Db & close the connection immediately after query execution, so that connection gets back to pool. My question…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,759 questions
asked 2024-09-30T18:48:01.8833333+00:00
Abhilash Perla 0 Reputation points
commented 2024-10-01T17:03:40.86+00:00
Erland Sommarskog 110.8K Reputation points MVP
1 answer

Max value of each column in a table

Hi there, I have 500+ Azure SQL tables with total of 25000+ columns. Most of the tables have varchar (max), or nvarchar(max) but to contain a value which could only be 3 , 5 or 20 characters long. --for characters select max(**len(**columnname)) from…

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,759 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,634 questions
asked 2024-09-30T20:57:09.8933333+00:00
RJ 146 Reputation points
commented 2024-10-01T17:00:15.79+00:00
Erland Sommarskog 110.8K Reputation points MVP
0 answers

SQL Server shared LocalDB instance is not automatically starting

I have an application that uses LocalDB. The named instance "PrivDb" is owned by whatever account installed the application. Part of the setup process is to grant "NT AUTHORITY\Authenticated Users" the sysadmin role so that any…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,759 questions
asked 2024-10-01T15:33:46.8233333+00:00
Cory Riddell 0 Reputation points
edited the question 2024-10-01T16:27:08.1433333+00:00
Cory Riddell 0 Reputation points
1 answer

EF Core 8 Shadow Properties incur a 255 limit on columns

We have an EF based WebApi, and the business logic includes the ability for end users to add user defined fields To get that in EF, we engaged Shadow Properties, and that is working well Unfortunately we found Shadow Properties incur a limit of 255…

ASP.NET Core
ASP.NET Core
A set of technologies in the .NET Framework for building web applications and XML web services.
4,547 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,759 questions
asked 2024-10-01T15:21:02.83+00:00
Bill Stamp 1 Reputation point
edited an answer 2024-10-01T15:34:04.55+00:00
Bruce (SqlWork.com) 64,826 Reputation points
1 answer

SQL Server on Azure VM Backup minimizing data duplication

A while back, a Microsoft support engineer recommended using SQL on VM backups. The suggestion was to create an SQL DB in an Azure VM job and an Azure VM job, excluding the disks that host the SQL files, to avoid data duplication. If the VM is deleted…

SQL Server on Azure Virtual Machines
Azure Backup
Azure Backup
An Azure backup service that provides built-in management at scale.
1,254 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,759 questions
asked 2024-09-29T01:18:07.9433333+00:00
Josue Del Valle 20 Reputation points
commented 2024-10-01T15:11:50.9566667+00:00
Sai Raghunadh M 310 Reputation points Microsoft Vendor
1 answer One of the answers was accepted by the question author.

better query for select results based on date.

What is the best way to write this code to get the date results? I have the time throughout the day in the datetime field. SELECT * FROM Reconciliation.Documents D Inner Join Reconciliation.DocumentsTransaction T ON D.DocumentPKey = T.DocumentPKey WHERE…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,759 questions
SQL Server Transact-SQL
SQL Server Transact-SQL
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Transact-SQL: A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
96 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,634 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,759 questions
SQL Server Transact-SQL
SQL Server Transact-SQL
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Transact-SQL: A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
96 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,634 questions
asked 2024-09-30T19:03:37.35+00:00
Jonathan Brotto 400 Reputation points
accepted 2024-10-01T14:47:10.7333333+00:00
Jonathan Brotto 400 Reputation points
1 answer One of the answers was accepted by the question author.

better query for select results based on date.

What is the best way to write this code to get the date results? I have the time throughout the day in the datetime field. SELECT * FROM Reconciliation.Documents D Inner Join Reconciliation.DocumentsTransaction T ON D.DocumentPKey = T.DocumentPKey WHERE…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,759 questions
SQL Server Transact-SQL
SQL Server Transact-SQL
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Transact-SQL: A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
96 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,634 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,759 questions
SQL Server Transact-SQL
SQL Server Transact-SQL
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Transact-SQL: A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
96 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,634 questions
asked 2024-09-30T19:03:37.35+00:00
Jonathan Brotto 400 Reputation points
accepted 2024-10-01T14:47:10.7333333+00:00
Jonathan Brotto 400 Reputation points
0 answers

Allocated vs. Used Memory in SQL Server Elastic Pool

Hello! I’m seeking help regarding the reduction of allocated space in databases within an SQL Server elastic pool. The allocated space in the elastic pool I'm using is significantly larger than the actual used space (due to recent deletions of deprecated…

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,759 questions
asked 2024-10-01T00:41:03.21+00:00
Sinara Medeiros 0 Reputation points
commented 2024-10-01T14:09:10.27+00:00
Sinara Medeiros 0 Reputation points
2 answers

sql server install not properly

TITLE: Microsoft SQL Server 2014 Setup The following error has occurred: SQL Server Setup has encountered an error when running a Windows Installer file. Windows Installer error message: An error occurred during the installation of assembly…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,759 questions
asked 2024-07-04T04:46:59.23+00:00
Ashutosh Olekar 0 Reputation points
answered 2024-10-01T13:46:26.4666667+00:00
_cypheX 0 Reputation points
1 answer

Error creating SQL user accounts from external provider with Azure Arc

When trying to create user accounts that use Azure login in Azure Arc, we receive the error shown in the user's image. How can we resolve this issue?

Azure Arc
Azure Arc
A Microsoft cloud service that enables deployment of Azure services across hybrid and multicloud environments.
409 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,759 questions
asked 2024-05-03T12:16:54.9066667+00:00
AJ Copeland 5 Reputation points
commented 2024-10-01T13:45:19.4833333+00:00
AJ Copeland 5 Reputation points
2 answers

Issue with excessive error messages in SQL Server Log during the reading of Server Audit session (.sqlaudit) files

Hello, I am encountering an issue with a high volume of error messages in the SQL Server Log while reading from an active Server Audit session. This problem occurs in SQL Server 2019 and later versions. I have set up database auditing using Server Audit…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,759 questions
asked 2024-09-23T08:23:47.0466667+00:00
Aleksandar Miljkovic (amiljkov) 0 Reputation points
commented 2024-10-01T13:45:08.17+00:00
Zahid Butt 956 Reputation points
0 answers

how can i rerun the sql script using DbUp with new modifications?

Hello I am new to using DbUp and when I run a script it runs successfully but when I add some modifications I get this message Beginning database upgrade Checking whether journal table exists.. Fetching list of already executed scripts. No new…

ASP.NET
ASP.NET
A set of technologies in the .NET Framework for building web applications and XML web services.
3,478 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,759 questions
asked 2024-10-01T11:48:28.9266667+00:00
Saleh Salem 0 Reputation points
edited the question 2024-10-01T12:11:49.93+00:00
Saleh Salem 0 Reputation points
2 answers One of the answers was accepted by the question author.

rdlc files donot compile or validate in VS 2022

I am trying to upgrade and compile a project in VS 2022 with some rdlc files, it does not show any errors when we try to build or rebuild. It was working on VS2013 before. It showed any compile errors in the files and does not complete the build until…

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.
2,917 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,894 questions
asked 2022-03-21T19:13:33.007+00:00
DeAdu 21 Reputation points
commented 2024-10-01T11:49:40.2566667+00:00
mBardos76 0 Reputation points
0 answers

Licensing for SQL Enterprise

Dear team, I need to inquire about the licensing of SQL Enterprise; As per Microsoft documentation, if we choose the "per core" licensing model, the required licenses would be based on the number of cores assigned to each server having SQL…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,759 questions
asked 2024-10-01T11:20:32.3566667+00:00
Micheal Mallo 290 Reputation points
commented 2024-10-01T11:36:14.41+00:00
Olaf Helper 44,421 Reputation points
0 answers

Could not connect Azure SQL connect through private link

We encountered an error in the application (dotnet 8.0 console running in AKS container) when trying to connect to a Azure SQL database hosted on a standalone Azure SQL server. Error message A network-related or instance-specific error occurred while…

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,759 questions
asked 2024-09-23T09:52:47.7+00:00
Michael Qiuxing Xu 21 Reputation points
commented 2024-10-01T11:03:45.6666667+00:00
Sai Raghunadh M 310 Reputation points Microsoft Vendor
1 answer

Retrieve an SQL standard license for in place upgrade

We are running a SQL virtual machine SQL server under a developer license that needs to be upgraded to a standard SQL license. The payment for the SQL license is done through Azure so no license keys in our control. Now with the upgrade through the…

SQL Server on Azure Virtual Machines
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,759 questions
asked 2023-10-26T06:57:14.84+00:00
bauke 5 Reputation points
commented 2024-10-01T10:18:07.59+00:00
Emanuel Virca 0 Reputation points
0 answers

Cannot connect to SQL Database. Please contact SQL server team for further support.

Hello support from time to time i get an error that username/password is invalid for database. However database is up and running and in use. below are the infromation activityid 701ef079-7056-4d6b-b941-c2e2f011e57a

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,759 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,656 questions
asked 2024-10-01T08:13:02.49+00:00
Ninoslav Zekic 10 Reputation points
commented 2024-10-01T10:03:23.9533333+00:00
Ninoslav Zekic 10 Reputation points