reading the manual is normally advisable as it does contain the information one is looking most of the of the times.

https://docs.microsoft.com/en-us/powershell/module/microsoft.powershell.utility/export-csv?view=powershell-7.2

using columnstore is potentially one of  your other issues - while it is GREAT for space saving and for aggregation style SQL it can perform badly for plain joins to...

Jeff - I do believe that the sample supplied with 2 digits and "." as separator  is only how its displayed and not how its stored.

I would query why that is a requirement - in a properly designed cube a good analysis tool that can accomplished that within the tool (SSAS or similar) using their...

and do be aware that Data Masking in SQL server can be broken very easily if you can do queries directly to the DB - so avoid at all cost.

you can download the older versions - see https://visualstudio.microsoft.com/vs/older-downloads/

note that limit is per database - nothing preventing the developer to have 20 databases - and the big tables each on their own databases, and a master/driver database with...

adding to this - the more complex queries are also using tables without ANY index at all - so lots of table scans (HEAPS to be more precise) - so...

do you mind running this again and ensuring that the dbname is correct

select snapshot_isolation_state
     , snapshot_isolation_state_desc
     , is_read_committed_snapshot_on
 ...

• This reply was modified 4 years ago by frederico_fonseca.

kindly keep this to a single thread - you have 3 threads all around the same issue for no real reason.

also a search on google immediately gives a results that...

Here's the next thing that could be a possibility... Run this code in the database where the table is at.

 SELECT is_read_committed_snapshot_on
   FROM sys.databases...

can you run the following - sp_spaceuses sometimes reports wrong sizes

select t.NAME as tablename
     , s.Name as schemaname
     ,...

no clustered index on that table? or columnstore?

if not then it is a a heap so see what the resulting size is after you issue "alter table [dbo].[SIData_222222_88_20211103_1436] rebuild"

if it does...

can be lots of things

• has file been processed - requires another table with list of files already processed (filename, time last written and similar)
• do filenames match expected pattern

...

why?? it is such a "wonderful" tool.. and so so easy to deploy and work with...