18,302 questions with SQL Server-related tags

Sort by: Updated
Updated Created Answers
2 answers One of the answers was accepted by the question author.

Data Source (SSAS database) into SSAS Tabular project

Hello, I am trying to make an aggregated table in my tabular project where the source of this table will also be a table of a tabular model. In summary, what I did was as follows: I created a MS Analysis Services database Data Source with a DAX query…

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,254 questions
asked 2020-08-31T17:18:17.697+00:00
Nayron Araújo 96 Reputation points
accepted 2020-09-09T14:31:41.147+00:00
Nayron Araújo 96 Reputation points
2 answers

VCWare Snapshot - WFCS and AG

I am hoping someone can provide some insight into this subject I have been working with SQL Server for several years, but have not had the pleasure of working much with the Windows Failover Cluster Service and Availability Groups. In my new role I am…

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,031 questions
Windows Server Clustering
Windows Server Clustering
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.Clustering: The grouping of multiple servers in a way that allows them to appear to be a single unit to client computers on a network. Clustering is a means of increasing network capacity, providing live backup in case one of the servers fails, and improving data security.
968 questions
asked 2020-09-08T15:19:22.747+00:00
Jeffrey Ayoub 1 Reputation point
answered 2020-09-09T13:48:20.23+00:00
Shashank Singh 6,246 Reputation points
1 answer

Create a stored procedure that checks a status, validates, then update status?

I have the following "Handshake" table: CREATE TABLE [dbo].[Handshake]( [Report Year] [varchar](100) NULL, [Status] [varchar](100) NULL, [Update Time] [datetime] NULL, [Process Time] [datetime] NULL ) ON [PRIMARY] …

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,031 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,575 questions
asked 2020-09-08T19:20:56.803+00:00
cataster 1 Reputation point
commented 2020-09-09T09:26:41.43+00:00
EchoLiu-MSFT 14,576 Reputation points
0 answers

PerfLib 2.0 counter removal failed with exit code 2, when installing MSSQL 2019

I fail to install MS SQL Server 2019, develeoper license. I've tried basic, customized, downloaded media, run as admin, standing on my head. But everything ends with "PerfLib 2.0 counter removal failed with exit code 2". I found a bunch of…

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,031 questions
asked 2020-09-07T08:38:48.977+00:00
Mats Sarapik 1 Reputation point
commented 2020-09-09T09:00:40.847+00:00
CathyJi-MSFT 21,106 Reputation points Microsoft Vendor
1 answer

Subscribe status showing Expire soon/Expired in transactinal replication

I am using SQL Serve Enterprise Edition (64-bit) and in this i am using transactional-replication with on Publisher , one Replication Distribution Agent with four Subscriber. everything was going smoothly but now when i am seeing my replication in 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,031 questions
asked 2020-09-08T05:07:23.717+00:00
Ashutosh Mishra 1 Reputation point
commented 2020-09-09T08:59:19.897+00:00
CathyJi-MSFT 21,106 Reputation points Microsoft Vendor
2 answers

TempDB does not release space after restart

Hi Team, In one of our Production Environment we had a tempdb growth due to bulk transaction and occupied the drive space , we were not able to shrink the datafile and release space , there were no active transactions on tempdb , we tried…

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,031 questions
asked 2020-09-07T16:24:27.42+00:00
Anashwar N 41 Reputation points
commented 2020-09-09T08:57:20.653+00:00
CathyJi-MSFT 21,106 Reputation points Microsoft Vendor
1 answer

SSRS 2014 SMTP settings

My server has been emailing reports from SQL fine but changes to O365 seem to have caused it to stop accepting mail without authentication via username and password. SSRS 2014 does not have settings for this in the Configuration Manager and the…

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,848 questions
asked 2020-09-07T15:22:19.473+00:00
Calum Morrison 116 Reputation points
commented 2020-09-09T08:42:55.997+00:00
ZoeHui-MSFT 34,351 Reputation points
4 answers

how to get values from multiple tables and then perform calculations

i have three tables named Users,Packages,UserPackage this is my users table this is my userpackage table this is my packages table U_ID is foreign key from Users table in userspackage table and P_ID is foreign key from Packages…

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,031 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,575 questions
asked 2020-09-02T13:06:01.447+00:00
Shahzaib khan 6 Reputation points
commented 2020-09-09T07:29:12.753+00:00
EchoLiu-MSFT 14,576 Reputation points
3 answers

How to write update statement to table statusvalues where chemical id have more than one chemical status ?

How to write update statement to table statusvalues where chemical id have more than one chemical status ? I work on SQL server 2012 I face issue ; I can't update status on table statusvalues where chemical id have more than one status as example …

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,031 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,575 questions
asked 2020-09-03T00:53:41.997+00:00
ahmed salah 3,216 Reputation points
commented 2020-09-09T07:27:12.533+00:00
MelissaMa-MSFT 24,176 Reputation points
1 answer One of the answers was accepted by the question author.

How to update status to match Characters Based on position of letter charachter before and after stars?

I work with SQL Server 2012 and I have an issue: I can't update status to match characters where signature key have stars *. I need to update status to match characters where signature key have starts as example Signature Key Group Id Portion Key Status …

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,031 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,575 questions
asked 2020-09-09T00:49:55.647+00:00
ahmed salah 3,216 Reputation points
accepted 2020-09-09T06:37:30.697+00:00
ahmed salah 3,216 Reputation points
2 answers

