SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,690 questions
2 answers
identify if heaps are being used by applications
any table with atleast one index can be queried for index stats usage to identify if the table is being actively used or not how to identify if heaps are being actively used by applications or not we have thousands of heaps and most of them are just…
asked 2021-03-16T14:14:48.45+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(172.8, 99%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN%3C/text%3E%3C/svg%3E)
NeophyteSQL
241
Reputation points
commented 2021-03-22T01:32:33.193+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, 46%, 20%)' 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)
AmeliaGu-MSFT
13,961
Reputation points Microsoft Vendor
1 answer
Replication without SQL Agent
Hi. The site I am working at uses SQL2016 Std Ed and does not enable the SQL Agent. Scheduled tasks such as backups etc are run centrally from a 3rd party app. I would like to set up transactional replication. Most of the SQL Agent jobs that are…
asked 2021-03-15T12:21:12.497+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(214.4, 96%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH2%3C/text%3E%3C/svg%3E)
HarryNangle-2823
1
Reputation point
commented 2021-03-22T01:29:42.063+00:00
AmeliaGu-MSFT
13,961
Reputation points Microsoft Vendor
1 answer
sqlcmd: Microsoft ODBC Driver 17 for SQL Server Paging error
We receive this error periodically when trying to run queries via automation using sqlcmd. The paging file is system managed, we have updated driver to latest version but still get this and memory allocation issues if any activity us taking place on the…
asked 2021-03-15T11:35:46.29+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(169.60000000000002, 72%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAH%3C/text%3E%3C/svg%3E)
Amy Harrison
1
Reputation point
commented 2021-03-22T01:25:59.3+00:00
CarrinWu-MSFT
6,851
Reputation points
3 answers
Facing com.microsoft.sqlserver.jdbc.SQLServerException: Read timed out
I have following details - DB server - Windows Server 2016 Datacenter SQL Server version - Microsoft SQL Server 2016 (SP1) (KB3182545) - 13.0.4001.0 (X64)
asked 2021-03-18T14:31:36.72+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(96, 84%, 19%)' 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)
Sagar Mali
1
Reputation point
commented 2021-03-22T01:22:29.487+00:00
CarrinWu-MSFT
6,851
Reputation points
3 answers
Error SQL Mirroring configuration "The server network address "TCP://xxxx:5022" can not be reached or does not exist"
Hello All, I faced an issue while trying to configure SQL mirroring. Here is the message error: ==================================== The server network address "TCP://xxxx:5022" can not be reached or does not exist. Check the network address…
asked 2021-03-18T06:52:14.27+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(182.40000000000003, 28.000000000000004%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPB%3C/text%3E%3C/svg%3E)
Piseth Ben
1
Reputation point
commented 2021-03-22T01:13:40.853+00:00
CarrinWu-MSFT
6,851
Reputation points
2 answers
One of the answers was accepted by the question author.
SQL Server 2017 Core Licencing
We have a SQL Server 2017 Enterprise Core edition with no SA in virtualized environment. This VM has been assigned 8 vCPU. This VM is hosted on three physical servers in failover cluster. I would like to know from licensing expert if we are covered with…
![](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(134.4, 85%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
2 answers
One of the answers was accepted by the question author.
My Sqlite inset, but whe I read it there is none
public class Contact : ViewModelBase { [PrimaryKey, AutoIncrement] public int Id { get; set; } private string _Name; public string Name { get { return _Name; } set { if (_Name != value) { …
asked 2021-03-16T18:07:38.497+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(76.8, 5%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEG%3C/text%3E%3C/svg%3E)
Eduardo Gomez
3,416
Reputation points
accepted 2021-03-21T22:00:56.677+00:00
Eduardo Gomez
3,416
Reputation points
1 answer
SSAS optimal settings for processing and querying with OLAP site
I have a cube server with 16 virtual core and 64 gb memory . the average usage of memory is around 45% and CPU usage is about 60% max. We have almost 10 cubes on this server. We are observing whenever we process a cube(any client) the web application…
asked 2021-03-19T19:06:34.857+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, 12%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVK%3C/text%3E%3C/svg%3E)
Vinay kumar
1
Reputation point
answered 2021-03-21T21:59:20.47+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(54.400000000000006, 85%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDG%3C/text%3E%3C/svg%3E)
Darren Gosbell
1,466
Reputation points
1 answer
MSSQL 2019 A connection was successfully established with the server
I use Microsoft SQL Server 2019 (RTM-CU7) (KB4570012) - 15.0.4063.15 (X64) Aug 15 2020 10:48:11 Copyright (C) 2019 Microsoft Corporation Developer Edition (64-bit) on Linux (Ubuntu 18.04.5 LTS) I develop with .net core 3.1.8 web api using Kestrel : …
asked 2020-09-17T20:36:50.103+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(115.19999999999999, 16%, 21%)' 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)
seloBaba
6
Reputation points
commented 2021-03-21T19:24:03.623+00:00
Erland Sommarskog
100.9K
Reputation points MVP
2 answers
One of the answers was accepted by the question author.
SQL Stored Procedure?
Hello all: I am working on a project and need to create 100000000 records and they have a small data footprint, just 4 columns, 3 uniqueidentifiers, 1 int. 2 of the identifiers need to be read from other tables, and then used in the other table. So…
asked 2021-03-20T12:30:35.643+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(259.20000000000005, 65%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJS%3C/text%3E%3C/svg%3E)
John Straumann
21
Reputation points
accepted 2021-03-21T12:56:48.477+00:00
John Straumann
21
Reputation points
3 answers
Object ID in query_store_query DMV doesn't exist? Where'd it go?
I'm querying the query store DMVs directly but the object_id in the query_store_query DMV is returning a value that can't be found. It isn't 0 so why does it return a value that doesn't seem to exist? Could this be due to the fact some queries are coming…
asked 2021-03-19T18:09:55.577+00:00
Michael MacGregor
86
Reputation points
answered 2021-03-20T10:13:25.547+00:00
Erland Sommarskog
100.9K
Reputation points MVP
1 answer
Connection problem using SqlClient on a MS SQL Always ON environment using availability groups
So we wrote a service for a client using vb.net and the SqlClient namespace. The ConnectionString is built once, then for each sequent run - the service is called by a System.Timer.Timer once every 2 seconds. On such a run via conn.Open() the 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.
12,690 questions
VB
VB
An object-oriented programming language developed by Microsoft that is implemented on the .NET Framework. Previously known as Visual Basic .NET.
2,568 questions
asked 2021-03-19T14:04:37.643+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(124.80000000000001, 67%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESL%3C/text%3E%3C/svg%3E)
Sven Leuschner
1
Reputation point
answered 2021-03-19T23:06:34.537+00:00
Erland Sommarskog
100.9K
Reputation points MVP
2 answers
One of the answers was accepted by the question author.
nth Occurence Join
I am very stuck with this. I have two tables: Table 1: Patients and CPT values that all say SURG PATNOCPT58903SURG58903SURGTable 2: Has same patients but with actual codes I need to match with Table 1. PATNOCPT5890329882589036447 The issue:…
asked 2021-03-19T18:35:20.417+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(214.4, 33%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAH%3C/text%3E%3C/svg%3E)
Amery, Hisham
81
Reputation points
accepted 2021-03-19T19:12:51.257+00:00
Amery, Hisham
81
Reputation points
4 answers
One of the answers was accepted by the question author.
Inner Join using SQL SMS
Hi. Noob here trying to figure out SQL SMS queries. I'm trying to take a query that works in MS Access and use it in SQL Server Management Studio. I start getting syntax errors at the "inner join". If I just run the first select-from-where…
asked 2021-03-17T19:59:36.303+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(240, 83%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBB%3C/text%3E%3C/svg%3E)
Brian Bulla
21
Reputation points
accepted 2021-03-19T18:12:30.767+00:00
Brian Bulla
21
Reputation points
1 answer
One of the answers was accepted by the question author.
Polybase feature is not enabled
I tried to execute the following: EXEC sp_polybase_join_group but the following error occured: This stored procedure is not available because Polybase feature is not enabled
asked 2021-03-19T08:55:03.687+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, 32%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESA%3C/text%3E%3C/svg%3E)
Surendra Adhikari
21
Reputation points
commented 2021-03-19T11:01:22.32+00:00
Surendra Adhikari
21
Reputation points
1 answer
Visual Studio Publish - not able to connect to database
I have created a very simple Blazor application with a database connection. The application works fine, when executed locally. I have created a SQL Server database in Azure. I have added a firewall rule to make external access possible for my ip. When I…
asked 2021-03-15T11:02:07.73+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(252.8, 94%, 34%)' 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)
Hakan
51
Reputation points
commented 2021-03-19T09:42:33.757+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(294.40000000000003, 37%, 38%)' 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)
Monalv-MSFT
5,891
Reputation points
1 answer
How to quit SSIS without erroring
Hi, Just a wee question. I have a SSIS package which reads an excel sheet into the database from a folder. If there is no excel file there, how do I exit the SSIS package without failing the job? What would I point the red arrow to? and would…
asked 2021-03-12T08:42:56.877+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(185.6, 74%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECJ%3C/text%3E%3C/svg%3E)
Christopher Jack
1,611
Reputation points
commented 2021-03-19T09:40:44.88+00:00
Monalv-MSFT
5,891
Reputation points
2 answers
integration service catalog node not visible ssms
i am using sql server 2008 r2 and intergration severces is enabled but the node for integration services not showing in ssms
asked 2021-03-11T05:11:33.69+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, 57.00000000000001%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENN%3C/text%3E%3C/svg%3E)
Neeraja Nair
1
Reputation point
commented 2021-03-19T09:38:07.003+00:00
Monalv-MSFT
5,891
Reputation points
1 answer
Cannot aquire connection from connection manager
Hi, I am trying to follow an online instruction on to read in some excel files into a db . http://microsoft-ssis.blogspot.com/2011/02/how-to-configure-foreach-loop-file.html I have set everything up as per instruction however i am getting the…
asked 2021-03-10T21:59:18.923+00:00
Christopher Jack
1,611
Reputation points
commented 2021-03-19T09:37:25.713+00:00
Monalv-MSFT
5,891
Reputation points
1 answer
Latest Compatible versions of Visual studio, SSDT and Sql server
What are the latest versions of Visual Studio and SSDT that are compatible with latest versions of sql server and is working fine without any issues
asked 2021-03-10T18:22:29.313+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(310.4, 27%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPV%3C/text%3E%3C/svg%3E)
Prince V
1
Reputation point
commented 2021-03-19T09:36:36.15+00:00
Monalv-MSFT
5,891
Reputation points