Can not able to import Excel File into SQL
Hi Team, I mostly working with Excel. Some of excel files having large amount of data (Eg. Around 8 lakh rows and 52 Columns) For getting some results, excel is hanging or taking more time and more functions. But SQL is very fine to get results within seconds. Problem is while importing excel file (Ver. 2007) it shows an error (Please find attached file) But, It allows to import excel file of 97-2003 file format. i.e xls. For getting result, i am saving "xlsx" file into multiple "xls" files (Coz, xls having 65536 rows only) Single "Xlsx" file of 8 lakh records saved as 16 "Xls" files contains 50000 records per file. And importing them into MS SQL Server. Solve this.
Azure Analysis Services - refresh
Hello, our current setup is on-premises PostgreSQL DB that serves as data warehouse. We use Power BI Pro platform to create data model and refresh the data daily, using locally run Data Gateway. As the size of the data is already resulting in refresh times longer than 1 hour, and getting close to the 1GB data model size limit, I am considering setting up Azure Analysis Services. However, what is not clear to me is how the data refresh is handled in such case. I presume that on-premises data gateway would still be required in order to access our PostgreSQL DB. How is the refresh (and in addition, incremental refresh) handled when using Azure Analysis Services? Is there a scheduler available? Are there some limitations (e.g. how long a refresh can take before it timeouts?) Thank you.
Sql 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
Facing Slowness issue after migrating from sql server 2008(old server) to sql server 2016(new server
We have a RDP server which is running in 2008 version of SSMS and OS. Recently we migrated this server to 2016 version, both the OS(2016) and SSMS(2016). Configured new machine(with ssms2016) is same to the old one(with ssms2008) in terms of system configuration. It has a 64-bit OS with x64-based processor. RAM memory is 64.0 GB and 2.39 GHz (32 processor). We are facing severe performance issue while running stored procedures in SSMS 2016 version, as same code base has been migrated from sql server 2008.We are loading data to these servers using SSIS ETL tools. For example if we are running a stored procedure in old server(with ssms2008) it is taking 1 hour of time but the same SP is taking 10 hours of time in new server(with ssms 2016) sometimes even more. To identify the root cause we have tried below approaches but so far nothing worked. After migration we changed the compatibility level of sql server from 2008 to 2016. Restored the database once again from old server (ssms 2008) to new server (ssms 2016 ) without changing the compatibility level. Recompiled the stored procedures in new server(ssms2016). updated the statistics in new server(ssms2016). Disc reconfiguration/thickening of windows new server drives also. While running time consuming stored procedure in new server(ssms2016), parallely ran sql server profiler but nothing fruitful we have got. Ran parallelly same query in ssms 2008 and ssms 2016 servers at the same time, in old server(ssms2008) execution got completed much faster than new server(ssms2016) Note: is there any solution we can try to get the same execution time in both servers. Thanks in Advance. Regards, Prashant AgrawalLinux Drivers for SSAS
Hey, While working on our new analytics and dashboarding tool on Linux, I learned that there are no Linux Client Drivers for SQL Server Analysis Services. I figured I'd post this converstion as a "Feature Request" and wondering if I can get more support or votes for this. I hope a Linux Driver for SSAS will be available soon! Many thanks! Dennis
please help(:
Hi, I'm struggling to create a SELECT STATEMENT that will return YTD values and the % of change per year. Basically I have a huge Violation table - 'FactParkingViolation' (that holds every Parking Violation for the last 30 years). I want it to return The Amount (Count) of the number of Violation per Year between 20015 – 2017 and the % of change So lets say the fields will be: Count(Year(IssueDate)), Y-2015, Y-2016, Y-2017, %OfChange Any help will be much appreciated (:SQL Server 2017 CU19 - SSAS Tabular Errors
We've recently applied CU19 to our SSAS Dev server and immediately had db corruption errors on instance start-up. Event Viewer showing errors such as: Errors in the metadata manager. An error occurred when loading the '<>' cube, from the file, '\<>.xml'. SSMS showing corrupt DB warnings when loading up the instance. We uninstalled the update and things returned to normal. Anyone else come across this ? Is it one to go log an issue with ? Regards, David
Always on High availability
Hi, I am creating Always on high availability group and stuck at error [failed to join the database 'DB10" to the availability group 'G10' on the availability replica 'SQLDEV17-02\SQLSERVER02'] , i can see [the connection to the primary replica is not active error: 35250]. When i check logs i found below 2019-03-13 22:56:46.57 Logon Error: 18456, Severity: 14, State: 5. 2019-03-13 22:56:46.57 Logon Login failed for user 'RESEMBLECORP\SQLDEV17-01$'. Reason: Could not find a login matching the name provided. [CLIENT: <local machine>] Here RESEMBLECORP is domain and SQLDEV17-01$ is server. i am not getting why it is taking machine account instead of taking service account 'RESEMBLECORP\administrator'.
Calling stored procedures to refresh the SSAS tabular model often results in errors
I have published 4-5 table models on the SSAS instance, and I refresh the data of the table model every day after the data warehouse is refreshed. However, they often report errors and the logs cannot identify any problems. Yesterday , last Sunday were successful, and today only one model is successful. What is the reason for this? The SSAS tabular model is a connected MySQL data source, and the error message is as follows: 001 Model: The OLE DB provider 'MSOLAP' for linked server 'SSAS-001' returned the message 'OLE DB or ODBC error: [DataSource. Error] MySQL: Fatal error encoded during data read...'. [SQLSTATE 01000] (Message 7412) Unable to run on remote server 'SSAS_ Execute statement on 001 '. [SQLSTATE 42000] (Error 50000) This step failed. 003 Model: The OLE DB provider 'MSOLAP' for linked server 'SSAS-003' returned the message 'The current operation has been canceled because another operation in the transaction failed.'. [SQLSTATE 01000] (Message 7412) Unable to run on remote server 'SSAS_ Execute statement on 003 '. [SQLSTATE 42000] (Error 50000) This step failed. 003 Model: The OLE DB provider 'MSOLAP' for linked server 'SSAS-003' returned the message 'The current operation has been canceled because another operation in the transaction failed.'. [SQLSTATE 01000] (Message 7412) Unable to run on remote server 'SSAS_ Execute statement on 003 '. [SQLSTATE 42000] (Error 50000) This step failed. 004 Model: The OLE DB provider 'MSOLAP' for linked server 'SSAS-004' returned the message 'OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E.'. [SQLSTATE 01000] (Message 7412) Unable to run on remote server 'SSAS_ Execute statement on 004 '. [SQLSTATE 42000] (Error 50000) This step failed. Normally, it takes about 30 minutes to finish job refresh. Looking forward to your reply, thank you.
