there may be a misunderstanding of what you consider a NULL value on the column - if a Column is NULL then there is no char to replace at all...

what type of replication do you have setup ?

if SQL Server replication then only the tables you select for replication will be replicated.

If SAN replication then all objects on the...

AG = Availability Group

WCF = Windows Failover Cluster

for more info see https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/failover-clustering-and-always-on-availability-groups-sql-server?view=sql-server-2017

Adding to the above - if any one customer is "misbehaving" you can (and probably should on this situation) use Resource Governor to limit the use of server resources.

But unless...

Not sure about the correct answer to you so maybe others will give required feedback.

but why not drop the user completely and replace it with a GMSA instead? that way...

also take in consideration the SQL Server licensing - physical vs virtual isn't the same and having standard or enterprise also changes what you can do with it.

example using your...

Unless you already have a monitoring tool in place then there is nothing you can do to report past events

If you do have a tool then use it.

If not then...

what if it was the following?

Values (1, 12, '2019-09-01T07:00:00')
     , (1, 12, '2019-09-11T07:00:00')
     , (1, 11, '2019-08-15T07:00:00') -- one...

yes - that is what I said was wrong - both the 12/120 and the ()

It will depend on the version of SQL Server

If 2012+ then yes otherwise that db won't exist and will not prove that SSIS wasn't installed.

The only way to know for...

when the source data incorporates date ranges that span a few month they it is sometimes possible to analyse the data as part of the load process and see which...

not saying if code is right or wrong, neither would it matter for the interviewers.

It shows a good attempt at solving the issue even if syntax wise it could be...

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

you have 2 errors.

first the excel result is 2.2892064 and not 22.9 as you mention

second, and this is the important one, your formulas are not the same

last block on excel...

I would say that particular keywords of the create/alter index statement are part of that command definition, not part of the object that is object of the command

object static properties...

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

ok. thanks for the explanation.

Could you also confirm if when a single non mod flags a new thread does it flag it immediately? It seems to me that when I...