SQL Server 2008 and SQL Server 2008 R2 - OUT of SUPPORT July 2019
Both SQL Server 2008 and SQL Server 2008 R2 go out of extended support with Microsoft in July 2019. That’s...
2019-01-02
197 reads
Both SQL Server 2008 and SQL Server 2008 R2 go out of extended support with Microsoft in July 2019. That’s...
2019-01-02
197 reads
As we open 2019, I thought I’d take a moment to reflect on the past year.
Blogging 2018 was my biggest year of blogging yet! I published 28 posts and...
2019-01-02
11 reads
I have been in a serious relationship for more than 12 years. My partner in this relationship has brought me joy through the years, but lately, I feel like...
2019-01-01
19 reads
I have been in a serious relationship for more than 12 years. My partner in this relationship has brought me...
2019-01-11 (first published: 2019-01-01)
3,212 reads
A few days ago I was surprised to learn from Aaron Bertrand of SentryOne that he was selecting me as...
2019-01-01
1,010 reads
A few days ago I was surprised to learn from Aaron Bertrand of SentryOne that he was selecting me as Community Influencer of the Year for 2018.
Aaron states that...
2019-01-01
12 reads
A few days ago I was surprised to learn from Aaron Bertrand of SentryOne that he was selecting me as Community Influencer of the Year for 2018.
Aaron states that...
2019-01-01
14 reads
I know, I know....#OMGShrinkingIsBadDontEverDoThatOrElseEtcEtcEtc
We all know that there are simply times you have to shrink some files. There are risks...
2019-01-14 (first published: 2019-01-01)
595 reads
One of the underused troubleshooting and performance tuning techniques is to validate the application session settings. Things can work fabulous inside of SSMS, but run miserably inside the application.
Related...
2019-01-01
41 reads
One of the underused troubleshooting and performance tuning techniques is to validate the application session settings. Things can work fabulous...
2019-01-01
452 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