STORPORT: Reading an ETL trace
One of the things I enjoy most is diagnosing storage latency. I honestly couldn’t tell you why I enjoy it...
2018-03-05 (first published: 2018-02-19)
3,742 reads
One of the things I enjoy most is diagnosing storage latency. I honestly couldn’t tell you why I enjoy it...
2018-03-05 (first published: 2018-02-19)
3,742 reads
If you’re in Chicago on March 17 and have some free time, why not check out all the cool kids?...
2018-02-19
260 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
Let’s say you have some obscure list of career goals for the year and one of those is to be...
2017-11-09
329 reads
I last posted about changing a table without changing a view that represents the table and how this may affect...
2017-10-03
375 reads
I had a fairly puzzling issue today, which took a few minutes to figure out. Some time ago I created...
2017-10-02 (first published: 2017-09-25)
2,802 reads
Databases are platforms that are designed to securely store and retrieve your data. Perhaps that’s why they’re called a data...
2017-09-22
429 reads
For those that don’t know, I live in Texas. Been here all my life. There are two main things north...
2017-09-15 (first published: 2017-09-11)
1,631 reads
In case you missed the first post on this topic, you can read it here: SQL Server: SARGability. This post...
2017-09-12 (first published: 2017-09-07)
1,781 reads
Continuing the comparison between these two database giants, we dive into the substring function. If you’ve been working with databases...
2017-09-05 (first published: 2017-08-23)
7,292 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