Adaptive Query Processing and Automatic Tuning - Introduction - 1
SQL Server 2017 and Azure SQL Database are being touted as the self learning, artificial intelligent database. One of the...
2017-11-12
544 reads
SQL Server 2017 and Azure SQL Database are being touted as the self learning, artificial intelligent database. One of the...
2017-11-12
544 reads
Here are my top 5 reasons why I thing SQL Server on Linux is Legit!
SQL Server on Linux is Fast – Earlier this year SQL Server on Linux posted...
2017-11-12
8 reads
Here are my top 5 reasons why I thing SQL Server on Linux is Legit!
SQL Server on Linux is Fast – Earlier...
2017-11-12
878 reads
Just a quick one today. TL;DR: Remove yourself from some unnecessary AD groups.
If you've ever received the message "login failed...
2017-11-24 (first published: 2017-11-12)
3,398 reads
Last week I listened to a podcast from one of my best friends in the sql community – Kendra Little. In...
2017-11-23 (first published: 2017-11-11)
2,012 reads
The query execution plan is a map of work which SQL Server is going to perform to execute a query....
2017-11-22 (first published: 2017-11-11)
7,185 reads
I know we are living in a world where phones and other devices with advanced biometric authentication have been increasingly...
2017-11-10
341 reads
Thanks to everybody who attended my webcast Troubleshooting SQL Server Connection Issues yesterday. If you missed it, the recording will...
2017-11-10
647 reads
On the plane home from PAS Summit I was sat next to someone who had also attended and when he...
2017-11-27 (first published: 2017-11-10)
1,571 reads
I am sharing today a SQL Script to quickly check on an instance which databases are in mirrored and their...
2017-11-10
6,796 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