18,699 questions with SQL Server-related tags

Sort by: Updated
Updated Created Answers
3 answers

Query optimization

Can anyone give an example that the sql query optimizer do the following ? outer joins sub-queries aggregation stars and snowflakes indexed views index plans update plans partitioned table elimination correlation elimination …

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,366 questions
asked 2020-09-03T04:25:45.22+00:00
sakuraime 2,321 Reputation points
answered 2020-09-08T01:11:41.863+00:00
m 4,271 Reputation points
8 answers

Connect to SQL server from batch file

Hello, I have a batch file that I use to start application from Win 7 client. It will connect to remote SQL Server and start application. It looks like this pushd \<server>\MITRE\SoftwareReleases\v23-lfhm cmd /c start…

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,366 questions
asked 2020-08-31T15:35:53.83+00:00
Susja 716 Reputation points
answered 2020-09-08T00:15:44.703+00:00
Susja 716 Reputation points
1 answer One of the answers was accepted by the question author.

Sql 71501 Error

This is the error i am facing for one week. I don't know how to solve it : SQL71501 :: Procedure: [dbo].[st_feesdata] contains an unresolved reference to an object. Either the object does not exist or the reference is ambiguous because it could refer…

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,366 questions
asked 2020-09-07T05:23:46.44+00:00
Zeeshan Haider 21 Reputation points
commented 2020-09-07T21:54:37.107+00:00
Erland Sommarskog 107.2K Reputation points
4 answers One of the answers was accepted by the question author.

through remote Linkserver AlwaysON not propery connect to redonly replca

Hi our environment details Server 2016 SP2 EE edition always on enables and AG enable secondary replica "read-intent only" Q1. I am planning to configure linkerver to connect read only replica using AG listener switch between 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,366 questions
asked 2020-09-04T09:42:46.943+00:00
Ashwan 521 Reputation points
answered 2020-09-07T21:15:20.237+00:00
Erland Sommarskog 107.2K Reputation points
2 answers One of the answers was accepted by the question author.

How to calculate 90th Percentile on time (either MM:SS or seconds )

SELECT DISTINCT ,DATEDIFF(s,MV_Incident.IncidentStartedDateTime,MV_Incident.IncidentDate) AS CalltakerProcessingTime ,DATEDIFF(s,MV_Incident.IncidentStartedDateTime,MV_Incident.FirstUnitDispatchedTime) AS TotalProcessingTime …

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,366 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,601 questions
asked 2020-09-01T21:21:00.607+00:00
Tamayo, Ashley 121 Reputation points
commented 2020-09-07T14:42:57.687+00:00
Tamayo, Ashley 121 Reputation points
3 answers One of the answers was accepted by the question author.

Azure vs AWS

Have the DBA team detailed any improvements managing SQL instances in Azure versus AWS? Would it be possible to leverage a SQL MI (managed instance) DB or DW?

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,366 questions
asked 2020-09-07T07:41:43.113+00:00
py 206 Reputation points
accepted 2020-09-07T11:50:41.017+00:00
py 206 Reputation points
2 answers One of the answers was accepted by the question author.

Non-yielding Scheduler

Hello, I have 2 SQL Server 2016 SP2-CU10 Production instances running one server A. Today, i noticed below error in both the instances at the same time. =============================== ***Unable to get thread context for spid 0 * Non-yielding Scheduler…

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,366 questions
asked 2020-09-07T09:47:15.313+00:00
Biltz 131 Reputation points
commented 2020-09-07T10:30:55.003+00:00
Shashank Singh 6,251 Reputation points
3 answers

SSRS - Unable to Hide Rectangle with CountRows Expression

Greetings! I'm trying to hide a rectangle based off on how many rows exist in a dataset but it's indicating that the Hidden Expression has an error. I know it's complaining about security permissions, but I'm pretty sure that is a false flag since…

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,878 questions
asked 2020-09-02T22:28:22.257+00:00
Underwood 1 Reputation point
answered 2020-09-07T10:11:06.817+00:00
Farhan Ahmed 1 Reputation point
3 answers One of the answers was accepted by the question author.

Error "-2147217900 CREATE VIEW" when getting data from SQL Server

Hello, I'm using Excel VBA to connect to SQL Server and get accounting data from accounting software. There are several databases (companies) in accounting software, but they all look alike. Whenever I connect to database (company) "A"…

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,366 questions
asked 2020-09-04T06:40:39.627+00:00
waldux 21 Reputation points
commented 2020-09-07T08:16:35.597+00:00
Erland Sommarskog 107.2K Reputation points
2 answers

Unable to connect App Service(.net core application) to SQL Server database

I have configured an App Service(hosted on Linux) which is unable to connect to an SQL Server database. Log error: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not…

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,366 questions
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
7,409 questions
asked 2020-08-31T19:56:16.817+00:00
Aleksandar Peychev 1 Reputation point
commented 2020-09-07T06:11:50.667+00:00
CathyJi-MSFT 21,136 Reputation points Microsoft Vendor
2 answers

How do I monitor SQL Data File Space using SCOM?

Hi, I am running SCOM 2016 and SQL 2017. Recently, I observed that SQL reserves the DB space while Indexing; hence, SQL run out of DB space. I have already gone through the following post and Kevin's article regarding DB space monitoring: …

Operations Manager
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,446 questions
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,366 questions
asked 2020-09-01T11:25:04.51+00:00
Pauciloquent 71 Reputation points
commented 2020-09-07T05:47:15.65+00:00
Crystal-MSFT 46,271 Reputation points Microsoft Vendor
2 answers

government ID Cards

Hello, I wanted to take a 462: Administering Microsoft SQL Server 2012/2014 Databases but I have a problem with government IDs. I have requested to renew my work permit in June and I still don't have my card mailed to me. I only have the paper that lets…

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,366 questions
asked 2020-09-04T17:26:06.197+00:00
Blen Bekele 1 Reputation point
answered 2020-09-07T03:06:49.14+00:00
AmeliaGu-MSFT 13,971 Reputation points Microsoft Vendor
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,878 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,366 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,366 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,263 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,366 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,616 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,366 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,366 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,366 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,525 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,601 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,366 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,231 Reputation points