18,099 questions with SQL Server-related tags

Sort by: Updated
Updated Created Answers
1 answer

Calculate cost per product per user from budgeted data

Hi, I have a requirement where i have the following data model and unable to arrive a correct measure for calculating cost per product per user.I want to be also able to slice by date and empl dim. Can someone pls correct and post ideas to…

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,248 questions
asked 2020-08-17T12:16:35.453+00:00
PV 21 Reputation points
commented 2020-08-28T05:51:57.583+00:00
Lukas Yu -MSFT 5,816 Reputation points
1 answer

mdx issue for multilevel dimension hierarchy

I have a requirement where i had to apply dimension security to one of the dimensions "CompensationItem". But the problem was it has dependency on another dimension "Scenario". We have a mapping table/measure (COMP SECURITY) with…

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,248 questions
asked 2020-08-19T09:54:10.52+00:00
sudipta sen 1 Reputation point
commented 2020-08-28T05:50:08.457+00:00
Lukas Yu -MSFT 5,816 Reputation points
1 answer

Create folders inside the "Tables" folder

Hello community. I have a model with more than 20 tables and I would like to group them by processes within the folder "Tables", being as follows: Tables > Process A >>> Table 1 >>> Table 2 >>> Table 3 …

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
439 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,248 questions
asked 2020-08-24T22:13:08.213+00:00
Daniel Castillo 1 Reputation point
commented 2020-08-28T04:09:21.493+00:00
PRADEEPCHEEKATLA-MSFT 78,986 Reputation points Microsoft Employee
2 answers

SSIS Foreach Loop with Conditional Data Flows/Flat File Connections?

I'm setting up a process to bulk insert daily flat files into a staging warehouse. The flat files are not very clean. The files for the first 40 days contains 20 column and the days after contain 22 columns. How can I set up my foreach loop to switch…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,462 questions
asked 2020-08-27T14:46:12.453+00:00
Robert Ong 1 Reputation point
answered 2020-08-28T03:24:47.317+00:00
Monalv-MSFT 5,896 Reputation points
2 answers

Connect to SQL server using jdbc with AD username and password

