SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,270 questions
0 answers
Analysis Service very slow to connect in SQL Management Studio
Hi all, I have a SQL Server, SSAS and SQL Server Management Studio installed on the same PC. Connecting to the SQL Database Engine in SSMS is very fast. However, connecting to SSAS in SSMS is excruciatingly slow, even though it is just a localhost…
asked 2024-06-25T04:30:15.7066667+00:00
Norman K. F. Chow
80
Reputation points
asked 2024-06-25T04:30:15.7066667+00:00
Norman K. F. Chow
80
Reputation points
1 answer
One of the answers was accepted by the question author.
Sql join query with total row
Hi , please help create table #temp (LedgerID INT, Amount Decimal(18,3)) insert into #temp (LedgerID,Amount) values (121,100),(121,250),(129,25),(129,200),(158,100),(158,500),(157,250),(157,100),(48625,1000) CREATE TABLE #temp_table ( cid INT, type…
asked 2024-06-24T07:11:57.31+00:00
Mohamed Farook
161
Reputation points
accepted 2024-06-27T04:39:03.08+00:00
Mohamed Farook
161
Reputation points
2 answers
SQL Server Agent Job "Process Full in SSAS" throws error without details
We have a Tabular Model deployed in SSAS that worked until three days ago but doesnt anymore. It throws errors when calling full process from a sql server agent job. This is basically the Error Message: Column '' in Table '' contains a duplicate value…
asked 2024-06-14T07:30:56.9033333+00:00
Mentler, André
0
Reputation points
commented 2024-06-14T14:24:42.5966667+00:00
Mentler, André
0
Reputation points
2 answers
unable to convert unique identifier
Hi Team, unable to convert this value as an unique identifier and getting null values SELECT try_convert(uniqueidentifier,''9UIC32D1-932-4V03-45E9-FGSGDASASDATY'')testid
asked 2024-06-12T07:17:37.1633333+00:00
Vineet S
325
Reputation points
commented 2024-06-13T08:27:50.7633333+00:00
Erland Sommarskog
106K
Reputation points MVP
1 answer
How to copy an SSAS cube
Good day, I have a cube in SSAS for one financial period, that I wish to replicate for a new financial period, how can I achieve this? Please assist Many thanks
1 answer
SSAS Dimension Processing: Why use ProcessUpdate when ProcessFull is faster?
I have a question about which processing option should be used for SSAS dimensions. I heard that ProcessFull option is faster than ProcessUpdate, and I found that it is the case. I have a big dimension of a cube, which takes about 90 mins to process…
asked 2024-06-04T03:50:47.87+00:00
Norman K. F. Chow
80
Reputation points
commented 2024-06-05T07:18:44.41+00:00
Norman K. F. Chow
80
Reputation points
3 answers
asked 2024-06-03T08:19:20.6533333+00:00
Cydrx Malla
0
Reputation points
commented 2024-06-06T03:28:25.09+00:00
MikeyQiaoMSFT-0444
1,750
Reputation points
2 answers
Compiling SSAS, SSRS, and SSIS projects under Build Tools for Visual Studio 2022?
I have a build server using Build Tools for Visual Studio 2022 to compile projects. We have several systems that are currently not using the build server because they use SSAS, SSRS, and SSIS projects. Investigating, it looks like Build Tools does not…
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,860 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,509 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,258 questions
Visual Studio Extensions
Visual Studio Extensions
Visual Studio: A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.Extensions: A program or program module that adds functionality to or extends the effectiveness of a program.
191 questions
Visual Studio Setup
Visual Studio Setup
Visual Studio: A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.Setup: The procedures involved in preparing a software program or application to operate within a computer or mobile device.
1,004 questions
asked 2024-05-31T14:54:04.85+00:00
Zarate, Martin
5
Reputation points
answered 2024-06-03T05:54:26.9733333+00:00
ZoeHui-MSFT
34,996
Reputation points
2 answers
I'm using Visual studio 2022 & creating a tabular model but not able to connect to Azure Data lake blob storage - not even able to see that connector
I'm using Visual studio 2022 & creating a tabular model but not able to connect to Azure Data lake blob storage - not even able to see that connector & attaching the screenshot of the connector image. Compatibility level of the SSAS Tabular…
asked 2024-05-31T06:52:56.3233333+00:00
Aravind K Pachaiyappan
0
Reputation points
edited a comment 2024-06-11T11:51:23.16+00:00
Aravind K Pachaiyappan
0
Reputation points
4 answers
create sp to populate table from one db to another
Hi, how to create Store procedure to populate data from one database table to another database table and do we need to refresh or it will auto sync
asked 2024-05-21T02:56:37.6+00:00
Vineet S
325
Reputation points
commented 2024-06-04T14:28:23.0166667+00:00
ShaktiSingh-MSFT
14,296
Reputation points Microsoft Employee
0 answers
Modelos tabulares no liberan memoria
Buenos dias, paso a consultar por un problema. Tengo varios modelos tabulares, y cada vez que proceso alguna partición, la memoria de mi servidor llega a 85/90%. Una vez terminado el procesamiento, la memoria queda en esos niveles, por lo que si quiero…
asked 2024-05-17T11:56:15.51+00:00
Roberto Lavisse
0
Reputation points
asked 2024-05-17T11:56:15.51+00:00
Roberto Lavisse
0
Reputation points
1 answer
Deploying the tabular cube failed with a timerunot error
Hello everyone, I'm encountering an issue while deploying the cube. It's failing, as shown in the image below. Can anyone help me with this?
asked 2024-05-10T13:51:47.6366667+00:00
Bharath Kumar
5
Reputation points
answered 2024-06-09T10:42:09.4333333+00:00
Greg Low
1,680
Reputation points Microsoft Regional Director
3 answers
Unable to install SQL Server (setup.exe). Exit code (Decimal): -2061893606Error description: Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes.
I have been trying to run kestrel in Visual Studio, and then I got this message: System.AggregateException: 'One or more errors occurred. (A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server…
asked 2024-05-10T07:45:13.2366667+00:00
Natalia Medrano
0
Reputation points
commented 2024-05-27T06:06:58.99+00:00
MikeyQiaoMSFT-0444
1,750
Reputation points
2 answers
One of the answers was accepted by the question author.
Contact Microsoft support
How can i contact Microsoft for direct support for my issue？
asked 2024-04-30T15:09:09.4633333+00:00
Jefferson-2765
486
Reputation points
edited an answer 2024-05-10T02:32:12.0066667+00:00
ZoeHui-MSFT
34,996
Reputation points
1 answer
analysis services pivot taking a long time to refresh
We have an analysis services object that we connect in excel for pivot tables. This has been running fine for 3 years. IN the past month it is taking very long to refresh and also prevents anything else in Excel from being opened (even outlook). What…
asked 2024-04-24T14:37:25.1533333+00:00
Tina Douglass
1
Reputation point
commented 2024-04-25T23:46:30.08+00:00
Greg Low
1,680
Reputation points Microsoft Regional Director
1 answer
One of the answers was accepted by the question author.
Best way to learn SSIS
I got a new role where we will use SSIS to migrate data from test system to production. What would be the best way to learn SSIS as I have worked with T-SQL and SSMS. It will be on premise 2019 edition.
asked 2024-04-19T19:35:40.58+00:00
Jonathan Brotto
200
Reputation points
accepted 2024-04-19T20:54:43.45+00:00
Jonathan Brotto
200
Reputation points
2 answers
asked 2024-04-14T11:17:03.4666667+00:00
hamada mostafa mohammed othman
0
Reputation points
commented 2024-04-29T06:41:30.74+00:00
LucyChenMSFT-4874
2,985
Reputation points
1 answer
SSAS Tabular model 2022 (Disappear specific data import feature)
Hi All, I am unable to find the below feature in SSAS 2022 version, does anyone know how to import specific data into SSAS 2022. The screen below appears when importing data from an existing connection in SSAS 2022. Thanks in advance.
asked 2024-04-03T07:21:55.98+00:00
Manikant Mahovia
41
Reputation points
commented 2024-04-04T08:07:41.6966667+00:00
PRADEEPCHEEKATLA-MSFT
84,936
Reputation points Microsoft Employee
1 answer
EnableCrossDatabaseFolding for SSAS?
Is there any chance this option will be added also to SSAS? I'd like to no longer have to define views just to fake using only one database.
asked 2024-03-28T14:46:08.6566667+00:00
Salvatore Iamundo
0
Reputation points
answered 2024-04-18T01:07:40.1733333+00:00
Greg Low
1,680
Reputation points Microsoft Regional Director
3 answers
has inline function got any catch?
hi, I heard many people saying "functions are denounced in tsql" is there any catch? q1) need to know what are the cases where we should not use? q2) should we avoid scaler functions also? q3) should we avoid scaler functions if we have to…
asked 2024-03-11T05:57:35.8533333+00:00
Rajesh Kumar Yadav
20
Reputation points
answered 2024-03-26T17:11:52.99+00:00
Bruce (SqlWork.com)
60,866
Reputation points