The 5 Scariest Moments for a SQL Server Developer
While families and friends are scaring each other this Halloween week with stories of ghosts and ghouls, I thought it’d...
2018-11-08 (first published: 2018-10-30)
5,002 reads
While families and friends are scaring each other this Halloween week with stories of ghosts and ghouls, I thought it’d...
2018-11-08 (first published: 2018-10-30)
5,002 reads
Watch this week's video on YouTube
While families and friends are scaring each other this Halloween week with stories of ghosts and ghouls, I thought it'd be way scarier to talk...
2018-10-30
13 reads
Watch this week's video on YouTube
While families and friends are scaring each other this Halloween week with stories of ghosts and ghouls, I thought it'd be way scarier to talk...
2018-10-30
13 reads
Over the past few weeks I wrote a 3-part series on how to configure email alerts based on Perfmon Counters,...
2018-10-30
104 reads
(2018-Oct-29) There are only a few sentences in the official Microsoft web page that describe newly introduced activity task (Append Variable)...
2018-11-07 (first published: 2018-10-29)
12,619 reads
As DBA’s we are sometimes put in a rock and hard place when it comes to database performance. This situation...
2018-11-06 (first published: 2018-10-29)
4,561 reads
Introduction
In my last post. Step-by-Step: How to Trigger an Email Alert from a Windows Event that Includes the Event Details using...
2018-10-29
2,866 reads
I was recently asked if we are going to see performance differences if we explicitly drop temporary tables. I couldn’t...
2018-11-07 (first published: 2018-10-29)
4,006 reads
I’m always on the looking our excellent training, especially free training. Tim Mitchell, Microsoft Data Platform MVP, (twitter | website) has...
2018-10-29
282 reads
There is a fear that almost every blogger has to overcome. I’ll be honest, it pops up almost every time...
2018-10-29
328 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