Should you update stats for your SQL Server database?
Statistics on database objects are very important to the SQL Server engine optimizing execution plans and running at the most...
2018-11-06
325 reads
Statistics on database objects are very important to the SQL Server engine optimizing execution plans and running at the most...
2018-11-06
325 reads
Was honored to speak to fellow SQLSaturday Organizers at the PASS Summit SQLSat organizer meeting on Tuesday. Here's an outline, detail and links to some of the things I...
2018-11-06
19 reads
So, this month’s T-SQL Tuesday topic is to think about a non-SQL Server technology that we want to learn.
For me,...
2018-11-15 (first published: 2018-11-06)
2,168 reads
As a follow-up to my blog Azure Archive Blob Storage, Microsoft has released another storage tier called Azure Premium Blob Storage (announcement). It is in private preview in US East...
2018-11-06
22 reads
As a follow-up to my blog Azure Archive Blob Storage, Microsoft has released another storage tier called Azure Premium Blob Storage...
2018-11-16 (first published: 2018-11-06)
2,556 reads
Come see my inaugural presentation at the Lexington PASS User Group meeting, Tuesday, Nov 13th, at 6:30 PM at the Blue Stallion Brewing Co. Azure Data Studio [pptx 6MB]
2018-11-06
55 reads
What a whirlwind year this has been! I’m thrilled to invite you to my sessions at this year’s PASS Summit,...
2018-11-06
79 reads
This post is a response to this month’s T-SQL Tuesday #108 prompt by Malathi Mahadevan. T-SQL Tuesday is a way...
2018-11-15 (first published: 2018-11-06)
2,715 reads
This post is a response to this month's T-SQL Tuesday #108 prompt by Malathi Mahadevan. T-SQL Tuesday is a way for the SQL Server community to share ideas about...
2018-11-06
13 reads
This post is a response to this month's T-SQL Tuesday #108 prompt by Malathi Mahadevan. T-SQL Tuesday is a way for the SQL Server community to share ideas about...
2018-11-06
12 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