CDC_Capture Job Failure

Hi Guys, We enabled CDC on SQL server 2016; and observed CDC job fails intermittently; what happen CDC capture job is in fail state for more than 2 days; when we restart job, does it catch all the delete/update/insert records? We observe our down…

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,031 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,575 questions
asked 2020-09-04T02:44:54.557+00:00
Dondapati, Navin 281 Reputation points
commented 2020-09-09T05:47:07.907+00:00
Cris Zhan-MSFT 6,611 Reputation points
7 answers

How to Remove additional speces after add Replace function

Hi Team, Currently i have faced issue as a after add replace function to SQL column to remove comma, then output parsing as a addotional spaces on the SQL column data feilds, According to i have used below trim method but its not worked, Could you…

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,031 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,575 questions
asked 2020-09-02T17:51:44.293+00:00
Mahesh Madhusanka 176 Reputation points
answered 2020-09-09T04:07:50.263+00:00
EchoLiu-MSFT 14,576 Reputation points
4 answers One of the answers was accepted by the question author.

SQL Server logon failure occurs frequently (Error: 17189, Severity: 16, State: 1.)

SQL Server logon failure occurs frequently (Error: 17189, Severity: 16, State: 1.) Hi, [Environment] Microsoft Windows Server 2012 R2 Standard The maximum server memory of SQL Server for the DB server is set to 4096(MB). ---systeminfo--- …

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,031 questions
asked 2020-09-01T03:32:46.237+00:00
悠 高島 81 Reputation points
answered 2020-09-09T03:48:14.013+00:00
悠 高島 81 Reputation points
2 answers One of the answers was accepted by the question author.

How to update status to not match charachter in case of signature key not have stars * ?

I work on SQL server 2012 I face issue I need when signature key group id have starts only then not compare value with portion key as line or row 3 and 4 meaning if signature key group id have stars only then not update status to not match…

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,031 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,575 questions
asked 2020-09-08T02:35:09.487+00:00
ahmed salah 3,216 Reputation points
commented 2020-09-09T01:06:36.873+00:00
m 4,271 Reputation points
2 answers One of the answers was accepted by the question author.

using EXEC on SQL statements

qryS Select avg(len(Question)) FROM dbo.Student_Question Select avg(len(Answer)) FROM dbo.Student_Question Select avg(len(Learner_Id)) FROM dbo.Student_Question I’ve got a table with the following column (it also has other columns). I…

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,031 questions
asked 2020-09-08T21:17:27.797+00:00
RoyB09 306 Reputation points
answered 2020-09-08T22:35:05.783+00:00
RoyB09 306 Reputation points
3 answers

Synchronous AG nodes in different Availability Zones

Is anyone running a Primary AG node and synchronous AG secondary in the same region but a different availability zone? I would think this would be good practice to hardening against data center failures but an concerned about commit latency associated…

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,031 questions
asked 2020-09-04T12:58:06.103+00:00
kevin eckart 26 Reputation points
commented 2020-09-08T19:09:41.3+00:00
kevin eckart 26 Reputation points
3 answers

Finding a program similar to Crystal Reports (used by VB6)

Hi! Not really sure about all the functionality Crystal Reports brought to the table, but it seems that it was in heavy use during the 90's - I do not know that status of this tool today. I am taking over an old VB6-application using Crystal Reports,…

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,848 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,480 questions
asked 2020-09-02T09:13:46.087+00:00
Inkimar 1 Reputation point
answered 2020-09-08T17:55:53.56+00:00
Tom Phillips 17,716 Reputation points
1 answer One of the answers was accepted by the question author.

Is it possible to have a link in SharePoint online to a dynamic report from an on-site SQL database?

I am seeking to use an existing SQL report to interrogate an on-site database but this be done from a SharePoint online interface, is this possible? If so, what is the architecture required to achieve this within the O365 tenant security bubble? TIA, …

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,848 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,985 questions
asked 2020-09-07T16:23:18.033+00:00
Duncan Fisher 21 Reputation points
accepted 2020-09-08T10:15:36.86+00:00
Duncan Fisher 21 Reputation points
2 answers

SSAS DB Synch job hanged - Profiler shows 'Lock Acquired' but no 'Lock released' -where is the problem?

SSAS DB synchronization job (using xmla via ssis) usually takes 30 minutes to complete, but is getting hanged for indefinite time until I terminate it forcefully. Even I terminate it, it do not release physical memory and also can not restart a manual…

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,254 questions
asked 2020-09-05T01:00:51.673+00:00
Komal Sahu 311 Reputation points
commented 2020-09-08T08:44:23.127+00:00
Lukas Yu -MSFT 5,816 Reputation points
2 answers One of the answers was accepted by the question author.

SQL Server on Linux: Change file location of system databases model and msdb

I am trying to use SQL Server on Linux. This works pretty well. But I want to change the data location. I followed this tutorial: https://learn.microsoft.com/en-us/sql/linux/sql-server-linux-configure-mssql-conf?view=sql-server-ver15#datadir. Now my data…

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,031 questions
asked 2020-09-08T06:50:05.967+00:00
Ruedi Gloor 101 Reputation points
commented 2020-09-08T08:03:47.327+00:00
tibor_karaszi@hotmail.com 4,306 Reputation points