A varchar(MAX) STRING_SPLIT function for SQL 2012 and above
An alternative for Microsoft's STRING_SPLIT function that will work on SQL Server 2012 and higher.
2021-03-11 (first published: 2021-03-05)
672 reads
Jonathan Roberts
A varchar(MAX) STRING_SPLIT function for SQL 2012 and above
An alternative for Microsoft's STRING_SPLIT function that will work on SQL Server 2012 and higher.
2021-03-04
59 reads
A varchar(MAX) STRING_SPLIT function for SQL 2012 and above
An alternative for Microsoft's STRING_SPLIT function that will work on SQL Server 2012 and higher.
2019-12-05 (first published: 2019-02-28)
9,322 reads
A DateRange Table Valued function
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.
2019-08-29 (first published: 2019-08-20)
1,839 reads
Disable or rebuild all nonclustered indexes on a table
Can be useful when inserting a lot of data into a table.
2019-02-26 (first published: 2019-02-14)
2,528 reads
2018-11-30 (first published: 2017-04-01)
820 reads
Table Valued Function to factorize numbers up to 100 trillion
This table valued function will quickly find the prime factors of any number up to 10 trillion
2017-04-26 (first published: 2017-04-06)
334 reads
Truncate a table that has foreign keys referencing its columns
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
2017-04-14 (first published: 2017-03-28)
678 reads
Table Valued Function to return a range of prime numbers
A fast table valued function to generate a list of prime numbers within the range specified by the parameters.
2017-04-12 (first published: 2017-03-30)
370 reads
Get file sizes of database files and free space on disk
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.
2016-03-10 (first published: 2015-07-23)
3,978 reads
Blogs
Data Saturday #8–Southwest US
By Angela-Henry
I am very excited to announce that I will be speaking for Data Saturday...
Data Weekender v3.1
By Angela-Henry
I am super excited about this new version of Data Weekender, coming up on...
Thanks Kathi and Mala
By Steve Jones
I have to thank Kathi and Mala for putting on the WIT Mental Health...
Forums
Checking Up on Vendors
Comments posted to this topic are about the item Checking Up on Vendors, which...
SQL 2016 - Need help with complex calculations based on paycodes - New Changes
Hello Friends, Posting this for help as the client made more requirement changes. I...
Daily Autocheck for SQL instances
[System.Data.Sql.SqlDataSourceEnumerator]::Instance.GetDataSources() | SELECT ServerName | Format-Table -HideTableHeaders The above code is not returning all...
Ask SSC