18,484 questions with SQL Server-related tags

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

Delete command for Oracle table has warning : Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.

I have created an ssis package that processes data on sql server and loads results to an oracle table. I am using an execute sql task to delete existing records in the oracle table before reloading the table. The execute sql command has oracle…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,502 questions
asked 2020-08-24T22:55:22.4+00:00
Anonymous
accepted 2020-08-25T14:22:40.233+00:00
Anonymous
2 answers One of the answers was accepted by the question author.

not able to put is equal to sign (=) in query,

When i am inserting is equal sign= in query code sample then sign (=) in query is not showing in preview, what can be the issue

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,187 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,591 questions
asked 2020-08-22T09:21:16.07+00:00
Analyst_SQL 3,551 Reputation points
accepted 2020-08-25T12:22:24.91+00:00
Analyst_SQL 3,551 Reputation points
2 answers One of the answers was accepted by the question author.

Max degree of parallelism (MAXDOP) on SQL Failovered clustered instances.

We have 4 node SQL cluster. Each node has 4 physical processors with 18 cores each, 36 logical processors each. Cluster is running 23 instances, we are going to set "Cost Threshold of Parallelism" = some higher value (50). Currently this is set…

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,187 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.
971 questions
asked 2020-08-24T18:46:22.347+00:00
Vijay Kumar 161 Reputation points
accepted 2020-08-25T09:57:50.83+00:00
Vijay Kumar 161 Reputation points
1 answer One of the answers was accepted by the question author.

Problems with calculation groups in Power BI connected to SSAS (tabular)

Hi guys,   I'm trying to use calculation groups in Power BI that is connected to SSAS (tabular) but I'm having a few problems.   First problem is processing the calculation group, I'm adding the items in Tabular Editor & VS19 and processing…

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,258 questions
asked 2020-08-24T05:02:52.42+00:00
Cameron Wallace 31 Reputation points
accepted 2020-08-25T09:29:59.783+00:00
Cameron Wallace 31 Reputation points
4 answers

SQl server 2008R2 Performance issue after SP3 update

Hello, We have recently applied SP3 KB2979597 and Security Update Patch KB4057113 on Sql server 2008R2 but after that our couple stored procedures runs slow, it's taking almost 4 to 5 hours, but normally it was running under 5 minutes. Any one has…

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,187 questions
asked 2020-08-19T16:39:31.49+00:00
pdsqsql 411 Reputation points
commented 2020-08-25T09:16:52.92+00:00
CathyJi-MSFT 21,116 Reputation points Microsoft Vendor
1 answer

SSRS 2016 allows the display of sensitive parameter in its URL such as Session state token

SSRS 2016 allows the display of sensitive parameter in its URL, such as Session state token. This can be used to manipulate the data being displayed allowing other resources information be visible to other users.

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,854 questions
asked 2020-08-20T09:17:11.547+00:00
Ismael González Briongos 1 Reputation point
commented 2020-08-25T08:58:36.64+00:00
ZoeHui-MSFT 34,836 Reputation points
1 answer

Vulnerable and outdated Jquery and bootstrap version (Integrity)

SSRS 2016 uses vulnerable Jquery 3.3.1 and Bootstrap 3.3.5. A security assessment found that an attacker may use the vulnerable JavaScript framework version to perform malicious attacks. Assessment suggestion for remediation is patching or update to…

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,854 questions
asked 2020-08-20T07:38:43.74+00:00
Ismael González Briongos 1 Reputation point
commented 2020-08-25T08:58:17.857+00:00
ZoeHui-MSFT 34,836 Reputation points
1 answer

Help creating a Report that Combines output of 2 tables and a Query

I'm not sure if this is even possible but wondering if anyone has any advice to help see if? Current doing this in Report Builder 3 I'm hoping to have a report out put something kinda like the below The goal is based on two other tables and…

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,854 questions
asked 2020-08-18T05:02:27.477+00:00
Joshua Reynolds 1 Reputation point
commented 2020-08-25T08:56:46.123+00:00
ZoeHui-MSFT 34,836 Reputation points
1 answer One of the answers was accepted by the question author.

SQL job (email) alert to warn of disk getting full

I am trying to create an alert from SQL server to send me an email when the log or data files for a database are almost about to fill up the disk they reside on. Is anyone able to help with this?

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,187 questions
asked 2020-08-24T04:24:51.263+00:00
RayPaks 31 Reputation points
commented 2020-08-25T08:20:46.957+00:00
RayPaks 31 Reputation points
3 answers

Msg 156, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'CONVERT'.

I have this table that I'm trying to convert "2004-06-08 00:00:00.0000000" Datetime to just Date mm/dd/yyyy. Each row has a unique date. This is the code that I used below. This "Msg 156, Level 15, State 1, Line 3 Incorrect syntax near…

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,187 questions
asked 2020-08-20T19:57:17.57+00:00
Chris Slinko 1 Reputation point
commented 2020-08-25T07:41:00.803+00:00
CathyJi-MSFT 21,116 Reputation points Microsoft Vendor
4 answers

