18,667 questions with SQL Server-related tags

Sort by: Updated
Updated Created Answers
2 answers

Hide dynamically a tablix in SSRS

Hi, I have a SSRS report with 2 tables. There are kind of the same except one has summary data and the other one has details. I am trying to display one table at a time. Basically, when we launch the report, we should only see the summary table. …

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,873 questions
asked 2020-09-03T18:37:50.84+00:00
Bola Razaki 1 Reputation point
answered 2020-09-07T02:47:51.257+00:00
Joyzhao-MSFT 15,571 Reputation points
8 answers

CXPACKET bottleneck.

Hi everyone! Are there any recommendations or good configuration practices for the treatment of the CXPACKET bottleneck? All help is welcome!

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,342 questions
asked 2020-09-02T01:33:34.4+00:00
Doria 1,246 Reputation points
commented 2020-09-07T02:33:57.77+00:00
SQLZealots 276 Reputation points
3 answers

New server cube processing timing out because the query wont run parallelism, what do i do?

So I am testing upgrading from 2017 to 2019 and one of the cubes keeps timing out after 1 hour. I have tried changing any timeout options on SSAS from 60 to 180, yet it still fails. The query plan on the previous server uses parallelism yet the new…

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,342 questions
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,262 questions
asked 2020-09-03T18:47:24.843+00:00
jonjoseph@gmail.com 1 Reputation point
answered 2020-09-07T01:51:05.59+00:00
m 4,271 Reputation points
3 answers

manual create statistics that can improve performance

are there any example that manual create statistics that can improve performance ?

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,342 questions
asked 2020-08-31T19:11:38.92+00:00
sakuraime 2,321 Reputation points
commented 2020-09-07T01:15:42.44+00:00
Cris Zhan-MSFT 6,611 Reputation points
3 answers

Scalar UDF Inlining

https://learn.microsoft.com/en-us/sql/relational-databases/user-defined-functions/scalar-udf-inlining?view=sql-server-ver15 what does the follow statement means ? Interpreted execution: Each statement itself is compiled, and the compiled plan is…

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,342 questions
asked 2020-09-03T07:08:00.657+00:00
sakuraime 2,321 Reputation points
commented 2020-09-06T16:38:17.167+00:00
sakuraime 2,321 Reputation points
4 answers

Parameter sniffing

May I know if Parameter sniffing will only happen on Store procedure (with parameter) and also prepared sql ?? will parameter sniffing happens on adhoc 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,342 questions
asked 2020-09-03T03:35:49.667+00:00
sakuraime 2,321 Reputation points
commented 2020-09-06T14:38:49.123+00:00
tibor_karaszi@hotmail.com 4,306 Reputation points
2 answers One of the answers was accepted by the question author.

SSIS CSV Loading issue

I am looking for a C# solution to use a script task in SSIS so that I can load multiple csv files to SQL Tables Now If I use a data flow task, then I have to create 1 DFT per file as each file has a different metadata ( unless there is some other…

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,342 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,523 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,599 questions
asked 2020-09-05T03:25:01.87+00:00
John K 186 Reputation points
answered 2020-09-06T12:07:05.793+00:00
COZYROC 101 Reputation points
9 answers

Uninstall SQL drivers

Hello, On my laptop in ODBC console I see 3 SQL drivers installed: The only driver that I need is SQL Server Native Client 11.0. I have to un-install 2 other drivers. In 'Un-install' feature I see the following: My question:…

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,342 questions
asked 2020-08-22T04:30:41.507+00:00
Susja 716 Reputation points
commented 2020-09-05T14:01:55.823+00:00
Dan Guzman 9,226 Reputation points
1 answer One of the answers was accepted by the question author.

Availability Replica - Server with question status and Role Unknown

Hi, after executing the manual faiolver procedure that was configured as asynchronous, we return to the initial scenario. We return with the bases paused, wait for the synchronization and perform the failover manually again to the servers that…

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,342 questions
asked 2020-09-05T01:50:00.487+00:00
Salves 501 Reputation points
commented 2020-09-05T13:33:04.277+00:00
Salves 501 Reputation points
2 answers

centralized monitoring for Query store multiple server

Are there any way (without 3rd party tools) to centralize the monitoring for querystore from multiple databases and across multiple servers

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,342 questions
asked 2020-09-03T04:45:13.967+00:00
sakuraime 2,321 Reputation points
commented 2020-09-05T12:22:06.833+00:00
tibor_karaszi@hotmail.com 4,306 Reputation points
5 answers One of the answers was accepted by the question author.

