Published onNovember 30, 2022The server principal is not able to access the database under the current security context in SQL ServerSQLCode-SnippetsResolution for Error The server principal is not able to access the database under the current security context in SQL Server
Published onAugust 8, 2022Aggregate Product in SQL ServerSQLCode-SnippetsCalculate Product in SQL server
Published onApril 18, 2022SQL Server Database PartitioningSQLCode-SnippetsPartition SQL Server Tables with File Groups
Published onMarch 2, 2022Delete Millions of Rows in a Table in SQL ServerSQLCode-SnippetsDelete Millions of Rows in a Table in SQL Server using
Published onDecember 23, 2021Find Tables by Column names in SQL ServerCode-SnippetsSQLSQL query to find referencing Tables by column name
Published onDecember 22, 2021Drop all tables in a specific schemaCode-SnippetsSQLSQL query to Drop tables in a schema
Published onDecember 21, 2021Find Database size in SQLCode-SnippetsSQLSQL query to find database size
Published onSeptember 23, 2021Integer Division Result in Decimal in SQL serverSQLSQL-SERVERGet the Decimal result from deviding Integers in SQL Server
Published onSeptember 1, 2021READ UNCOMMITTED transaction isolation level and NOLOCK in SQL serversqlSQL-serverREAD UNCOMMITTED transaction isolation level and NOLOCK in SQL server