likely the standard method of inserting into a new table with the column being calculated at that stage, and then one of 2 options

1 - truncate source table (remove any...

did you try this?

WHILE @@FETCH_STATUS = 0
BEGIN
    SET @tableName = QUOTENAME(@tableName);
    -- SET @paramDefinition = N'@tblName NVARCHAR(255)'; -- not needed for...

• This reply was modified 3 months, 1 week ago by  frederico_fonseca.

as that table is partitioned, and depending on the volume you are deleting, it may be faster to switch out the partition of that date to a staging table, and...

Personally I approach these type of changes by first identifying which executions take the longest, then which queries within that take the longest looking through their ACTUAL explain plan and...

with a few exceptions Production data can easily be manipulated to remove/scramble any PII or similar data at which time none of it can be used if it is leaked...

Without a tool what are the options.

We have atleast 200+ instances and I would like a report which states whether the windows box is pingable, if the sqlinstance is...

do them on a per table basis if deemed needed -...

dup post - see replies on https://www.sqlservercentral.com/forums/topic/destination-table-condition-amount-0-3

again you keep failing to address how to ask for help here - and again you fail to understand that on this case only you can see what is wrong...

dup post - see replies on https://www.sqlservercentral.com/forums/topic/destination-table-condition-amount-0-3

• This reply was modified 3 months, 2 weeks ago by  frederico_fonseca.

That article is for SQL 2008. The servers are 2017 and I'm pretty sure SMO code doesn't work anymore in 2017.

EDIT: Even looking at the PowerShell options, it doesn't...

easy with SMO

https://www.mssqltips.com/sqlservertip/3675/using-smo-with-powershell-to-obtain-sql-server-job-information/

you just need to create a list of servers to extract from and do a foreach loop on that list to call the job function.

use it all the time - and our DBA team has a central server with CMS setup so it is available to all DBA's (and some snr developers/architects) as well.

in...

for that you will need to have a audit log table and a trigger on the table you need to monitor- no other way to do it (other then perhaps...

• This reply was modified 3 months, 3 weeks ago by  frederico_fonseca.

have a look at this https://www.sqlservercentral.com/forums/topic/sqlagentreaderrole-can-create-its-own-jobs-what-is-ms-thinking

SQLAgentReaderRole would be the role to use to allow them to view jobs - but as this gives also permissions to CREATE jobs...