SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,107 questions
2 answers
One of the answers was accepted by the question author.
Creating a cluster with two nodes and a DR in Azure
Hi, I've read some blogs that in scenarios like this say that the recommendation is to change some timeout delay settings in the cluster to avoid false positives. Is there any configuration at the faiolver level or something else that I should worry…
3 answers
SQL Server Always On Listener IP for Async Nodes??
Hello Team, How can I connect to an Async node using the Listener IP or Listener DNS in an Always on architecture (SQL Server 2016)?? Node1 - Primary Node2 - Secondary (Sync) Node3 - Secondary (Async) Our API's connect to Node1 and Node2 using…
asked 2020-09-02T13:18:44.733+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(19.2, 2%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Ashif Shaikh
156
Reputation points
commented 2020-09-03T13:24:23.57+00:00
Shashank Singh
6,246
Reputation points
1 answer
Table replicate using SSIS
Hi, I'm trying to replicate few tables from a Source DB to destination DB. Both Databases are sql server databases. The only issue is that the source DB gets refreshed from production DB backup every night which breaks its replication to the…
asked 2020-08-31T06:54:58.88+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(144, 68%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Sherwin Rodrigues
1
Reputation point
commented 2020-09-03T09:56:49.397+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,896
Reputation points
4 answers
Fixing an Instance of SQL Server 2014 - After Cleanning up some duplicte files.
Hi Folks, This is my first time using this forum. I regularly use the C# Forum. The question is: I recently used the CCleaner to sweep out some duplicate files in my notebook, and of course there was a lot of them of all kinds, included SQL Server, and…
asked 2020-08-27T01:55:39.787+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(118.4, 14.000000000000002%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFV%3C/text%3E%3C/svg%3E)
Flávio Rocha
21
Reputation points
commented 2020-09-03T07:21:27.4+00:00
m
4,271
Reputation points
2 answers
What is the impact of setting ASPaaS\AlwaysUseGateway to false
HI all everybody, this is my first post and I'm here to ask for your help. This is the scenario on my Team: Client - Visual Studio 2019 connecting to AAS deploy using a server of IaaS as data source - issue And they sent me this image…
asked 2020-08-28T02:09:22.31+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(121.6, 17%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
CuervoXok
1
Reputation point
commented 2020-09-03T04:19:21.907+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, 9%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
HarithaMaddi-MSFT
10,136
Reputation points
6 answers
Query slow on SQL 2019
There is one specific query that has been executed on MS SQL 2014 for long time. The query is running on AG secondary RO replica. The query execution time on MSSQL 2014 is about 5 seconds. After migration to MSSQL 2019 the same query is running about 5…
asked 2020-09-01T09:37:21.583+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(153.6, 35%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVS%3C/text%3E%3C/svg%3E)
Vadim Sudenko
1
Reputation point
answered 2020-09-03T01:27:57.267+00:00
m
4,271
Reputation points
5 answers
Configure DB alert
Hello, I am configuring alert for Prodcution databases. I want to get any error message appearing in SQL Server Error log. But while defining the alert it is showing 2 options Error No Severity Pls suggest
![](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, 7.000000000000001%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
4 answers
Create user to access Alwayson readonly databaes
Hi Our env sql server version is 2016 SP2 EE edition always on enabled. So when we create database user for access the report though link server(expected to connect readonly replica databases ) from other remote node then I I noted permission(DB…
asked 2020-08-25T00:38:01.14+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(208, 42%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Ashwan
521
Reputation points
answered 2020-09-02T22:14:06.857+00:00
Edwin M Sarmiento
256
Reputation points
3 answers
How does one migrate system databases from an old SQL Server 2012 to a new SQL Server 2017?
How does one migrate system databases from an old SQL Server 2012 to a new SQL Server 2017?
2 answers
SQL Server 2019 Retreive Data very slow
I have issue in retrieve the Data from Table it is taking at least 1 hr for showing normal Select top 100 * from Table_Name. In my table forty million one hundred twenty-three thousand one hundred six Rows(40123106) and Daily two million seven hundred…
asked 2020-08-29T10:57:12.6+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(188.79999999999998, 9%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPC%3C/text%3E%3C/svg%3E)
Prashant Chavan
1
Reputation point
answered 2020-09-02T20:24:35.117+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(83.2, 40%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENC%3C/text%3E%3C/svg%3E)
Norm C
6
Reputation points
9 answers
SQL Server IO size
When sql server choose the I/O size for a single read/write (Data file random IO)? 8KB 64KB or even larger
3 answers
TDE for SQL on Azure VM
I have 3 nodes of AAG replica , 2 on EastAsia and 1 on Southeast asia. and there are also 2 Azure Key vault , one in East Asia and One in South east asia . So I would like to know if there are option to sync the TDE key between two Key vaults, …
asked 2020-08-22T10:10:21.733+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(137.6, 40%, 23%)' 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)
sakuraime
2,321
Reputation points
commented 2020-09-02T18:28:00.077+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(118.4, 98%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
KarishmaTiwari-MSFT
18,657
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Need to change the AG Listner name on my Always On configuration during cut-over
I am migrating from an HA-Cluster to an Always on AG- Solutioning as the DR currently configured is DB mirroring that is deprecated and figuring with my vendor if the app is solution's to an AG move. From DB end i am planning to set dedicated new…
asked 2020-08-25T13:29:56.553+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(67.2, 83%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEE%3C/text%3E%3C/svg%3E)
Eben Earnest
41
Reputation points
commented 2020-09-02T17:59:21.793+00:00
Eben Earnest
41
Reputation points
4 answers
One of the answers was accepted by the question author.
Login failed SSRS Domain\Machinename$
Hi! I have a 4-server Reporting Services 2019 farm, connected to a separate database server. The reporting services starts with a domain user and the reporting was properly configured. Currently the service works without problems and the reports are…
asked 2020-09-01T17:47:43.113+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, 73%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPP%3C/text%3E%3C/svg%3E)
Pablo Porras
21
Reputation points
commented 2020-09-02T16:48:29.027+00:00
Pablo Porras
21
Reputation points
3 answers
One of the answers was accepted by the question author.
EXEC sp_updatestats.
Hi everyone! Why is the date not updated after executing the command 'EXEC sp_updatestats;' on the database? All help is welcome!
1 answer
How to get data from a Web Service that has HTTPS, SOAP and WSDL with an SSIS Project
I need to get data from a Web Service that has HTTPS, SOAP and WSDL configuration. Tried following this tutorial https://www.mssqltips.com/sqlservertip/3272/example-using-web-services-with-sql-server-integration-services/ , but stopped on the…
asked 2020-08-28T14:58:55.027+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(208, 68%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGB%3C/text%3E%3C/svg%3E)
Gustavo Branco Goncalves
1
Reputation point
commented 2020-09-02T09:51:05.557+00:00
Monalv-MSFT
5,896
Reputation points
1 answer
One of the answers was accepted by the question author.
Can't schedule an exam (link goes into a loop) 70-764
Hey , As soon as I want to schedule an exam (https://learn.microsoft.com/de-de/learn/certifications/exams/70-764), the following page got into a loop (reloaded every time, nothing happens.) I only see a white window. I am logged in with my MS account!…
![](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(105.60000000000001, 8%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EE%3C/text%3E%3C/svg%3E)
2 answers
What's wrong with my AlwaysOn?
Hi, I'm setting up an Always On following the whole procedure I found in other laboratories and I notice that mine happens differently. The database goes online only after I run it (Join to Availability Group ...) What can be wrong? I…
asked 2020-09-01T05:32:30.477+00:00
Salves
501
Reputation points
commented 2020-09-02T09:37:12.783+00:00
Shashank Singh
6,246
Reputation points
3 answers
Page flag and Page flag description for sys.dm_db_page_info
anyone know the details about the following column ?
asked 2020-08-24T09:55:15.97+00:00
sakuraime
2,321
Reputation points
answered 2020-09-02T08:58:37.93+00:00
CathyJi-MSFT
21,111
Reputation points Microsoft Vendor
2 answers
One of the answers was accepted by the question author.
Advice to select the best employee business key
Hi, I'd like to get your opinion/advices to select the best employee business key in our system. I work on a multi-country, multi-company data warehouse project. You may find different HR systems all around the world, so I have to choose the appropriate…
asked 2020-08-31T15:22:08.553+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(281.6, 24%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFG%3C/text%3E%3C/svg%3E)
Franck GUSTIN
21
Reputation points
commented 2020-09-02T08:28:58.67+00:00
Franck GUSTIN
21
Reputation points