you to know there is a thing called google don't you?

from the thing above the following are 2 results

https://www.sqlskills.com/blogs/joe/hunting-down-the-origins-of-fetch-api_cursor-and-sp_cursorfetch/

https://blog.sqlauthority.com/2015/01/10/sql-server-what-is-the-query-used-in-sp_cursorfetch-and-fetch-api_cursor/

Many times the best way to ensure that Devs do what is required is to pick up some of the bad SQL's and rewrite them so that they behave well...

if not for the weight (and price) Alienware Area15 would be top choice.

In my case I have a lenovo Yoga 920-13IKB (i7 4 core, 16 GB ram, 1TB SSD)...

duplicate post https://www.sqlservercentral.com/forums/topic/change-password-for-service-account-for-sql-agent-in-active-active-cluster

answer given there

no need to pass anything as a parameter.

In each database just setup a synonym pointing to the corresponding log db and on your code you just use the synonym in...

not a problematic file at all - fixed positions for all columns so its easy to process.

Do NOT use the import wizard - you need to manually process the file...

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

again you talk bollocks - OP is not worried about, neither does he/she cares, about how SQL decides to store the data - what matters, and it is a significant...

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...