Databases - TopAnswers

TopAnswers Databases

Meta

dbfiddle

Anonymous 1484 Anonymous 1484

Nonclustered index storage on clustered columnstore

sql-server-2016

Paul White Paul White

6 1. The "bookmark" is the *columnstore index original locator* (per "Pro SQL Server Internals" by Dmitri Korotkevitch). This is an 8-byte value, with the columnstore index's `row_group_id` in the first 4-bytes and an offset in the second 4-bytes.

AMtwo

How to get count for different columns on same table

sql-server

Kaishu Kaishu

8 This is a typical pivot transformation, and conditional aggregation, as [suggested by Phil](https://topanswers.xyz/databases?q=1216#a1442), is the good old way of implementing it.

Andriy M

4 It's easiest with `SUM()` and a `CASE` statement:

Phil

Help with PIVOT query

sql-server-2008-r2

Kin Shah Kin Shah

4 This is a bit messy to get the final result because you have multiple `SCHEMA_VER` for each date. Before I demonstrate how to do this with dynamic SQL, I'll first show how to do it with static code to get the logic correct. In order to get the final result you can utilize both pivot and unpivot.

taryn

3 Adding explanation and a fiddle: http://sqlfiddle.com/#!6/c92b2/5.

JoseTeixeira

db<>fiddle Feedback 469 5

Meta

dbfiddle

Jack Douglas Jack Douglas

5 I have several links to db<>fiddle for demos in the following post:

Solomon Rutzky

5 `feature-request` **Concurrency Support**

PeterVandivier

5 The "ff" ligature destroys the cursor position. See GIF below:

fiatjaf

4 `bug` `fixed` Brittle fiddle one-boxing in chat

PeterVandivier

4 `bug` `fixed` YYYY-MM-DD for SQL Server

PeterVandivier

4 `bug` `fixed` Embedded fiddles should respect `&hide=` args

PeterVandivier

4 `bug` clicking 'Back' should switch back not only the query, but also the database selection.

Ami

3 `feature-request` please add an (opt-in) cookie to remember the last platform a user was on?

PeterVandivier

2 `bug` All-null rows collapsing in embedded fiddles

PeterVandivier

2 `feature-request` please add CockroachDB

PeterVandivier

2 `feature-request` `declined` add an 'Update this post' button on embedded db<>fiddles on TopAnswers

PeterVandivier

2 `bug` `fixed`: Firebird, datatypes, aligning

Arioch

0 `feature-request` sa/postgres/root - superuser fiddles

PeterVandivier

0 `feature-request` `retracted` Add support for SQL Server `GO [count]` syntax

John aka hot2use

0 `feature-request` [`declined`](https://topanswers.xyz/transcript?room=37&id=17302#c17302) Allow multiple statements per batch for Firebird again

Arioch

Dynamic pivot: sum of sales per month

sql-server

user16947 user16947

4 As others have said this is known as a [`PIVOT`](http://msdn.microsoft.com/en-us/library/ms177410%28v=sql.105%29.aspx). There are several ways in which you can transform your data from rows into columns of data.

taryn

What does it mean when pg_stat_activity.datname is NULL?

postgresql

PeterVandivier PeterVandivier

How to force users to specify a filegroup when creating tables/indexes

sql-server-2017

Martin Guth Martin Guth

4 You could possible create a new default filegroup with the Read_Only property set.

John aka hot2use

Understanding CleanupTime in Ola Hallengren's SQL Server scripts in relation to FULL backups and LOG backups

sql-server-2016

Wouter Wouter

0 The `@CleanupTime` is always specified for a specific backup job. For example, if you create a **Full** backup job, a **Differential** backup job and a **Transaction Log** backup job, then the `@CleanupTime` always relates to the extension of the job.

John aka hot2use

Hello friends, I am back again with another puzzle. This time it is SQL Server 2019 but basically I have a table with an id, parent id, name, and active flag. I would like the parent id and name combination to be unique for all records that are active. Is this possible? What I have so far... Ideally, this should work with a pre-existing table. https://dbfiddle.uk/?rdbms=sqlserver_2019&fiddle=97400970494db2b30f83278a8f094c64 EDIT: reduced number of inserts

> [An application core dump will be stored in whatever the current working directory is at that time. As far as I know you can't change that behavior.](https://forums.freebsd.org/threads/core-files.17761/) 🤔

this is my local ```sql Last login: Tue Aug 4 07:52:26 on console 0804 08:04:32+0100 [~] $ psql Pager usage is off. Null display is "[null]". psql (12.1) Type "help" for help. pvandivier=# ^\Quit: 3 0804 08:04:36+0100 [~] $ ```

Having said which, it would be more in the nature of asking for *advice* rather than a specific *solution* (although I'm not ruling the latter out entirely!), which is part of my hesitation. If there's a `recommendation` tag (which there appears not to be), that would probably have been appropriate for what I have in mind.

That's another question entirely, but one that's been asked and answered many times. you need to either know your pivot columns in advance or [pivot dynamically](https://stackoverflow.com/a/10404455/4709762)