tSQLt Course
In the last half of 2017, I decided to run a tSQLt course and went down the route of putting...
2018-02-06
246 reads
In the last half of 2017, I decided to run a tSQLt course and went down the route of putting...
2018-02-06
246 reads
In the last half of 2017, I decided to run a tSQLt course and went down the route of putting...
2018-02-06
304 reads
Have you ever used @@options? I haven’t typically needed this, but there are times that you might wonder what options...
2018-02-15 (first published: 2018-02-06)
2,202 reads
In this podcast I talk with Mike Rabinovici of Dimodelo Solutions about data being the new currency, the importance of showing...
2018-02-06
62 reads
In this podcast I talk with Mike Rabinovici of Dimodelo Solutions about data being the new currency, the importance of showing...
2018-02-06
515 reads
I am so excited, I was selected to speak at SQL Saturday Richmond on March 24, 2018, in Richmond, Virginia.
SQL...
2018-02-06
271 reads
I can finally breath a sigh of relief, my first time of presenting two sessions back to back is finally...
2018-02-06
263 reads
Waiting tasks quickly shows you where to look for the bottlenecks. This is only one of the many times that I...
2018-02-14 (first published: 2018-02-06)
2,921 reads
This weekend I caught up with Drew Furgiuele at SQL Saturday Cleveland and learned how to get involved with the...
2018-02-06
117 reads
Watch this week's video on YouTube
This weekend I caught up with Drew Furgiuele at SQL Saturday Cleveland and learned how to get involved with the open-source dbatools PowerShell module.
If...
2018-02-06
15 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