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)
678 reads
Can be useful when inserting a lot of data into a table.
2019-02-26 (first published: 2019-02-14)
913 reads
2018-11-30 (first published: 2017-04-01)
751 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)
314 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)
631 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)
360 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,365 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,266 reads
In my home lab I have an Ubuntu virtual machine that runs both SQL...
By Arun Sirpal
I am not sure when this became available but for Azure SQL Database 150...
When studying Azure one of the things you’ll be asked to learn is the...
Comments posted to this topic are about the item Is Data the Future of...
Hi, How do you share execution plans. Save the plan and share the .sqlformat...
I'm using AlwaysOn synchronous replica. User issues an update on primary via SSMS. In...
Ask SSC