18,086 questions with SQL Server-related tags

Sort by: Updated
Updated Created Answers
3 answers

SQL Server Management Studio 18.x Bug on Open .sql file

Like in any Windows environment you have several options to open a file. Let's say you have all of them in SSMS too. Via internal File->Open menu or by grag-n-dropping a *.sql file to the opened and connected SSMS. The other option is to simply…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,849 questions
asked 2020-08-27T03:35:53.923+00:00
A T 1 Reputation point
answered 2020-09-01T06:35:19.77+00:00
m 4,271 Reputation points
3 answers

Filter statistics and recompile

is it a must to execute the query with recompile in order to use filter statistics ?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,849 questions
asked 2020-08-26T07:21:50.08+00:00
sakuraime 2,321 Reputation points
answered 2020-09-01T06:34:35.833+00:00
m 4,271 Reputation points
7 answers

memoryclerks vs memoryobject vs memory pools

Hi all , just want to know the difference of memory clerks and memory objects and what's are their relationship ? another question is why virtual_memory_committed_kb is much less than pages_kb?? pages_kb is the size that memory clerks…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,849 questions
asked 2020-08-25T03:27:20.543+00:00
sakuraime 2,321 Reputation points
answered 2020-09-01T06:34:14.353+00:00
m 4,271 Reputation points
1 answer

Auto Refreshing Data in excel with SQL Database

Hello, Is there a way for me to code my excel workbook that is connected to SQL server to automatically refresh (for example cell A to D) every 1 mins, Friday to Sunday, from 8 am-4 pm, using SQl code, Power query or VBA code. Thanks

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.
12,849 questions
asked 2020-08-27T23:37:39.653+00:00
Onlxy 1 Reputation point
commented 2020-09-01T06:33:23.317+00:00
m 4,271 Reputation points
2 answers

Adding new data file to AG

Can you please let me know the best and safest approach to add a new data file to an AG.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,849 questions
asked 2020-08-29T09:50:00.25+00:00
Chaitanya Kiran 101 Reputation points
commented 2020-09-01T05:46:22.697+00:00
CathyJi-MSFT 21,096 Reputation points Microsoft Vendor
2 answers

max queue depth for transaction log and data file

max queue depth for transaction log should be 32. what about mdf ?? are there any msdn official doc for 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.
12,849 questions
asked 2020-08-28T07:40:42.693+00:00
sakuraime 2,321 Reputation points
answered 2020-09-01T05:27:00.847+00:00
m 4,271 Reputation points
6 answers

subreport spans multiple pages when saved to pdf

hi we run 2016 enterprise. i have a master report calling my subreport multiple times. i should start with the sub. when i run it stand alone and save to pdf, it spans multiple pages which dont want. the sub's report page size shows 8.5in, 11in…

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,818 questions
asked 2020-08-20T10:27:53.057+00:00
db042190 1,516 Reputation points
commented 2020-09-01T02:26:06.507+00:00
Joyzhao-MSFT 15,566 Reputation points
3 answers

SQL Server Mirroring - Principal Database is not configured for mirroring

Is there any way of figuring out what the real reason is for Mirroring to give up on the Alter Database dbPrincipal Set Partner = 'TCP://Domain + server : Port , etc. There are so many reason why you will get the same error: Principal Database 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.
12,849 questions
asked 2020-08-29T02:45:56.157+00:00
travisGatesMcGee@hotmail.com 21 Reputation points
answered 2020-09-01T01:24:03.863+00:00
m 4,271 Reputation points
1 answer

How can I use a AzureAD account as administrator for SQL Server Master Data Services

I have tried setting up master data services on my Windows 10 laptop with a SQL Server 2019 Developer edition. On the step of creating the database, I tried using my AzureAD account, as this is the user I use to login to WIndows, but the installer…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,849 questions
asked 2020-08-25T08:44:19.937+00:00
Guido de Vries 1 Reputation point
commented 2020-09-01T00:46:59.367+00:00
Mike Ubezzi 2,776 Reputation points
1 answer One of the answers was accepted by the question author.

Question about obtaining MCSE: Data Management and Analytics

Dear MS, I have a question about obtaining the MCSE: Data Management and Analytics certification. Currently I am in possession of both a MCSA: SQL Server 2012/2014 and a MCSA: BI Reporting certification. However, the documentation on how to…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,849 questions
asked 2020-08-31T15:13:38.393+00:00
Mans Scholten 21 Reputation points
commented 2020-08-31T15:48:42.52+00:00
Dave Patrick 426.2K Reputation points MVP
4 answers

Connection string mvc app

I created a Web Application using mvc.app and connection to SQL Server. Application authenticates user via ADFS. How should I form my connection string, so the application will work with the SQL permission granted to the user? i.e. I have a user named…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,849 questions
asked 2020-08-27T22:33:36.227+00:00
TomaszW-0873 131 Reputation points
answered 2020-08-31T15:03:53.363+00:00
TomaszW-0873 131 Reputation points
3 answers