How to Improve / Shorten Merge Statements

Hello Community, This my first post to the new look Microsoft Q&A. I hope I'm in the right place to ask questions on Transact SQL I have the following merge statement which as you can see contains a lot of fields to be included in the 'WHEN MATCHED…

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,342 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,599 questions
asked 2020-09-03T12:50:31.327+00:00
Carlton Patterson 41 Reputation points
accepted 2020-09-05T09:47:12.3+00:00
Carlton Patterson 41 Reputation points
3 answers One of the answers was accepted by the question author.

SSIS Script Task

I have a table which has the list of files in a column Column values are File1.csv, File2.csv etc. Now in SSIS I would like to retrieve the list of files from the above table and then check if each file is present in a directory. If a file is…

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,342 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,523 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,599 questions
asked 2020-09-03T03:56:20.857+00:00
John K 186 Reputation points
accepted 2020-09-05T03:04:56.007+00:00
John K 186 Reputation points
4 answers

SQL Triggers

Hi, I need a help regarding SQL Triggers. I think I'm making a mistake that is why it is not executing well. I'm developing an application which have PURCHASE, PURCHASEDETAILS, LOGS tables. What I need here is that when I make a purchase and…

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,342 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,599 questions
asked 2020-08-23T16:53:12.82+00:00
Ranjith 1 Reputation point
commented 2020-09-04T21:56:30.097+00:00
Erland Sommarskog 106.8K Reputation points
2 answers

Have Report Builder forget saved credentials

Using Report Builder 3.0 for SQL Server 2014. I need to have it forget some user credentials forgotten when connecting to a report server. I have tried deleting the user config file, the clear all recent item lists option, and uninstalling 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,873 questions
asked 2020-08-17T15:56:02.537+00:00
Andrew 1 Reputation point
commented 2020-09-04T16:29:28.28+00:00
Brenda Stewart 96 Reputation points
3 answers One of the answers was accepted by the question author.

Tipping point Nested loop join and hash join ?

are there any tipping point for the query optimizer to choose between Nested loop join and hash join

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,342 questions
asked 2020-09-03T05:41:16.94+00:00
sakuraime 2,321 Reputation points
accepted 2020-09-04T16:10:11.523+00:00
sakuraime 2,321 Reputation points
1 answer One of the answers was accepted by the question author.

Tipping point batch mode on row store : SQL Server 2019

what's Tipping point for choosing batch mode on row store : SQL Server 2019

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,342 questions
asked 2020-09-03T06:47:31.42+00:00
sakuraime 2,321 Reputation points
accepted 2020-09-04T16:01:27.243+00:00
sakuraime 2,321 Reputation points
3 answers One of the answers was accepted by the question author.

SHOWPLAN_TEXT ON vs SHOWPLAN_ALL ON

what's the actual difference ? I can't see

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,342 questions
asked 2020-09-03T04:39:51.25+00:00
sakuraime 2,321 Reputation points
commented 2020-09-04T15:51:16.993+00:00
sakuraime 2,321 Reputation points
3 answers

parallel plan slower than serial plan

Can anyone give an example that parallel plan (parallelism) slower than serial plan

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,342 questions
asked 2020-09-02T18:43:50.507+00:00
sakuraime 2,321 Reputation points
commented 2020-09-04T15:48:04.603+00:00
sakuraime 2,321 Reputation points
2 answers One of the answers was accepted by the question author.

Having issues with a function to change a parameter value.

I have 2 parameters coming in - one has a job number that has to be reformatted and updated to the other. I wrote a function to do the format because nothing I tried in the expression for the second parameter worked. Well, it's still not working. 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,873 questions
asked 2020-09-03T20:49:18.04+00:00
Brenda Stewart 96 Reputation points
accepted 2020-09-04T15:09:19.373+00:00
Brenda Stewart 96 Reputation points
8 answers One of the answers was accepted by the question author.

sql server windows ad role permisions

I would like to grant a specific windows role automatic permissions to be the "dbo" every time a new database is created, can this be accomplished using the model database, thanks

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,342 questions
asked 2020-08-28T21:35:16.477+00:00
NeophyteSQL 241 Reputation points
commented 2020-09-04T14:44:49.89+00:00
NeophyteSQL 241 Reputation points