Modify the ORM code.

Create a more meaningful index(s)

Throw hardware at it

Complain to the vendor. Repeatedly

Have you downloaded Bret...

• This reply was modified 4 years, 3 months ago by Michael L John.

The designError table is small and there are no keys or indexes. I can't see the code that's issuing the call for the delete(package software) .. I can't change...

You are using developer edition in production?

Developer edition corresponds to enterprise edition.

This is the MS link https://go.microsoft.com/fwlink/?linkid=853016

Does anyone else immediately think of the Monty Python skit every time they see or hear the word “spam”???

Wonderful spam, marvelous spam.

Hello,

One of the full back up job failed and it was triggered again. The DB's size is big so it takes couple of hrs to complete. My questions is...

I don't quite know how I feel about this person, though I haven't looked through many posts. I do see them thanking people, which is (sadly) all too...

fn_dump_dblog

This link may get you started.  https://www.mssqltips.com/sqlservertip/3555/read-sql-server-transaction-log-backups-to-find-when-transactions-occurred/

However, it seems like setting up an extended event to capture what you need, and reading that, may be a better option.

one of those I refuse to help now - ignores suggestions and fails to supply requested information...

Hello,

I have a basic question and looking for an answer. For a 2 node alwaysOn setup, do we consider the replica IP addresses as private or public ip addresses?...

Duplicate Posts

https://www.sqlservercentral.com/forums/topic/summary-report-4

https://www.sqlservercentral.com/forums/topic/summary-report-3

Please do not cross-post

Using named instances is totally supported as replicas.

In relation to the listener only there is no documentation or support as far as I know for using Listener\Instance.  All the...

There is NO official support for using instance names with the listener.

Will it work with an instance name as part of the connection string, most probably.

Will a patch /...

thank you for reply

it not return my expected result above

please run that query

SELECT GivenPartNumber_Non,  vcompanyid int, SourceType

FROM #notmappedsources

WHERE SourceType = 484456

it will give rows extra as

MNH32...

Perhaps I wasn't clear.

@eddie-2 Wuerch, yes what we typically have done in the past with existing FCI's is get everything setup and ready, replicate the data to new instance,...

Un-install Symantec anti-virus? Or make sure you have excluded anything related to this instance from being scanned?