SCOM 2019 - Reports Missing - Using SQL Server 2016 SSRS

Have reinstalled the reporting services role and using SQL Server 2016 SSRS. Get the Application Monitoring and Windows Server Reports folders but then nothing else after that. I know there is a fix for this on SQL Server 2017 SSRS but that option is…

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,419 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.
12,849 questions
asked 2020-08-27T10:26:50.7+00:00
Dujon Walsham 6 Reputation points
answered 2020-08-31T14:56:47.87+00:00
Dujon Walsham 6 Reputation points
1 answer One of the answers was accepted by the question author.

pulling a calculated field from two separte fields

Hello, I have a table that is fed by a dataset. The dataset is a stored procedure that returns two lines associated with each employee. They are sorted by the indicator so line 1 is always followed by line 2. For example: …

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,818 questions
asked 2020-08-28T19:17:14.03+00:00
Michael K 21 Reputation points
commented 2020-08-31T14:25:44.297+00:00
Michael K 21 Reputation points
2 answers

Tirning off the usage of Buffer Pool Extension

We are using the SQL Server 2016 Standard with Buffer Pool Extension enabled on SSD drive. For external nightly maintenance we need to turn off an extensive writing on this SSD. So we have scheduled the turning off BPE. Checked it on the testing…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,849 questions
asked 2020-08-26T06:56:14.527+00:00
Александр Розенбаум 11 Reputation points
commented 2020-08-31T12:02:27.757+00:00
Ronen Ariely 15,096 Reputation points
4 answers

DBCC memory : Current commited vs Page free vs Page allocated vs pages in uses

Current commited vs Page free vs Page allocated vs pages in uses~~~~ <<< What are their relationship

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,849 questions
asked 2020-08-28T17:47:33.123+00:00
sakuraime 2,321 Reputation points
answered 2020-08-31T09:57:34.717+00:00
Shashank Singh 6,246 Reputation points
2 answers One of the answers was accepted by the question author.

Display all employee.

Below is data and query attached21355-q.txt, i want to display all employee from #tbl_employee_Master ,but asd.sal_ID is null from #tbl_assign_Allowance_Deduction ,means that emp_ID exit or not in #tbl_assign_Allowance_Deduction table ,

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,849 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,559 questions
asked 2020-08-30T08:44:21.753+00:00
Analyst_SQL 3,551 Reputation points
commented 2020-08-31T09:40:48.077+00:00
Analyst_SQL 3,551 Reputation points
2 answers One of the answers was accepted by the question author.

Avoiding CSV injection vulnerability in SSRS

I'm trying to find a way to avoid CSV injection when i export a report to CSV format is SSRS (Microsoft Reporting Services). The "manual way" to do it is to add an apostrophe (') to each cell. That will "convert" everything to text…

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,818 questions
asked 2020-08-30T16:57:59.253+00:00
Igal Drayerman 21 Reputation points
accepted 2020-08-31T09:33:00.363+00:00
Igal Drayerman 21 Reputation points
3 answers

Querying SQL Server 2012 Training Kit

Apologies in advance, this is very new to me. My boss wants me to start learning SQL queries to assist with reports at work, and the company uses SQL Server 2012. I've been given the Querying Microsoft SQL Server 2012 Training Kit book (textbook 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.
12,849 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,559 questions
asked 2020-08-27T12:18:13.17+00:00
AmyKernow 1 Reputation point
commented 2020-08-31T09:03:40.997+00:00
EchoLiu-MSFT 14,571 Reputation points
4 answers One of the answers was accepted by the question author.

Move on-prem SQL server VM to azure SQL VM

I am moving a clients servers to azure. We have been using ASR for past migration and plan to do the same. We dont have SA on SQL server licensing. The issue is when you move all the servers with ASR i do not see an option to make the migrated server…

Azure Migrate
Azure Migrate
A central hub of Azure cloud migration services and tools to discover, assess, and migrate workloads to the cloud.
722 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.
12,849 questions
Azure Site Recovery
Azure Site Recovery
An Azure native disaster recovery service. Previously known as Microsoft Azure Hyper-V Recovery Manager.
644 questions
asked 2020-08-26T21:22:26.727+00:00
Brice Milla 31 Reputation points
commented 2020-08-31T08:56:24.05+00:00
Ronen Ariely 15,096 Reputation points
2 answers

sys.dm_db_log_stats :log_truncate_holdup_reason : OLDEST_PAGE

for full mode database, I did some transaction , and then backup the transaction log . and then I will see sys.dm_db_log_stats :log_truncate_holdup_reason : OLDEST_PAGE there is some definition on the following but I am still a bit confused of 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.
12,849 questions
asked 2020-08-24T11:01:20.317+00:00
sakuraime 2,321 Reputation points
commented 2020-08-31T07:40:17.047+00:00
AmeliaGu-MSFT 13,961 Reputation points Microsoft Vendor