Format decimal value to fraction using a tally table.
We use a tally table to find the appropriate denominator for a given decimal part of a number.
2014-04-29 (first published: 2014-04-07)
1,216 reads
We use a tally table to find the appropriate denominator for a given decimal part of a number.
2014-04-29 (first published: 2014-04-07)
1,216 reads
Extracting data with header information using PowerShell
2014-04-28 (first published: 2014-04-07)
1,519 reads
2014-04-24 (first published: 2014-04-05)
2,021 reads
usefull script for moving databases from one server to another
2014-04-23 (first published: 2014-03-29)
967 reads
2014-04-22 (first published: 2014-02-20)
2,223 reads
Backup all databases for an instance (complete, Differential or log of transactions)
2014-04-21 (first published: 2014-04-05)
1,102 reads
THis script will generate the Drop and create script for all user define table type
2014-04-18 (first published: 2014-03-25)
1,231 reads
2014-04-17 (first published: 2014-03-25)
1,353 reads
2014-04-14 (first published: 2014-03-18)
7,069 reads
The query will help to get the column level difference for 2 database(Like Prod and Dev database). This help us to verify what are the column changes has been done in dev environment after Prod deployment.
2014-04-10 (first published: 2014-03-11)
1,084 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