A really simple bug with SSMS
If you’re a long time IT professional or an occasional user of high or even low tech software you’ll know...
2016-09-28
552 reads
If you’re a long time IT professional or an occasional user of high or even low tech software you’ll know...
2016-09-28
552 reads
Up until SQL Server 2016, we had to write our own functions to split a CSV string into a table...
2016-09-15 (first published: 2016-09-08)
2,751 reads
I’m excited to be monitoring Kalen’s session on concurrency. The session is today and is titled “Locking, Blocking, Versions: Concurrency...
2016-09-07
357 reads
If I had a dollar for every CTE solution to a simple query in the forums (pick any SQL forum), I’d...
2016-08-27
785 reads
This will be my second time speaking at SQL Saturday in Dallas. My first was last year and it was...
2016-08-25
445 reads
This will be my first time speaking in Oklahoma on 8/27 in Oklahoma City. I’ve been to several customers there...
2016-08-16
524 reads
One of the top three performance killers for SQL Server is lack of processing power. I’d say that it’s second...
2016-08-18 (first published: 2016-08-11)
2,164 reads
I’ve been working with SQL Server for 18 years and over that long span I’ve seen a lot of different...
2016-08-10
637 reads
A bit of history
Long ago there were such things called diverters. The phone company used them so employees could dial...
2016-07-29
923 reads
I recently read an a blog on MSDN that covered new features for the query optimizer in SQL Server 2016....
2016-07-29 (first published: 2016-07-25)
2,040 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