The Heap™ – Consultancy ©®

« first day (4916 days earlier) ← previous day next day → last day (115 days later) »

Criggie

12:00 AM

He's in my landrover - and it has scuttles below the windscreen. He likes to sit with his face on teh dashboard and have the neighbourhood smells powered into his nose :)

Erik Darling

Don’t tell him about used sneaker eBay

6 hours later…

Zikato

5:53 AM

good morning

3 hours later…

Paul White

8:30 AM

Wordle 1,097 4/6*

🟨⬜⬜⬜⬜
⬜⬜⬜🟨⬜
🟩🟩⬜🟩🟨
🟩🟩🟩🟩🟩

Morning

Vérace

8:56 AM

A chairde - Morning all!

Wordle 1,097 3/6*

🟩🟨⬛⬛🟨
🟩⬛🟩⬛🟩
🟩🟩🟩🟩🟩

Vérace

9:17 AM

Spain v. Italy and Denmark v. England should be good games! As per request, no spoilers...I think I'll support Italy in the first match, Denmark in the other and Slovenia against Serbia!

John K. N.

9:46 AM

Wordle 1,097 4/6*

🟨⬛⬛⬛⬛
🟨⬛⬛⬛🟨
⬛⬛🟩🟨⬛
🟩🟩🟩🟩🟩

2 hours later…

John K. N.

11:24 AM

GIVE ME YOUR NUMBERS: Is anybody else responsible for ~1600 databases (SQL Server, Oracle, MySQL, PostgreSQL) running on ~550 instances located on ~140 servers?

Yano_of_Queenscastle

310 databases, running on 2 SQL Server instances, 2 virtual servers :-)

Zikato

I'm not responsible

Yano_of_Queenscastle

11:40 AM

John: How are you even able to manage that? Especially since it has several different RDBMS...

John K. N.

@Yano_of_Queenscastle Well I have to learn the basics for each RDBMS: installation, configuration and maintenance. Then it's just up to learning some more. And even more. We use Rocket Remote Desktop to connect to the systems and a database to track all databases.

I'm not as good as others here, but I have a pretty good knowledge of internals of SQL Server and Oracle and some basic internal knowledge of the other RDBMS. I lack the knowledge on the tricky SELECT statements (CTE, PIVOT and the likes) and sometimes forget simple SELECT basics, but I'm quite the A in DBA.

Yano_of_Queenscastle

Impressive. I admire such versatility.

John K. N.

12:00 PM

Appreciate. You seem to doing a good job yourself. :-D

Yano_of_Queenscastle

@JohnK.N. Looks can be deceiving, but thank you for the kind words.

Zikato

12:35 PM

So did Niko Neugebauer cancel his blog when he went to MS? nikoport.com is not working for me - had to access it via wayback machine

Is there any reason why Check constraint failure will show the runtime values but foreign key failure does not?

Erik Darling

1:03 PM

Laziness

Paul White

Intern variability

John K. N.

Who's Laziness?

Paul White

@Zikato Pretty sure it was working yesterday

Zikato

1:19 PM

Maybe it was demonetized for Czech republic

Paul White

1:31 PM

Not working from here today either

Perhaps someone didn't pay their bill

Maybe someone from a rich company like NVidia will take care of it

Zikato

I was wondering how to find your new blog posts in one place - luckily it's here
https://twitter.com/SQL_Kiwi/articles

Did you move the blog to Twitter so Sean can't read it?

Paul White

p much

Zikato

Smart

Paul White

x.com/SQL_Kiwi/articles

for the modern kids

x.com/SQL_Kiwi/article/1803776447011754156 is the latest

I wish those links were the ones shared by default. I always have to go looking for them

Erik Darling

1:46 PM

Nice blog

Paul White

Some of us still do that

From time to time

Anyway, yes, it was inspired from your video. I thought the different row distribution across threads without a Repartition Streams was worth writing about, and it sort of spiralled from there. As these things tend to do.

Erik Darling

I hope no breakpoints were harmed in the writing of that blog post

Paul White

Many were set and reset

You have to be really motivated to debug a parallel plan

Erik Darling

I wouldn’t even know where to begin

Paul White

It's like explaining parallel nested loops in a foreign language

To someone that speaks a third language

While in character as a mime

Anyway, imagine buying SQL Server 2022 and thinking you were getting new code

Erik Darling

1:58 PM

Hey you get Ledger tables

Paul White

aka punishment tables

Erik Darling

> Beloved SeaWorld mime fired after 36 years over dispute with security guard

Wonder if he’s available for a parallel nested loops video

Paul White

raises many questions

Erik Darling

vitanzi vilivyowekwa sambamba

Paul White

is that a fact

Erik Darling

2:21 PM

Man a Swahili scrabble game would be bonkers

2 hours later…

Peter Vandivier

4:37 PM

syntax sanity check - specifying data_compression = page on the table is redundant if you specify it on the clustered index, right?

Erik Darling

wrong

oh wait

like create table?

Peter Vandivier

yea

not rebuilding an existing one

new table

Erik Darling

yeah well the clustered index is the table so it would be redundant

it may help to think of a table with a clustered index as a clustered table vs. heap table

i thought you meant if specifying it for other indexes would be redundant if there clustered index were compressed

Peter Vandivier

no, just for the CX, but ty

Erik Darling

4:53 PM

yes good luck with the job interview

Peter Vandivier

heh...

no, just noticed i forgot to put compression on a table i made earlier this week

but i'll be sure to hit you up when i need to explain the different types of joins

how r ur r8s?

Erik Darling

vry rsnbl

1 hour later…

user402514

6:06 PM

Just curious: what type of data do you store in your personal and private databases?

And also, do you know maybe how can I access the database of my personal PC computer? I use Windows 10, how do I access my own database?

Yano_of_Queenscastle

6:24 PM

@user402514 Private and personal, thank you very much :D

@user402514 Are you talking about some particular database? As far as I know, Windows 10 donẗ come with preinstalled generic database. Unless you cound file system, which, I guess, could be thought of as a database, though it is not usually what people mean by that term.

mustaccio

@user402514 I have a feeling that you're thinking about an application like Evernote or something

Erik Darling

I don’t have enough personal data for a database and anything private I wouldn’t store where anyone could ever get to it

Erik Darling

7:26 PM

there are few things quite as annoying as various batch mode eligibility tricks not getting the full batch mode on row store experience

3 hours later…

Paul White

10:39 PM

You need EXCLUSIVE BATCH MODE

A: High Memory Usage for SqlBulkCopy

I did a test I've created three tables Clustered columnstore Clustered index Heap And ran a bcp tool against 3 of them while looking in the Query Store Repro CREATE DATABASE BulkCopy GO USE BulkCopy go ALTER DATABASE [BulkCopy] SET QUERY_STORE CLEAR DROP TABLE IF EXISTS dbo.OrderItemCCX CREATE...