SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,751 questions
1 answer
One of the answers was accepted by the question author.
MS SQL Query taking 3 to 4 sec to return result
In our application the query execution taking 3565ms of avg. time, when same query is executed directly in DB it is taking only 205ms of avg. From the thread dump it is noticed that socketRead is taking 80% time of execution. …
SQL Server | Other
asked 2021-02-23T05:50:23.46+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(220.8, 46%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
Aswathy K J
96
Reputation points
accepted 2021-02-24T06:25:57.767+00:00
Aswathy K J
96
Reputation points
2 answers
SQL server installation error (Encryptet file)
I am trying SQL server 2017 but this program gives error Program Files has encrypted. I can't solve this problem. Please help me.![71123-sqlhata.png][1] [1]: /api/attachments/71123-sqlhata.png?platform=QnA
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,751 questions
asked 2021-02-23T11:37:16.527+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(227.2, 56.00000000000001%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAB%3C/text%3E%3C/svg%3E)
ali balun
1
Reputation point
answered 2021-02-24T03:20:08.957+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
14,016
Reputation points Microsoft External Staff
3 answers
SSIS package running fine from SSDT but not running from SQL Server 2019
Hello, SSIS package running fine from SSDT but not running from SQL Server 2019. I had tried all solution from internet but did not get any solution from it. Source and destination is oracle and SSIS package running from SQL Server 2019…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,797 questions
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,751 questions
asked 2021-01-28T05:50:40.75+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(176, 12%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKB%3C/text%3E%3C/svg%3E)
Kiritkumar Baraiya
1
Reputation point
answered 2021-02-24T02:53:57.74+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,926
Reputation points
2 answers
One of the answers was accepted by the question author.
SQL Server
Hello everyone! After training, how to get a certificate?
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,751 questions
asked 2021-02-16T11:25:27.873+00:00
Ganzera Alexandr
21
Reputation points
commented 2021-02-24T02:15:32.93+00:00
CathyJi-MSFT
22,431
Reputation points Microsoft External Staff
4 answers
best practise on statitics Update
If I would like to implement a manual update statistics , what are the criteria on choosing which table stats are required to be update and with with sampling rate ? is it a recommendation to use a threshold slightly less than the following as the…
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,751 questions
asked 2021-02-18T09:50:02.283+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,351
Reputation points
commented 2021-02-24T02:00:01.727+00:00
CarrinWu-MSFT
6,891
Reputation points
1 answer
One of the answers was accepted by the question author.
Columnstore Index and Analytical Queries
All, We are looking at using the Data Virtualization layer in SQLServer 2019 BDC to run Analytical Queries against Operational/LOB Systems (Claims Management database, Accounting database). Assuming that I create Non-Clustered Columnstore Index on…
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,751 questions
![](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, 51%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EG%3C/text%3E%3C/svg%3E)
5 answers
One of the answers was accepted by the question author.
How to write query generate unique Id for concate both columns search parts and company id ?
I work on sql server 2012 . I face issue I can't generate unique Id from merge or concave both columns Search Parts and Company ID and generated Id must be on column Generated ID to be easier and fast on search so Please How to generate unique Id from…
Developer technologies | Transact-SQL
Developer technologies | Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,717 questions
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,751 questions
asked 2021-02-22T16:47:51.637+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(262.40000000000003, 77%, 35%)' 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)
ahmed salah
3,216
Reputation points
accepted 2021-02-24T00:27:59.14+00:00
ahmed salah
3,216
Reputation points
1 answer
DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER
I have an SSIS package where Source: IBM DB2, Target: SQL Server. I have created a package in SSIS and able to run perfectly in my local machine. All connections work perfectly, data populates in the target tables. However, after deploying it to SQL…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,797 questions
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,751 questions
asked 2021-02-12T19:42:54.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(128, 8%, 22%)' 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)
Anonymous
commented 2021-02-23T22:18:47.33+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(278.4, 41%, 36%)' 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)
Bamford
1
Reputation point
3 answers
One of the answers was accepted by the question author.
Require expected output ,in row
Below is data ,i want to convert Bweight into Row as display in image. CREATE TABLE #item (ItemCode int,ItemName varchar(max)) CREATE TABLE #DistpatchM(DID int,E_Date date) CREATE TABLE #Distpatch_BD(ID int,DID int,Itemcode int,DisQTY…
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.
3,165 questions
Developer technologies | Transact-SQL
Developer technologies | Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,717 questions
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,751 questions
asked 2021-02-18T09:15:25.257+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(12.8, 75%, 11%)' 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)
Analyst_SQL
3,576
Reputation points
commented 2021-02-23T21:03:41.377+00:00
Viorel
127K
Reputation points
2 answers
ODBC Error Run-Time Error '-2147467259 (80004005)
Hello, I am hoping someone could provide me with some insight to as to what drive/install/dictate the following registry value. We have been having issue with a few users who were unable to open a custom excel spreadsheet an run a custom…
Microsoft 365 and Office | Excel | For business | Windows
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
20,687 questions
Windows for business | Windows Client for IT Pros | User experience | Other
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,751 questions
asked 2021-02-18T18:40:12.123+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(9.6, 19%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVD%3C/text%3E%3C/svg%3E)
Vinh Dang
1
Reputation point
commented 2021-02-23T17:48:27.947+00:00
Castorix31
91,881
Reputation points
2 answers
One of the answers was accepted by the question author.
MDX Cumulative Values over Time dimension, non hierarchy attribute
I've been struggling for 3 days on this problem. I will use AdventureWorks dimensions as an example (my cube has the same kind of setup). I don't use the [Calendar] hierarchy here, because I want to show only Year / Month so I use [Calendar Year] and…
SQL Server Analysis Services
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.
1,372 questions
asked 2021-02-18T19:08:28.717+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, 36%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWT%3C/text%3E%3C/svg%3E)
Wilhuff Tarkin
21
Reputation points
commented 2021-02-23T15:54:08.543+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(32, 95%, 13%)' 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)
Alexei Stoyanovsky
3,416
Reputation points
1 answer
One of the answers was accepted by the question author.
xamarin.forms encrypt sqlite db file
I'm new to this platform, and I hop is there any way to encrypt the SQLite database; I search on the internet but didn't found helpful results. I found this blog https://www.bricelam.net/2016/06/13/sqlite-encryption.html but I don't know how to…
Developer technologies | .NET | Xamarin
Developer technologies | .NET | Xamarin
A Microsoft framework for building cross-platform mobile apps using .NET and C# with native performance and user interfaces.
5,379 questions
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,751 questions
asked 2021-02-23T14:07:51.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(262.40000000000003, 90%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
drdmohssine
26
Reputation points
accepted 2021-02-23T15:07:22.493+00:00
drdmohssine
26
Reputation points
2 answers
One of the answers was accepted by the question author.
SSAS Dimension with encrypted column
I have a dimension table containing 3 Always Encrypted attributes. In the database they are defined as varchar(). Shown for example is the 'Account' attribute. The encrypted contents is a binary string. SSMS browsing decrypts and shows the data as…
SQL Server Analysis Services
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.
1,372 questions
![](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(89.60000000000001, 84%, 18%)' 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)
1 answer
One of the answers was accepted by the question author.
Ask how to change the heartbeat time after installing linux ha.
Hello I proceeded with the linux ha installation as shown in the link below. By the way, I would like to proceed with the test by adjusting the speed of linux ha. For example, you want to adjust the time that primary and secondary communicate…
Windows for business | Windows Server | Storage high availability | Clustering and high availability
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,751 questions
![](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(16, 5%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK%3C/text%3E%3C/svg%3E)
2 answers
One of the answers was accepted by the question author.
SSMS crash after one sql query window pull to another sql query window
SSMS crash after one sql query window drug to another sql query window steps to reproduce 1)Open Microsoft SQL Server Management Studio 18 2)Connect to DB 3)Open two sql query 4)drag second window on first window 5)Observe ssms crash…
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,751 questions
asked 2021-02-22T12:57:09.507+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(16, 55.00000000000001%, 11%)' 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)
Олег Петровский
21
Reputation points
accepted 2021-02-23T10:24:23.203+00:00
Олег Петровский
21
Reputation points
3 answers
Cannot connect to serevr Below SQL server 13.0 from ssms 18.8 in windows 10
TITLE: Connect to Server Cannot connect to .... ADDITIONAL INFORMATION: A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - An existing connection was…
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,751 questions
asked 2021-02-19T11:26:04.903+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(297.6, 38%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESP%3C/text%3E%3C/svg%3E)
Shiva Prasad reddy
1
Reputation point
commented 2021-02-23T08:58:13.28+00:00
CathyJi-MSFT
22,431
Reputation points Microsoft External Staff
2 answers
One of the answers was accepted by the question author.
SCOM Reporting Server Migration - AccessDeniedException
Hi! We've upgraded our SCOM environment to 2019 UR2 and are now migrating the SQL-databases from SQL2016 on W2016 to a new server with SQL2019 on W2019 We kept all the hostnames intact and followed the upgrade procedure except for the parts where we…
System Center Operations Manager
System Center Operations Manager
A family of System Center products that provide infrastructure monitoring, help ensure the predictable performance and availability of vital applications, and offer comprehensive monitoring for datacenters and cloud, both private and public.
1,638 questions
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.
3,165 questions
![](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(297.6, 43%, 38%)' 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)
1 answer
Call DB2 Store procedure in SSRS with dynamic parameters
Am using SSRS report builder and connecting with DB2 data base using ODBC. Am able to execute DB 2 SP with static parameters successfully, but in my scenario i need to pass the parameters dynamically (change parameter value while executing the SP). …
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.
3,165 questions
asked 2021-02-23T05:29:20.777+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(134.4, 49%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHR%3C/text%3E%3C/svg%3E)
Hiran R
1
Reputation point
answered 2021-02-23T07:49:47.547+00:00
Joyzhao-MSFT
15,651
Reputation points
2 answers
File system task error ; Access to the path " " is denied when copy file using file system task
Hi, I am using file system task to copy files from one folder to another folder. When i tried to copy fileA from folderA to folderB, an access denied to path error will pop up when folderB has fileA. I tried deleting fileA in folderB and run my…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,797 questions
![](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(80, 71%, 17%)' 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
One of the answers was accepted by the question author.
SQL Server DB Backup - Backup Compression and Timing
Hi All, We are using PeopleSoft Application (HRMS and FSCM) and it's running on SQL Server 2014 Enterprise Edition. Here the FSCM DB Size is 440GB and HRMS DB Size is 395 GB. We are taking daily DB Backup's for both HRMS and FSCM Database and…
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,751 questions
asked 2021-02-18T18:38:04.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(140.8, 14.000000000000002%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
Dhanasekaran
26
Reputation points
commented 2021-02-23T07:20:09.79+00:00
CathyJi-MSFT
22,431
Reputation points Microsoft External Staff