Bad Query Performance Tips Rebutted
Once upon a time, someone, somewhere, wrote a list of bad query performance tips and they’ve been copied all over...
2018-11-20 (first published: 2018-11-12)
3,248 reads
Once upon a time, someone, somewhere, wrote a list of bad query performance tips and they’ve been copied all over...
2018-11-20 (first published: 2018-11-12)
3,248 reads
A long long time ago, I wrote a blog post showing how to create db_executor role in SQL Server. There...
2018-11-19 (first published: 2018-11-12)
1,840 reads
If you work with SQL Server on a daily basis, it is very likely you have a lot of custom...
2018-11-12
379 reads
This was the 20th PASS Summit, a decent milestone! Interesting to pause and think, what will the Summit look like...
2018-11-12
277 reads
A few weeks back I wrote Some Thoughts on How To Prepare to Serve on the PASS Board of Directors....
2018-11-20 (first published: 2018-11-11)
1,543 reads
Let’s get you started on your Kubernetes journey with installing Kubernetes on premises in virtual machines. Kubernetes is a distributed system, you will be creating a cluster which will have...
2018-11-11
19 reads
Let’s get you started on your Kubernetes journey with installing Kubernetes on premises in virtual machines.
Kubernetes is a distributed system,...
2018-11-11
1,246 reads
Hello folks, how are you today? It was a very comprehensive week and many of my friends returned home after...
2018-11-11
95 reads
Thank you all for your service!
I was fortunate to have attended PASS Summit again this year. As an added bonus...
2018-11-11
201 reads
As part of the PASS Summit conference session that Bob Pusateri and I are presenting right now called “Cosmos DB...
2018-11-09
197 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