curious of what statistics io would say on both cases - specifically segments read / skipped which will be an output when table/index is a columnstore.

on this case I don't...

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

Stanley bot - 1 spam post every 5 min. ARGHH!!

great explanation

should this be created as an article instead?

Lordy... there's a "bot" running with the handle of "Stanley" and it's posting spam every 5 minutes.  Between that and another bot that was active only for a while,...

if your source is a file then just split it on the file definition by setting up the file with comma delimited as column separator, quoted

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 6 years, 2 months ago by frederico_fonseca.
• This reply was modified 6 years, 2 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...