All Questions
4 questions
0
votes
1
answer
953
views
Resolve performance problem in recursive CTE
I have a dimensional (star schema) data model that supports BI on labor data. It includes an employee dimension table. This table is a type 2 slowly-changing dimension table, i.e., it stores history ...
- 2,113
0
votes
1
answer
353
views
Scheduled SQL Server backup ultimately restored to Azure SQL
I have been working in on-premises SQL Server since 1999 and am now trying to engage with Azure SQL.
I have identified one of our SQL DBs that we want to lift into Azure for reporting. (We will be ...
- 439
0
votes
1
answer
168
views
Azure SQL Does not allow login for Created Clients
I created several users for Azure SQL using the free acccount in a database in Azure Data Studio following the recommended procedure:
add client ip addresses to firewall
create login on the master ...
- 1,033
1
vote
2
answers
622
views
Azure SQL Slow Query when targeting an index
I've a relatively large DB used for IoT data, approximately around 60 million records. Inserts are performed very frequently in BULK Inserts from Stream Analytics.
This is my table schema:
CREATE ...
- 181