Generate a random number of children for each parent
I was asked an interesting question the other day.
Is it possible to get a different random number of rows...
2018-10-17 (first published: 2018-10-03)
2,069 reads
I was asked an interesting question the other day.
Is it possible to get a different random number of rows...
2018-10-17 (first published: 2018-10-03)
2,069 reads
On a previous post, we discussed what is an extended event (XE) and how to create one.
With the following T-SQL...
2018-10-03
296 reads
PowerBI is a powerful reporting solution for Business Intelligence for analytical reports, it is not meant to replace SSRS, the...
2018-10-16 (first published: 2018-10-03)
3,026 reads
Azure Data Factory V2 allows developers to branch and chain activities together in a pipeline. We define dependencies between activities as...
2018-10-16 (first published: 2018-10-03)
1,870 reads
As with most of my posts of late all examples here are using the StackOverflow SQL Server database that can...
2018-10-02
249 reads
As with most of my posts of late all examples here are using the StackOverflow SQL Server database that can...
2018-10-02
130 reads
As part of my job I manage a bunch of SQL instances for Development and Test.
Access is managed though Active...
2018-10-15 (first published: 2018-10-02)
2,359 reads
Is your company working on ways to become more environmentally friendly? Taking care of the environment is an important topic,...
2018-10-02
228 reads
Have you ever wanted SSMS to start and automatically and establish a connection to your DBA \ hub server and have...
2018-10-15 (first published: 2018-10-02)
7,915 reads
This week I had the opportunity to learn about dashboards, reports, and datasets in Power BI using the best kind...
2018-10-11 (first published: 2018-10-02)
3,011 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