Mitch Wheat Mitch-Wheat

9 followers · 1 following

Perth, Australia
https://mitchwheat.com/

View GitHub Profile

Recently created

Least recently created

Recently updated

Least recently updated

Mitch-Wheat / gist:abcec4c9297096fa05c2f7ba5b5be750

Created August 21, 2025 05:42 — forked from metaskills/gist:893599

A Copy Of sp_MSforeachtable Stored Procedure For Azure, Uses sp_MSforeach_worker


	CREATE proc [dbo].[sp_MSforeachtable]
	@command1 nvarchar(2000), @replacechar nchar(1) = N'?', @command2 nvarchar(2000) = null,
	@command3 nvarchar(2000) = null, @whereand nvarchar(2000) = null,
	@precommand nvarchar(2000) = null, @postcommand nvarchar(2000) = null
	AS
	declare @mscat nvarchar(12)
	select @mscat = ltrim(str(convert(int, 0x0002)))
	if (@precommand is not null)
	exec(@precommand)

Mitch-Wheat / CalculateSkew.sql

Last active October 23, 2024 03:32

Perform a skew analysis

	SET ANSI_NULLS ON
	GO
	SET QUOTED_IDENTIFIER ON
	GO

	-- Note: * Does not use Welford's numerically stable one-pass.
	-- This should not be a problem in the majority of cases.
	--
	-- Can be run for all tables' columns:
	-- exec dbo.CalculateSkewness NULL, NULL, NULL, 50, 0

Mitch-Wheat / Script-out-all-indexes-in-a-database.sql

Last active September 11, 2024 19:32 — forked from LitKnd/Script-out-all-indexes-in-a-database.sql

	/*****************************************************************************
	MIT License, http://www.opensource.org/licenses/mit-license.php
	Contact: [email protected]
	Copyright (c) 2018 SQL Workbooks LLC
	Copyright (c) 2024 Mitch Wheat
	Permission is hereby granted, free of charge, to any person
	obtaining a copy of this software and associated documentation
	files (the "Software"), to deal in the Software without
	restriction, including without limitation the rights to use,
	copy, modify, merge, publish, distribute, sublicense, and/or

Mitch-Wheat / Move Database Files.sql

Created May 17, 2021 04:35 — forked from FlogDonkey/Move Database Files.sql

For moving Database Files to new location. Does a copy, so some cleanup is necessary. Accepts a single Database, or runs for *all* databases. In testing, it took about one minute for each 10GB of DB size, so plan accordingly accordingly. There is a list of excluded databases, allowing you to precisely target databases.

	DECLARE @WorkingSQL VARCHAR(8000)
	,@NewPath VARCHAR(8000) = 'G:\SQL Data\' /* Root location to move files */
	,@TargetDatabase sysname = '%'; /* Specify a singular database, or % for All Databases */

	SET NOCOUNT ON;

	/* Enable xp_cmdshell */
	EXEC sys.sp_configure 'Show Advanced Options', 1;
	RECONFIGURE;