Connect is dead! Long live feedback.azure.com!
After years of having to deal with Connect – the feedback platform of Microsoft – it is announced a successor has been...
2017-12-18
1,155 reads
After years of having to deal with Connect – the feedback platform of Microsoft – it is announced a successor has been...
2017-12-18
1,155 reads
DBCC CHECKDB has the ability to perform parallel checking of objects. However, it absolutely depends on the edition of SQL...
2017-12-18
327 reads
tl;dr: When using a windows or active directory authenticated id you do not put the username or password into your...
2017-12-18
723 reads
We’re all creatures of habit, and work more efficiently when we know exactly where to find the tools we need....
2017-12-18
348 reads
I remember being thoroughly baffled in grade school by word problems. How in the world was I supposed to translate...
2017-12-18
374 reads
T-SQL Tuesday is a monthly blog party started by respected SQL Guru Adam Machanic. I was honored with hosting this...
2017-12-18
830 reads
Dynamic Data Masking (DDM) is new feature of SQL Server 2016. DDM helps in preventing unauthorized access to sensitive data....
2017-12-18
1,027 reads
The SQL Server community is just awesome. I can’t say that enough. I may sound like a broken record when...
2017-12-17
387 reads
Shawn Melton MVP and dbatools contributor last week had an issue running SQL Server on Linux inside of Windows Subsystem for Linux.
Error trying to configure #sqlLinux on the openSUSE...
2017-12-16
20 reads
Shawn Melton MVP and dbatools contributor last week had an issue running SQL Server on Linux inside of Windows Subsystem...
2017-12-16
1,015 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