SQL Azure - Development

• Topics

  Started by

  Posts

  Last post

• ChatGPT implementation "reluctance"

  Fragmentation is my main area of interest and its my overriding concern.  Of course, when I speak …

  Steve Collins

  3 replies

  1 year, 7 months ago

  By: Jonathan AC Roberts

• Retrieve records from a database table where the value of a certain column is th

  I have a simplified version of a table for organizing documents here. What is the most efficient w…

  Aarush32

  2 replies

  1 year, 8 months ago

  By: Emperor100

• Can I connect Azure Synpase to an on-prem data source via Power BI Gateway

  Hello, I heard you can connect from Azure Synapse to on-prem data sources by connecting through a P…

  Luke L

  1 replies

  1 year, 8 months ago

  By: Luke L

• Advanced grouping for gaps and islands

  Hi, I'm trying to figure out how to group a set of data based on how many days a person is sick. Th…

  Alfred

  3 replies

  1 year, 9 months ago

  By: Alfred

• Reducing varchar(max) cols that are in auto generated indexes

  Hi all, I inherited an app schema that is shared across 140+ different DBs [one for each client; th…

  scarr030

  2 replies

  1 year, 9 months ago

  By: EdVassie

• JSON formatting output nested array

  Hi Guys, Apologies if this is posted in the wrong forum, but I have a query that moves data from a …

  lawson85

  6 replies

  1 year, 10 months ago

  By: lawson85

• Azure Pricing, SQL Server seems pretty high?

  Hi, I'm really new to this and I think I've got this wrong, wondering if you can help me.   I'…

  dosel99

  3 replies

  1 year, 10 months ago

  By: Eirikur Eiriksson

• bacpac has less records on local sql server

  Hello Everyone, As a server, I use Azure SQL (Microsoft SQL Azure (RTM) - 12.0.2000.8 Nov 8 2022 12…

  gaurav

  5 replies

  1 year, 10 months ago

  By: gaurav

• Reducing I/O reads and tempdb in Azure Severless SQL pool

  I've been using Azure Serverless SQL Pool for a couple of months now. I don't have much knowledge o…

  Dominic546

  2 replies

  1 year, 10 months ago

  By: Eirikur Eiriksson

• How to list sum of values in the specific period

  Sorry for very newbie questions. I have a table, shown below with values about duration of events. …

  demokedes

  3 replies

  1 year, 10 months ago

  By: demokedes

• Azure DevOps and branches

  Hi all   Firstly, full disclosure, we're only getting started with this so late to the party (…

  richardmgreen1

  13 replies

  1 year, 11 months ago

  By: richardmgreen1

• Substitute of trigger in a merge statement.

  Hello Everyone I hope you all are rocking. My question is regarding the merge statement. I am using…

  gaurav

  5 replies

  1 year, 11 months ago

  By: Eirikur Eiriksson

• Select count from a ~big table takes forever and brings the Data IO to 100%

  I am trying to figure out the reason for a behavior that is not as I expect. I am running some test…

  ashkan sirous

  6 replies

  1 year, 12 months ago

  By: Jeff Moden

• Mass update on Clustered Columnstore indexes

  Hi, we have a FACT table with 35 billion rows, partitioned on daily level. In a test environment we…

  SqlRon

  2 replies

  1 year, 12 months ago

  By: Hugo Kornelis

• Azure AD Integrated Security on a Mac Connecting to Azure SQL database

  Hopefully the great minds here can help,  to give some back ground to the situation we have Azure …

  RTaylor2208

  1 replies

  2 years ago

  By: RTaylor2208