When Best Practices Aren’t Best
Most everyone is familiar with the term best practices. This phrase describes an industry-specific design or methodology that can be...
2017-12-12
396 reads
Most everyone is familiar with the term best practices. This phrase describes an industry-specific design or methodology that can be...
2017-12-12
396 reads
Last year, I celebrated the holiday season by blogging daily during the 11 days leading up to Festivus, writing about...
2017-12-12
330 reads
“A-Bridged” – reducing reads – get it? I’m sorry you’re reading this. Photo by Jamie Street on UnsplashIn last week’s post, we went over how...
2017-12-12
223 reads
In last week's post, we went over how one of best ways to improve query performance was to reduce the number of reads that your query has to do.
Less reads...
2017-12-12
20 reads
TweetG’day,
Well, it’s T-SQL Tuesday time again -the blog party started by Adam Machanic (blog | twitter) and this month hosted by Mala Mahadevan. This...
2017-12-12
532 reads
This post is a response to this month’s T-SQL Tuesday prompt created by Mala Mahadevan. T-SQL Tuesday was created by...
2017-12-12
174 reads
This post is a response to this month's T-SQL Tuesday prompt created by Mala Mahadevan. T-SQL Tuesday was created by Adam Machanic and is a way for SQL users...
2017-12-12
16 reads
A very interesting feature was recently added to SQL Server Management Studio 17.4 (SSMS): The new SQL Vulnerability Assessment.
What is...
2017-12-12
166 reads
A while back you may have caught my blog post introducing the Power BI Chat Bot 9000. Since posting that...
2018-01-02 (first published: 2017-12-12)
1,354 reads
I’ve never been a fan of a GUI for DBA work. Give me a hand crafted script or a list...
2017-12-26 (first published: 2017-12-12)
1,673 reads
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...
By DesertDBA
I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it...
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