We want to In order to avoid SQL server accounts we want to use Active directory accounts in out java programs to connect to SQL server. We are not always able to use integrated security (e.g. different applications running on the same Wildfly instance…

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,862 questions
asked 2020-08-27T19:10:08.373+00:00
Schuetze, Peter 1 Reputation point
answered 2020-08-28T03:09:11.917+00:00
m 4,271 Reputation points
2 answers

Query does not return any results

Hello, I am running the following query on SSIS on the AdventureWorks2012 database.. select c.CustomerID as CustomerAK, p.Title, p.FirstName, p.MiddleName, p.LastName, p.Suffix, em.EmailAddress from Sales.Customer c join Person.Person p…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,462 questions
asked 2020-08-27T16:18:44.39+00:00
Edgar Toia Neto 1 Reputation point
answered 2020-08-28T02:50:19.957+00:00
Monalv-MSFT 5,896 Reputation points
4 answers

pdf makes top margin on first page slightly larger and adds blank page at end

hi we run 2016 enterprise and develop using vs 2017. my subreport has been changed to have a .04 cm top and bottom border so a rectangle at the top can always have a predictable bottom border location for tear off purposes. when i print stand alone…

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-27T19:48:05.027+00:00
db042190 1,516 Reputation points
answered 2020-08-28T02:11:25.873+00:00
Joyzhao-MSFT 15,566 Reputation points
1 answer

Does SSRS 2019 have the ability to encrypt attachments?

We are going to be sending email attachments as part of a data driven subscription. Some of the attachments could contain PHI. Can SSRS 2019 encrypt the files that are attached to the email?

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-27T12:30:29.98+00:00
Sherri McDonald 1 Reputation point
answered 2020-08-28T01:50:17.257+00:00
Joyzhao-MSFT 15,566 Reputation points
4 answers

How to replace sub string by stuff separated by stick | to separate values?

I work on SQL server 2012 I face issue I can't separate values by stick | using stuff ? meaning i need to replace sub string by stuff and what statement below do as sub string ,type.value and XML path SELECT DISTINCT [InputID],PART_ID,[Vendor…

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,862 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,562 questions
asked 2020-08-24T02:46:01.173+00:00
ahmed salah 3,216 Reputation points
answered 2020-08-28T01:33:45.897+00:00
m 4,271 Reputation points
5 answers

Linked Server. Dont show ip or dynamic dns

Hello, I want to make a link between two sql servers 2019. My server is a local machine, the other server is a virtual machine in cloud. I can connect the virtual to the local very easily but the ip shows up. Can i make the link and have my own…

SQL Server on Azure Virtual Machines
Azure Private Link
Azure Private Link
An Azure service that provides private connectivity from a virtual network to Azure platform as a service, customer-owned, or Microsoft partner services.
470 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,862 questions
asked 2020-08-23T08:24:12.737+00:00
Giorgos 21 Reputation points
answered 2020-08-28T01:33:17.58+00:00
m 4,271 Reputation points
4 answers

Hyper-V 2019 SQL 2016 Std on Windows 2012R2 slowdowns

Hello, Environment: Hyper-V 2019 256GB RAM, SQL 2016 fixed memory not dynamic 128GB on Server 2012R2. Only 2 VM's on the host, 10Gb nics (Broadcom), FC storage.CSV's. After several days, 4-5 SQL slows-down to a crawl, queries and writes. SQL 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,862 questions
asked 2020-08-22T05:44:49.097+00:00
Colin Marshall 1 Reputation point
answered 2020-08-28T01:32:50.747+00:00
m 4,271 Reputation points
5 answers

Unable to import Sybase ASE native data file using bcp

Hi, I have a requirement to import native BCP file from Sybase ASE to SQL Server. Can anyone please advise on this? 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.
12,862 questions
asked 2020-08-21T15:09:39.523+00:00
ssalun 26 Reputation points
answered 2020-08-28T01:32:01.563+00:00
m 4,271 Reputation points
6 answers

Arquivos MDF

Bom dia, tenho um banco de dados sendo o arquivo com 800Gb, e o disco onde ele está armazenado está praticamente cheio. Gostaria de saber qual é a melhor pratica para isso. Criar um novo drive, criar um novo MDF com autogrow e o arquivo atual…

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,862 questions
asked 2020-08-21T11:46:46.687+00:00
Alexander Benatti 21 Reputation points
answered 2020-08-28T01:31:35.553+00:00
m 4,271 Reputation points
1 answer One of the answers was accepted by the question author.

Query takes long time to run

SQL Server: 2014 Problem: I am running a query that joins 3 views and produces results. Query takes over 8 minutes to run, but it runs without an error and produces correct output. Can you please take a look at my query and tell me why it takes 8…

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,862 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,562 questions
asked 2020-08-27T14:38:34.403+00:00
SQLIsGood-7036 176 Reputation points
accepted 2020-08-27T17:55:56.03+00:00
SQLIsGood-7036 176 Reputation points
1 answer One of the answers was accepted by the question author.

Is there a way to auto-create all of the columns in a tablix?

Is there a way to auto-create all of the columns in a tablix? I have a SQL view with 100+ columns that the user wants to see in a spreadsheet created from an SSRS report and I do not want to manually create each column for the tablix.

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-26T17:51:16.39+00:00
Tom Stone 521 Reputation points
accepted 2020-08-27T14:28:31.44+00:00
Tom Stone 521 Reputation points
1 answer One of the answers was accepted by the question author.

Just show last date with Report Builder 3.0 custom report

Is there anyway to just show the last date something was added within the report builder as in reports I am getting multiple results when I just want the date of the last one added.

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-25T16:29:49.727+00:00
Adrian Hall 21 Reputation points
commented 2020-08-27T14:22:27.203+00:00
Adrian Hall 21 Reputation points
4 answers

Backup and Restore Database - Affect on Full Text Indexes

We are planning to move a database from SQL Server 2008 R2 to a SQL Server 2016 instance. This database has a few Full Text Catalogs, with all the indexes part of the PRIMARY file group. When we perform a Full backup and restore on this database, will…

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,862 questions
asked 2020-08-25T22:34:52.483+00:00
Mark Sanchez 61 Reputation points
answered 2020-08-27T13:02:46.017+00:00
Stratos Matzouranis 36 Reputation points
2 answers

Create SQL functions with parameters

Hello, I have a lot of sql scripts which use functions like "string_agg" and "concat_ws". those funcations are available from sql 2017. now I would like to create some backward compatibility for MSSQL 2016 and earlier. I tried if 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.
12,862 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,562 questions
asked 2020-08-26T12:11:26.737+00:00
Bart K 1 Reputation point
commented 2020-08-27T10:37:27.927+00:00
Viorel 112.9K Reputation points
3 answers

SQL CLR Types does not show up in Registry Editor

The administrator has installed and uninstalled the SQL CLR Types on a coworker's machine multiple times and when we search for it in the Registry Editor it isn't there. We keep wasting IT's time, and I figure I should ask the forum before asking again.…

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,862 questions
asked 2020-08-24T23:21:09.17+00:00
Brian Green 1 Reputation point
answered 2020-08-27T09:36:52.423+00:00
m 4,271 Reputation points
4 answers

SQL Server 2008 R2 Support extension

Hello, Our organization is using SQL Server 2008 R2. We do not wish to upgrade it to latest version due to cost implications and dependency on the associated application version. I read that extended support ended for SQL Server 2008 R2 ended in July…

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,862 questions
asked 2020-08-24T13:54:56.753+00:00
Shashank PS 1 Reputation point
answered 2020-08-27T09:36:33.34+00:00
m 4,271 Reputation points