Typing Alternative Characters
I tend to work in the US English world. I’m somewhat embarrassed to note that I really only know one...
2018-02-27
476 reads
I tend to work in the US English world. I’m somewhat embarrassed to note that I really only know one...
2018-02-27
476 reads
I was surprised to find out that a lot people hadn’t heard about the new join type, Adaptive join. So,...
2018-02-27
1,159 reads
You need something from the database admin. Maybe it’s permissions, maybe it’s code troubleshooting, or maybe it’s just that the database is...
2018-02-27
518 reads
Planning to Increase Cost Threshold for Parallelism
When administrating a SQL Server instance with multiple CPU cores and heavy workload, it’s...
2018-02-27
1,169 reads
Productivity is hard to measure when your work has no definite structure like a typical office job. You may operate...
2018-02-27
480 reads
There are times when you are writing a query while referencing another piece of information: the results of another query,...
2018-02-27
295 reads
There are times when you are writing a query while referencing another piece of information: the results of another query, a variable value, a webpage, etc...
If using two monitors...
2018-02-27
28 reads
If you’ve ever spent any time looking at execution plans you will have almost definitely noticed all the read counts...
2018-02-27
111 reads
Recently, I was working with the team and got stuck up with SQL Server Installation information. We got an urgent...
2018-02-27
17,675 reads
I frequently present at user groups, and always try to create a brand new presentation to keep things interesting. We...
2018-02-26
131 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