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 onNovember 16, 2021Build SQL connection string in powershellPowershellCode-SnippetsBuild SQL connection string in powershell using SqlConnectionStringBuilder