323 pages of spam as of 3pm (gmt) saturday

today although I did some cleaning it was just to block them.

Got in this morning and had 150+ pages of spam. some of them with 250 posts

today was a busy day for spammers.

I've reported likely over 400 posts today.  92 of them from a single user, and a few others with 55  posts each.

really would like...

name won't matter - but the version of it must match the server version (unless changed in recent versions)

so on the download for PBIRS January 2026 you also have a...

would be great if you did bother to google for the error

https://www.sqlservercentral.com/forums/topic/ssis-warning-global-shared-memory/page/2

multiple explanations and a solution - and regardless you can and should ignore that warning/error - its only for...

declare @LastKnownRowVersion varbinary(8) = 0x00000000000007D3
SELECT * FROM YourTable
WHERE RowVersionCol > @LastKnownRowVersion;

but both varbinary and binary are the same - only difference is that (as per manual)

A...

use varbinary

@Grant - purpose is normally to use it as "what has changed since last time I did ETL..." so the last rowversion used is stored elsewhere - and can't...

Hi , i installed winscp on my pc, added it to GAC thru vs (i think a developer script) on my pc as well, and added a reference to...

Ola's index script DOES NOT allow for datacompression as a parameter.

while anyone can change it and allow for that to be supplied as a parameter, this is not desirable, nor...

easy to check - why not try it out instead of asking someone to confirm what you found - or read the code itself.

it depends.

• how frequently is the direct access. tooo many calls is a good pointer to bad application design (depending on application)
• is it doing...

its getting tiresome that you @semolina keep posting same information prior posts already gave, just for the sake of showing off. if you don't have new information to supply refrain...

see this link https://learn.microsoft.com/en-us/sql/relational-databases/tables/manage-retention-of-historical-data-in-system-versioned-temporal-tables?view=sql-server-ver17

scroll down to "Use custom cleanup script approach"

price should not be the reason - there are some free tools to use. and others (like EA from sparkx) isn't that expensive.

hum... I would query the client and see how they are loading the file (to whatever system) and what are the chars they consider NON UTF-8.

or is it that they...

• This reply was modified 3 months ago by frederico_fonseca.