gonsalu

Same message is also on the technical whitepaper that was released for 2019

:-S

Wouldn't that just be for nvarchar?

Shouldn't it be 20 bytes for nchar(10)?

I'm reading the new features for SQL Server 2019; on the new UTF-8 support part it says "This reduction is because NCHAR(10) requires 22 bytes for storage, whereas CHAR(10) requires 12 bytes for the same Unicode string."

Hello

@sp_BlitzErik required for mssql-cli

@mmarie well, that sucks

@mmarie ah... so there's no way to get dynamic security working with it?

@mmarie, but if it uses the effectiveusername, doesn't it work correctly?

Love the community addition at the bottom haha

msdn.microsoft.com/en-us/library/hh213316.aspx

@PaulWhite Haha yeah, it's pretty low. Who sets the prices anyway? I thought the presenters would?

and share it :-P

@PaulWhite Yes, that's true, didn't think of that. Poop.

@AaronBertrand Hehe, probably not for a whole day :-)

Even though it's my birthplace, I can't be there in May :-\

@PaulWhite, I think it's been asked before, but will there be recordings of your precon in Lisbon? I'd gladly pay the precon registration amount to see it

haha

...and that's the last time we saw ypercube

:-)

Relevant XKCD xkcd.com/356

It's not a common case anyway, I just had a vague idea that it screwed something

I have a user with datareader on the database and deny on the column and the COUNT( *) doesn't work, though

haha sorry!

I tried, but gave up and went with spaces :-)

argh, formatting

OK, VPN'd into a client to test the COUNT( * ) thing, with a table (a, b), denying access to b, I can't COUNT( * ) or COUNT(1), but COUNT(a) works

Mercator projection sucks! haha

Yeah, it's really cool. It's crazy how big countries near the equator are compared to countries near the poles

@PaulWhite, @AaronBertrand, OK, thanks! I've to update my idea of it

Is my understanding correct? I would test it, but I don't have access to a SQL Server instance right now

@PaulWhite going a back to the COUNT() thing, I'm under the impression that COUNT(*) is not quite the same as COUNT(1) because COUNT(*) would fail when you don't have permissions to read all the columns of a table

@AaronBertrand it was more an opportunity to mention mapfrappe, I know you weren't being literal :-)

mapfrappe.com is really cool to compare areas on different parts of the world

@AaronBertrand Not exactly the same size imgur.com/GgjdNZg hehe

clustered column store index - part 6239

but at the same time, makes working with source control a pain in the ass :(

I'm using project deployment model and don't want to give up the sweet, sweet execution ID on a single master package call

haha

@billinkc, in SSIS projects with a lot of packages (>100), would you keep it in a single project or try to split it in multiple projects?

@Marian true :)

Like relevant xkcd post, it seems there's always a relevant Paul White post, lol

@billinkc sqlblog.com/blogs/paul_white/archive/2013/02/01/…

@Marian WTL for Windows 8 / Server 2012 introduced .etl compression which reduces its size a lot

In case anyone is interested in getting started with WPA as well, I really liked seeing these introduction videos from Bruce Dawson: randomascii.wordpress.com/2014/08/19/…

Really need to start messing around with WPA

Found this post really interesting

chrisadkin.org/2014/10/27/…

Please add the execution plan for the query.