UNDERCOVER TOOLBOX: Get Details of All Open Transactions
It was 3am in the morning and I was asleep and enjoying a delightful dream (I knew it was a...
2018-02-07
474 reads
It was 3am in the morning and I was asleep and enjoying a delightful dream (I knew it was a...
2018-02-07
474 reads
I’ve said before that backups are at once one of the easiest things DBAs do, one of the most important,...
2018-02-15 (first published: 2018-02-07)
1,828 reads
I was using a query on one of my local SQL Servers where I wanted to know what logins were...
2018-02-07
1,103 reads
I am so thrilled to have the opportunity to expand my writing with my first Simple-Talk article posted. Simple- Talk is technical journal and...
2018-02-07
327 reads
Last week Docker announced a feature that I’ve been looking forward to for a while: –
And sure enough, when I...
2018-02-07
1,447 reads
So, I just got finished with a SQL Server Reporting Services (SSRS) scale-out deployment, based largely on this step-by-step guide. Things mostly went...
2018-02-06
432 reads
This article is an effort to dissect the output of the sp_spaceused stored procedure.
Introduction
Understanding the database usage internals and the growth trends...
2018-02-06
472 reads
I recently wrote a post on the BlueGranite blog called Improving Screen Reader Accessibility in Power BI Reports. It contains...
2018-02-13 (first published: 2018-02-06)
2,074 reads
In the last half of 2017, I decided to run a tSQLt course and went down the route of putting...
2018-02-16 (first published: 2018-02-06)
3,051 reads
In the last half of 2017, I decided to run a tSQLt course and went down the route of putting together a free 12-week email course. The intention was...
2018-02-06
17 reads
By Steve Jones
“Most overnight successes – in fact any significant successes – take at least 5...
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...
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