and... if using compression space used will vary a lot depending on the compression type and on the data.

used to be 3 per post - and when it happened all posts for that user would be gone (not sure what happened to the user on the background)

on old...

with wordpress forums I think you need to have one of the addins to manage users - may not be able to delete it, but you can block it (with...

Alias requires you to change EVERY single client - its clumsy and not desirable if it can be avoidable

If the old server is not going to be used then a...

have a look at some options here https://alternativeto.net/software/remote-desktop-connection-manager/

Thanks for the reference.

Oh, it's not my company, I've been brought in to consult on some other problems, and the use of the Version Store cropped up as part...

I would almost bet that someone "derived"...

well.... kind of no headers as such.. but for many such files you do have a "header" record with a particular fixed format, then "data" records with their own format(s),...

the old RTFM does come into place here - just looks like most don't like doing it nowadays.

https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2008-r2/ms345368(v=sql.105)?redirectedfrom=MSDN

and Always-On also uses version store.

On a different note - your company must...

• This reply was modified 5 years, 5 months ago by frederico_fonseca.
• This reply was modified 5 years, 5 months ago by frederico_fonseca.

this is a good read on this subject

https://docs.microsoft.com/en-us/sql/tools/configuration-manager/sql-server-browser-service?view=sql-server-ver15

and (although almost the same)  https://www.mssqltips.com/sqlservertip/1946/overview-of-the-sql-server-browser-service/

Depending on your exact setup you may disable it - I know we do for many of our...

yes it is the same thing...

that configuration manager reference there is to be executed on the SERVER where SQL Server is installed, not where you installed the client tools.

So unless you also intend in having...

or keeping the CTE change "and b.userID is null;" to "WHERE b.userID is null;"

I may be wrong - but installing POsh 5.1 should contain the automation namespace - and this will not be .net core

https://www.microsoft.com/en-us/download/details.aspx?id=54616

I think I have that working in one of my packages but through a start process e.g. new process kicked off which starts a new powershell instance.

if that works for...