usp_SQLServerCarpenter_Tools_Estimate_Cardinality
This procedure will estimate the cardinality of all the columns of the supplied table list. If the table list is not supplied (or supplied with NULL, the default value)...
2022-07-11
63 reads
This procedure will estimate the cardinality of all the columns of the supplied table list. If the table list is not supplied (or supplied with NULL, the default value)...
2022-07-11
63 reads
This procedure will list down all the indexes (Clustered as well Nonclustered Indexes) whose first key column having poor cardinality.
2022-07-11
61 reads
This procedure will list down all the nonclustered indexes, which includes key columns as that of the clustered index. It will also list the key columns of both –...
2022-07-11
53 reads
This procedure will generate SQL Code for Get and Put API's. This may be useful if you are developing your own data replication strategy to replicate data across multiple...
2022-07-11
90 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-07-08
54 reads
Last Updated on January 24, 2023 by John Morehouse In today’s modern world, virtualization is often used to help mitigate cost as well as to provide flexibility in scaling...
2022-07-08
40 reads
We added a solar system to the ranch as a way to hedge against future costs as well as require less energy from the utility. I don’t plan to,...
2022-07-08 (first published: 2022-06-24)
240 reads
This is the first in the series of tools and technologies that I use to deal with the loss of functionality in my hands and arms. Check out this...
2022-07-08 (first published: 2022-06-24)
355 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-07-07
23 reads
For two years and three months, since April 2020, I’ve posted a tweet saying “Good Morning!” on every workday. I think I missed one. I was late for a...
2022-07-07
54 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