How to increase SQL query performance of a view?
Hi everyone, I am new to Microsoft community, so please let me know if this post is not in the right forum and if so which one would be the right one. issue: - Update & query (using Power BI) of my Sales Weekly View takes forever (>30min) and I would like to understand how I could improve this Current setup: - Sales Daily View: View containing aggregation and joins of two main sales tables and a date table - Sales Weekly View: View joining the "Sales Daily View", a sales table and two dimension tables and containing extensive logics (mainly aggregations) Please let me know if you have any idea how to streamline this and improve the performance of the view.
How to get last updated date of the table
Hello Experts, I am looking for the date, when is the last update (delete, truncate and reinsert) was made on the table I came across SYS.DM_DB_INDEX_USAGE_STATS table with LAST_USER_UPDATE column, but sometime it returns NULL, Shall I believe on it gives me what I am looking for Regards, AmitDiscover the Future of Data Engineering with Microsoft Fabric for Technical Students & Entrepreneurs
Microsoft Fabric is an all-in-one analytics solution for enterprises that covers everything from data movement to data science, Real-Time Analytics, and business intelligence. It offers a comprehensive suite of services, including data lake, data engineering, and data integration, all in one place. This makes it an ideal platform for technical students and entrepreneurial developers looking to streamline their data engineering and analytics workflows.SSIS Excel Connection Manager error
I'm having issues with excel destination in my SSIS package. I'm using a conditional split to send data to a spread sheet from OLE DB source. I feel the issue is because of the version of excel SSIS allows to choose in the connection manager window. I could be wrong. Other destinations like flat file or OLE DB are not giving issues. I recently upgraded Microsoft Office 365. Screen shots of error included here. Thank you for your help in advance.What is the best practices to implement business logic in SQL database?
Hi Everyone, I am currently struggling to understand where and how to implement business logic & aggregations in SQL database in an optimal way Currently I am using the following ETL process which takes forever and is quite costly. Therefore I would appreciate to get some tips on how to optimize it ETL process: A. SQL Azure database: 1- Temporary tables: Store recent data (last 6 weeks) 2- Incremental load of data from the Temporary tables into the dbo tables 3- dbo tables (Fact tables): Store historical sales data (Last 3 years) 4- Daily View: Built on top of dbo tables. It implements business logic on daily data (aggregates data & Join data with the dimension tables) 5- Weekly View: Built on top of Daily View and another dbo table. It calculate weekly rolling average and other heavy calculations B. Power BI: 6- Query the Daily View & Weekly View into one single PBIX. file
i doing SQL tuning in Company databases but i don't know where to start
i am doing SQL tuning in Company databases but i dont know where to start as i am new in DBA i joined new company where they have lots of databases, and it issue with databases, can anyone help me where to i start what should be stepSql question
Hi Everyone, I have one sql problem to be solved 1. Image is the data 2.Image is the output that I should get. You need to output the dates, when Couriers changed their phone numbers. You shouldn't output the first phone number of a courier Through lead function I'm able to acheive, but I want to achieve it using joins 3. Image is the query that I used 4. Image is the output that I get I'm not sure how to get the output, using the query that I used, I have stucked in between Please help Thanks, Neha
