No announcements
Found 2207 threads
-
0 VotesMsg 110813 (Unknown type Timestamp at GetSqlTypeId). Polybase with ODBC Snowflake
Hi, I am new to polybase and trying to connect snoflake Database and been able to create external data source and data table. I am getting above error when ...
-
0 Votes
Need help on CSV,xslx to Azure SQL flow
Hi, I want to dump the data into Azure SQL by using Power automate Flows. I have no idea. Please guide me on this.Unanswered | 1 Replies | 2574 Views | Created by Sai Pranav - Friday, August 14, 2020 3:40 PM | Last reply by Olaf Helper - Friday, August 14, 2020 5:08 PM -
0 Votes
one time load of history table
Suggestion to load a one time history table into a SCD table Do I have to drop the indexes?,Proposed | 5 Replies | 3086 Views | Created by Dre01 - Tuesday, August 4, 2020 5:25 PM | Last reply by Dre01 - Friday, August 7, 2020 8:02 PM -
0 Votes
How to get matching and unmatching data from temp tables
Hello All I have procedure where I am getting data from my 1st temp table like ...Unanswered | 1 Replies | 3584 Views | Created by LuckySath - Saturday, August 1, 2020 3:05 PM | Last reply by scott_morris-ga - Saturday, August 1, 2020 6:07 PM -
0 Votes
insert update statement help
Hello All, I have a insert update procedure where I am getting data from 2 procedures and putting the data in to a table. So procedure 1 has data like ... -
1 Votes
PAGELATCH_UP:tempdb:12(PFS) contention
Hi All, I am observing multiple occurences of (814ms)PAGELATCH_UP:tempdb:12(PFS) wait type on my production ...Unanswered | 3 Replies | 2681 Views | Created by lark63 - Wednesday, July 29, 2020 2:11 PM | Last reply by Shanky_621 - Thursday, July 30, 2020 1:45 PM -
1 Votes
hai
1) If our databases crashed how do we restore it and plz pendown the steps involved in the process? 2) what are the performance issues we face in real ...Answered | 7 Replies | 6444 Views | Created by rajkat85 - Tuesday, March 5, 2013 6:18 AM | Last reply by jchang61 - Tuesday, July 28, 2020 3:59 PM -
0 Votes
Unable to load timestamp (Hexadecimal) to Azure Synapse
Hi, I have been trying to load table from Azure SQL to Azure synapse (formerly Azure DW) using Azure Data Factory. However, it is failing with a timestamp column, which has ...Unanswered | 2 Replies | 3585 Views | Created by BIFlake - Friday, July 24, 2020 4:50 PM | Last reply by Laxmidhar sahoo - Friday, July 24, 2020 5:59 PM -
0 Votes
Read Excel sheet names in Azure Data Factory V2
Hello, I need to read Excel sheet names in Azure Pipeline, so we can pass it as parameter to connection and do other things. Is there any way of doing it in ADF ...Unanswered | 1 Replies | 3907 Views | Created by Magelan913 - Friday, July 17, 2020 4:01 PM | Last reply by SSBJ_2504 - Tuesday, July 21, 2020 5:33 AM -
0 Votes
How to implement Retention Policies in Azure Synapse Analytics (Azure SQL Data Warehouse) ?
Trying to understand how to implement Retention Policies in Azure Synapse Analytics (Azure SQL Data Warehouse). There isn't enough supporting material on the ...Unanswered | 1 Replies | 3876 Views | Created by NeilIP - Monday, July 20, 2020 6:01 PM | Last reply by Tom Phillips - Monday, July 20, 2020 8:31 PM -
2 Votes
Choosing correct fact table type
Hi, I have an OLTP system that handles credit card transactions. Now I need to design a datawarehouse for it. I am confused between some options and need expert ...Unanswered | 5 Replies | 3967 Views | Created by Mkp27 - Monday, June 29, 2020 12:58 PM | Last reply by jakubk - Monday, July 20, 2020 2:29 PM -
0 Votes
update date field in a SC dimension table
I have a slowly changing table dimension that feeds off a stage table. This stage table consist of our current client assignment. My challenge is when the clients ... -
0 Votes
How to log the number of rows uploaded from BCP to Azure SQL Server
Hello We have our in-house data warehouse data being uploaded to MS SQL Azure via BCP. We have processing logs to monitor the number of rows transfered "locally" ie from ... -
0 Votes
Synapse Analytics: when we load a dataframe into table, why do we need to set parquet.writeLegacyFormat as True?
Dear Gurus, I am in need to load dataframes created in Databricks into Azure Synapse. Now, Microsoft's example requires setting Spark configuration for Parquet as ... -
0 Votes
CROSS Join Function not moving
I have a query where 14 mil data query is having a CROSS JOIN function. The query query get stuck here for hours and I don't see any change in data Logical read of Physical read ...Unanswered | 1 Replies | 3257 Views | Created by DBA_Atul - Friday, July 3, 2020 1:48 PM | Last reply by spolna - Monday, July 6, 2020 11:28 AM -
0 Votes
SSIS data flow task hangs when ran from SQL server agent job
Hi All, I am facing a strange issue from past few days. We are having a data flow task which dumps data to a excel from SQL server table. This excel file is ... -
0 Votes
Microsoft Universe tool
I am searching for Self service BI tool from Microsoft which can replace the BO Universe I currently have in my org. I found Report builder tool , but It is not in real for Business ... -
0 Votes
truncate and load of fact vs better solution
Hi, I have a requirement where there are 3 tables with fact data.These 3 tables are each sourcing a view that produces facts and these views are queried in ssis package.The ssis ... -
0 Votes
SQL Server Data Warehousing
Hi, I have no experience with SQL Server Data Warehousing, Do we have specific tools? Could you please let me ...Unanswered | 1 Replies | 3942 Views | Created by ZaraJ - Friday, June 12, 2020 6:16 PM | Last reply by AV111 - Sunday, June 14, 2020 1:13 AM -
4 Votes
Two Different Databases or Single Database
Hi , I would like to hear some inputs from the experts for my below query. My company is having two different manufacturing units in two ...Unanswered | 6 Replies | 4153 Views | Created by pepcoder - Monday, June 8, 2020 9:40 AM | Last reply by DBA_Atul - Monday, June 8, 2020 10:45 AM - Items 1 to 20 of 2207 Next ›
No announcements
