Calculate Length - Most Advanced UOC
This function is used to calculate the actual unit of conversion for length.
2015-02-06 (first published: 2014-12-15)
888 reads
This function is used to calculate the actual unit of conversion for length.
2015-02-06 (first published: 2014-12-15)
888 reads
2015-02-05 (first published: 2013-03-22)
4,517 reads
Useful script in cases where auditors would like to know roles for each user in each database of an instance as well as the status of associated logins.
2015-02-03 (first published: 2015-01-25)
3,021 reads
This function is used to calculate the actual unit of conversion for volume.
2015-01-30 (first published: 2014-12-16)
855 reads
Run this stored procudure to update statistics for those SQL Server databases where you have permission
2015-01-27 (first published: 2015-01-08)
1,280 reads
This script is useful to remove SQL backup files except latest one for same day from Backup Path.
2015-01-26 (first published: 2014-12-12)
1,130 reads
This function is used to calculate the actual unit of conversion for power.
2015-01-23 (first published: 2014-12-16)
887 reads
This script is useful to copying latest backup files from job Backup path during Instance/Database Migration
2015-01-21 (first published: 2014-12-15)
1,009 reads
This function is used to calculate the actual unit of conversion for time.
2015-01-19 (first published: 2014-12-15)
1,051 reads
This function is used to get the particular string occurences count from the given input string.
2015-01-16 (first published: 2014-12-16)
1,145 reads
Once upon a time I had a series about some cool stuff in Snowflake:...
By Steve Jones
“Most overnight successes – in fact any significant successes – take at least 5...
Comments posted to this topic are about the item Why Successful SQL Server Backups...
Comments posted to this topic are about the item Adding Bits II
Comments posted to this topic are about the item An Unlimited Token Budget
I have a table, dbo.bittest, where I am testing an application response. This has this structure:
CREATE TABLE [dbo].[BitTest] ( [insertdate] [datetime] NULL CONSTRAINT [DF__BitTest__insertd__300F11AC] DEFAULT (getdate()), [a] [bit] NULL ) ON [PRIMARY] GOMy application runs this code:
INSERT dbo.BitTest
(
insertdate,
a
)
VALUES
(DEFAULT, true)
GO
See possible answers