Get Data experience from Excel to Power BI and SQL Server Analysis Services 2017
(2018-Jan-20) It has been a long journey for the Excel data integration tool Power Query from its early version as...
2018-01-20
1,138 reads
(2018-Jan-20) It has been a long journey for the Excel data integration tool Power Query from its early version as...
2018-01-20
1,138 reads
If you have a database with hundreds (or thousands) of objects, finding the one that you are looking for in...
2018-01-20
146 reads
If you have a database with hundreds (or thousands) of objects, finding the one that you are looking for in...
2018-01-20
429 reads
I'm thrilled to announce that one of my proposals has been chosen to be presented in Guatemala's SQL Saturday that will be held on February 3rd at the Francisco...
2018-01-20
12 reads
In this module you will learn how to use the Bubble Chart Custom Visual by Akvelon. The Bubble chart allows...
2018-01-19
975 reads
Snippets allow you to store and easily reuse TSQL code snippets. To use a snippet, just right-click in the query...
2018-01-19
225 reads
Snippets allow you to store and easily reuse TSQL code snippets. To use a snippet, just right-click in the query...
2018-01-19
382 reads
I'm thrilled to announce that one of my proposals has been chosen to be presented in Guatemala's SQL Saturday that...
2018-01-19
145 reads
This is day 4 of the Advent of Code 2017. If you want to read about the puzzles, start with...
2018-01-19
438 reads
I really like the dbatools project. This is a series of PowerShell cmdlets that are built by the community and...
2018-01-19
508 reads
This is my late response to T-SQL Tuesday #204. I almost always forget about...
By Steve Jones
I was experimenting with CHOOSE() recently after I was asked a question. In a...
By DesertDBA
I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it...
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