Prasad Chava

Bala Koteswara Prasad (Prasad) Chava is experienced in working on Microsoft .NET, SQL Server, Oracle, etc. He is a certified Microsoft professional developer. He has multiple professional certifications ranging from Salesforce, Azure, PMP and Dell Boomi. He is a member of the Project Management Institute (PMI). He has extensive experience in software architecture, solution delivery, and project management. He worked with many reputed organizations like IBM, Accenture, and Deloitte. He has extensive experience in TSQL and SQL server performance tuning.
  • Skills: C#.NET, ASP.NET, SQL Server, Oracle, Azure, Salesforce, Boomi, BizTalk, BMC Control-M, PMP

All authors

All authors

Blogs

Monday Monitor Tips: Knowing Your RPO

By

A customer was asking recently about the RPO for their estate, and I showed...

Webinar tomorrow: The Role of Databases in the Era of AI

By

I’m hosting a webinar tomorrow with Rie Merritt from Microsoft. We’ll be talking about...

Spark Connect Dotnet Variant Data Type

By

All Spark Connect Posts I recently published the latest version of the Spark Connect Dotnet...

Read the latest Blogs

Forums

Table Partitioning SQL server 2022

By Saran

Hi All, I am currently testing the Table Partitioning to implement in SQL server...

STRING_AGG's behavior

By Alessandro Mortola

Comments posted to this topic are about the item STRING_AGG's behavior

The Role of Databases in the Era of AI

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Role of Databases in...

Visit the forum

Question of the Day

STRING_AGG's behavior

Executing the following script (Sql Server 2022), you get the table t0 with 10 rows:
CREATE TABLE t0
( id     INT PRIMARY KEY
, field1 VARCHAR(1000)
, field2 VARCHAR(MAX));
INSERT INTO t0
SELECT
  gs.value
, REPLICATE ('X', 1000)
, REPLICATE ('Y', 1000)
FROM generate_series(1, 10, 1) gs;
GO
What happens if you execute the following statements?
  1. select STRING_AGG(field1, ';') within group (order by id)  from t0;
  2. select STRING_AGG(field2, ';') within group (order by id)  from t0;

See possible answers