An alternative for Microsoft's STRING_SPLIT function that will work on SQL Server 2012 and higher.
The function is an inline table-valued function (or sometimes called a parameterised view) so it can be used just like a view or a table but needs parameters. It generates a single-column table of datetime2 with rows differing by any multiple of any of the dateparts that SQL Server provides.
Can be useful when inserting a lot of data into a table.
A TVF to select prime numbers
This table valued function will quickly find the prime factors of any number up to 10 trillion
This stored procedure will truncate a table even when other tables have FKs referencing columns in it. It drops the Fks, truncates the table, re-creates the FKs
A fast table valued function to generate a list of prime numbers within the range specified by the parameters.
Reports on the data and log file sizes and space used within files for each database on a servers. It also includes the free space on the drive where the file is located.