Customizing Statistics Histogram in SQL Server 2019
The use of statistics in SQL Server is tightly embedded in the query optimizer and query processor. The creation and maintenance of statistics is usually handled by the SQL...
2019-04-01
234 reads
The use of statistics in SQL Server is tightly embedded in the query optimizer and query processor. The creation and maintenance of statistics is usually handled by the SQL...
2019-04-01
234 reads
Good morning, today is 1st April. Maybe it is a good time to say that for example SQL Server was acquired by its main competitor on the market? No,...
2019-03-31
100 reads
By Steve Bolton …………As I discussed in more depth in the last three articles (not counting last month’s digression into Fisher Information, which is out of numerical order), theoreticians...
2019-04-11 (first published: 2019-03-30)
607 reads
One of the good things, when we have new clients, is that sometimes they have needs that you never heard before. This does not necessarily mean that they are...
2019-04-11 (first published: 2019-03-29)
1,160 reads
The Short Answer? (In at least a couple of places) When I first learned about the DRU, I was very excited about the possibilities. I began to play with...
2019-03-28
39 reads
When you start a Power BI project, you need to decide how and where you should store the data in your dataset. There are three “traditional” options: Imported Model:...
2019-03-28
49 reads
Midlands PASS in Columbia, SC will welcome Microsoft Data Platform MVP Matt Gordon on April 2, 2019. Our meet and greet starts at 5:30 PM with the presentation beginning...
2019-03-28
21 reads
When you drop a database from a SQL Server instance the underlying files are usually removed. This doesn’t happen however if you set the database to be offline first,...
2019-03-27
74 reads
Heads up for SQL Server on Linux folks using availability groups and Pacemaker. Pacemaker 1.1.18 has been out for a while now, but it’s worth mentioning that there was...
2019-03-27
44 reads
The SQL in the City Summits are back for 2019, and we’ve got more scheduled than every before. You can see the complete list on our event page, and...
2019-03-27
156 reads
Recently, in an attempt to thwart leechers (1990s kids will know), I added some...
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