Alex -

With TDE, backup compression only kicks in if maxtransfersize is specified in the backup command and maxtransfersize must be greater than 65536 (64 KB). You'd need to check the...

Well...I can't get it to show correctly on pasting....sorry about that. But the empty lines are removed and it does make things less readable. Brandi's example has no spaces and...

I was just trying it out....if you have a chunk of sql and then have several cr/lf, those lines just disappear so the code is all together instead of having...

It isn't honoring the line feeds, carriage return betweeen code chunks - adding into the editor or if pasted from SSMS.

Try one pasted from notepad:

SELECT 
sp.state_desc, 
sp.permission_name,
p.name,...

Spacing...

SELECT 
sp.state_desc, 
sp.permission_name,
p.name, 
sp.class_desc
FROM sys.server_permissions AS sp
JOIN sys.server_principals AS p
ON sp.grantee_principal_id = p.principal_id
WHERE permission_name = 'VIEW SERVER STATE'


--after some inserted lines...
SELECT 
p.[name],
sp.permission_name,
sp.state_desc, 
sp.class_desc
FROM sys.server_permissions AS sp
JOIN sys.server_principals...

What SP, CU are you on with SQL Server 2016? And are you specifying maxtransfersize? There were some issues with TDE and backup compression, the gist of which are explained...

I'm using Firefox - hit the link from the code editor box as well as the link you posted. No problems.

I just tried with IE - no problems there.

Sue

I just clicked on the link for BBCodes tag reference and it's fine, page is there, not defunct, no timeout

Sue

It's a 24 byte pointer by default:

https://www.sqlservercentral.com/forums/topic/lob-pointers-am-i-stupid#post-1354313

Microsoft SQL Server 2012 Internals: Special Storage

Sue

How the grouping and aliases works is correct but in this case you are grouping by columns that do exist. The example is the same as doing it without the...

I don't remember reading anything about RCSI, just that you can't enable snapshot isolation on the report server database.

But if the blocking is related to session data - such as...

I don't know if it's necessarily more or less overhead using SSIS and CDC, some of that really depends on the workload, activity on the tables. It can be a...

Thanks for posting that. Everyone has different needs and I think we all forget that there often is not a "one size fits all". Glad you figured out something that...

Your very welcome - glad it's all working now. And thanks for posting back!

Sue

If you restore the system databases, master might have whatever configuration was changed. Might. It depends on whatever was changed.

Sue