open the file with a hex editor and see what the values are - likely they are (were) in a codepage that you aren't using and therefore it seems wrong.

put...

CXPACKET is not bad on its own - it may only be an indication that some queries are going parallel when they don't need/or could work better serially.

so those cxpacket...

I called him out on the fact that he had 4 threads asking exactly the same thing - he didn't like it

https://www.sqlservercentral.com/forums/topic/ssrs-rendering-format-excel-change -- I made the comment on...

I called him out on the fact that he had 4 threads asking exactly the same thing - he didn't like it

https://www.sqlservercentral.com/forums/topic/ssrs-rendering-format-excel-change -- I made the comment on this one

https://www.sqlservercentral.com/forums/topic/changing-excel-download-rendering-format

https://www.sqlservercentral.com/forums/topic/changing-the-excel-rendering-format

https://www.sqlservercentral.com/forums/topic/change-excel-download-column-format-to-text

regarding https://www.sqlservercentral.com/forums/topic/writing-a-line-for-each-day-of-month

can someone post a link to an older thread the OP created that does what it's asking (again) to be given to them.

older thread is https://www.sqlservercentral.com/forums/topic/how-do-i-write-a-record-for-each-day-in-a-date-range

I can't reply as...

anyone has any ideas regarding this https://www.sqlservercentral.com/forums/topic/deadlock-related-to-autocreateqpstats

its the standard sql 2012 spam - next post from the OP will be a "i got this" with a spam link

you talking about power bi report server on prem or Power Bi service on cloud? if on prem scheduling is the same as with SSRS (PBIRS is a superset of...

dup post - see replies in https://www.sqlservercentral.com/forums/topic/bulk-insert-problem-for-cav-file-2

without you giving us the sp and the exact lines where it is happening we can't really help you other than telling that the most obvious error is that your...

on my script, after the first line

$domain = Get-ADDomain -Current LocalComputer

add your code

File = "F:\Temp\GroupsInput.txt" #File must contain one group per line with no qualifiers, like quotes.

$group = ""

$groups =...

the code I gave above show you how to do it - just adapt to your needs.

your try/catch would need to be done differently as it needs to be outside the variable assignment

Constant variables should also be set outside of loops - that is the case...

it all depends on one's needs - but normally checkdb is done once a week instead of daily.

as for checksum - its advisable to have it assuming your server can...

one thing for you to do is to add compression to the backup - it will speed it up and will reduce the size of files as well.

depending on how...