Search Results

If you accidentally execute a long-running operation that you want to cancel, and the SSMS client doesn't seem to accept the cancellation, then the database engine is likely involved in a large rollback, to restore the original state. Run this to identify the...

If you come across the need to purge many records from a datatable, and doing so will result in a large rollback snapshot, you can split the deletion into chunks that will execute much faster and with less resources. Use something like this: SET NOCOUNT ON; ...

Here's a list of what datatypes that Entity Framework uses to store .NET datatypes in a couple different database engines. .NET Datatype SQL Server PostgreSQL SQLite Comments bool bit boolean INTEGER byte tinyint smallint (Postgr...