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)
865 reads
Can be useful when inserting a lot of data into a table.
2019-02-26 (first published: 2019-02-14)
1,106 reads
2018-11-30 (first published: 2017-04-01)
765 reads
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)
316 reads
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)
637 reads
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)
362 reads
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,454 reads
This function converts an integer to its binary representation. e.g. 15 is converted to '00001111'
2015-04-29 (first published: 2014-02-24)
674 reads
This function counts the number of 1's in the binary representation of an integer.
2015-04-28 (first published: 2014-02-24)
446 reads
This article by Jonathan Roberts demonstrates how to use dynamic SQL and overcome its downsides.
2012-02-17 (first published: 2010-05-20)
27,487 reads
Yesterday in this post I described a method to correct permissions when upgrading a...
By Devin-Knight
Welcome back to my Power Platform Quick Tips series! In this second episode we...
Simple- Talk is technical journal and community hub from Redgate. This week I have the pleasure of...
Comments posted to this topic are about the item Numeric and Decimal, which is...
One of our machines is not able to connect to sql server It gives...
If I have been asked to change the SQL Server port from Dynamic to...
Ask SSC