It's the law of unintended consequences: things happening that you don't expect from a seemingly unrelated area. This article talks about a data center having leaks from carpet cleaning above. The concrete floor had aged and the carpet cleaners dumped water on the carpet to soak it through and it leaked. I'm not sure how people have data centers below office floors, but I know I've had a number of them at different companies where I've worked.
2007-09-12
131 reads
Steve Jones bimonthly car update looks at driving in the UK and the differences in cars between the US and elsewhere.
2007-07-30
28 reads
2007-07-04
10 reads
Steve Jones takes a look at energy news and how Google and Microsoft are looking to lower their dependence on the grid and advance alternative energy use.
2007-06-27
5 reads
Steve Jones takes a look at the world of automobiles and specifically his new Prius hybrid.
2007-05-29
30 reads
A guest editorial today from Atieh Jones wondering where are all the women in IT?
2007-02-14
115 reads
A guest editorial today from Lynda Rab, PASS board member and new mother.
2007-02-13
32 reads
Steve Jones looks at some of the issues with gender in the workplace and reminds everyone that they need to respect each other.
2007-02-12
12 reads
Steve Jones talks about the ne value of the new certification program from Microsoft.
2006-11-20
566 reads
A change here at SQLServerCentral.com and Steve Jones gives some thoughts on the impact of this for the future.
2006-11-13
102 reads
By Ed Elliott
All Spark Connect Posts I recently published the latest version of the Spark Connect Dotnet...
By Steve Jones
opia – n. the ambiguous intensity of eye contact The entry for this says...
By Steve Jones
This was actually a cool tip I saw internally from one of the product...
Hi All, I am currently testing the Table Partitioning to implement in SQL server...
Vidalista, a highly effective medication for erectile dysfunction (ED), is widely celebrated for its...
Comments posted to this topic are about the item STRING_AGG's behavior
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;
GOselect STRING_AGG(field1, ';') within group (order by id) from t0;
select STRING_AGG(field2, ';') within group (order by id) from t0;