Performance Issues SSAS tabular Matrix drill downs

When i drill down in a powerbi report or when i run the extracted Dax query from dax studio i get massive performance hits for certain queries (takes 10-12 seconds). I have tested these queries using a clear cache query and also monitored the Server the…

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,258 questions
asked 2020-08-19T09:16:56.347+00:00
Datacrunk 1 Reputation point
commented 2020-08-25T07:01:08.87+00:00
Lukas Yu -MSFT 5,816 Reputation points
2 answers

Backup Report for all the Servers - Connectivity issue

Hi, We are collecting Backup Report report from all the servers using SSIS job and storing into Sql 2008R2 Server Database table. We have Full Backup nightly job which is running on the all servers and we are capturing these backup infor from all the…

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,187 questions
asked 2020-08-17T21:36:50.733+00:00
pdsqsql 411 Reputation points
commented 2020-08-24T20:13:26.943+00:00
pdsqsql 411 Reputation points
2 answers One of the answers was accepted by the question author.

sql permissions to run only update stats

hi all, we would like to give some business users with access to run only update stats. I am thinking of creating a role for these users and somehow assign them the rights to run "update stats" would you please share can I grant the users…

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,187 questions
asked 2020-08-24T19:36:09.74+00:00
NeophyteSQL 241 Reputation points
answered 2020-08-24T20:11:36.537+00:00
NeophyteSQL 241 Reputation points
3 answers

SCCM SUP SUSDB on sql express edition running out of disk space post every software update synch

We have setup a new SCCM secondary site which also hosts SUP SUSDB role configured on the SQL express edition which gets installed along with secondary. The problem is on monthly software update synch the SUSDB size crosses 10 GB limit & synch fails.…

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,187 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,510 questions
asked 2020-08-19T12:48:35.08+00:00
AKP 1 Reputation point
answered 2020-08-24T14:20:33.093+00:00
Adam J. Marshall 9,041 Reputation points MVP
2 answers One of the answers was accepted by the question author.

SSIS Sequence Containers

I have a SQL Server Integration Services package that has multiple sequence containers. If one sequence container fails, does the package stop? Is there a setting so that subsequent sequence containers will run even if one sequence container fails. …

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,502 questions
asked 2020-08-21T15:50:11.927+00:00
Michael Henderson 111 Reputation points
accepted 2020-08-24T14:01:18.757+00:00
Michael Henderson 111 Reputation points
3 answers

Why I am not able to restore TDE database?

Hello, I am running into an issue regarding restoring a TDE database and I just keep getting the "thumbprint not found error". I don't know what's causing it. Here are some details. I'm hoping someone can help me. I have many…

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,187 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,591 questions
asked 2020-08-23T13:02:23.62+00:00
sidney l 1 Reputation point
commented 2020-08-24T13:20:28.797+00:00
sydney 1 Reputation point
2 answers

Error: adding node server while configuring Always On FCI

While adding node in configuring Always On FCI, I am getting Error: The credentials you provided for the sql server agent service are invalid.

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,187 questions
asked 2020-08-18T13:48:08.25+00:00
AMRITANSHU AMRITANSHU 1 Reputation point
commented 2020-08-24T09:51:22.587+00:00
Cris Zhan-MSFT 6,611 Reputation points
5 answers

MASSIVE Identity column value jump in SQL Server 2014

So in the middle of basic coding and testing we saw a huge non-patterned jump in Identity values for multiple tables. We are unaware of any server blips or attempted bulk operations, but DBAs are looking into logs. The gaps are not the typical 1,000 or…

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,187 questions
asked 2020-08-18T15:54:17.713+00:00
Mike Brown 1 Reputation point
commented 2020-08-24T09:49:33.467+00:00
Cris Zhan-MSFT 6,611 Reputation points
3 answers

Unable to download SQL Server 2019 Developer edition

Hello! I've just installed Windows 10 64bit edition. Now I'm trying to install SQL Server 2019 Developer edition. I downloaded SQL2019-SSEI-Dev.exe from official site and launched it. I chose Basic installation, agreed with the agreements, chose the…

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,187 questions
asked 2020-08-18T14:26:56.15+00:00
Igor Baliuk 6 Reputation points
commented 2020-08-24T09:09:13.737+00:00
CathyJi-MSFT 21,116 Reputation points Microsoft Vendor
2 answers

SQL Server Whitelisting For Mcafee Solidcore

Does anyone know of any list of Microsoft SQL Server ( version 2014 and 2016 ) executables and its associated files and DLLs that needs to be whitelisted from Mcafee Solidcore for it to work properly. This is for a Microsoft SQL server that will be…

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,187 questions
asked 2020-08-19T08:22:16.17+00:00
Mark Rizalito Aliggayu 1 Reputation point
commented 2020-08-24T09:06:37.27+00:00
CathyJi-MSFT 21,116 Reputation points Microsoft Vendor