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 29, 2021The specified DSN contains an architecture mismatch between the Driver and Application.NetFixes-for-ErrorsFixing the issue of Error System.Data.Odbc.OdbcException ERROR [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application
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