SQL #57–A one-liner query with PARTITION BY
What can be done in SAS must be possible in SQL
A friend of mine is a data professional in marketing data...
2015-01-22 (first published: 2015-01-17)
10,471 reads
What can be done in SAS must be possible in SQL
A friend of mine is a data professional in marketing data...
2015-01-22 (first published: 2015-01-17)
10,471 reads
If learning SQL is in your New Year Resolution, then you will be happy to read this post.
We all make...
2015-01-09
1,059 reads
ROLLUP, CUBE, and GROUPING SETS Operators have been around since SQL Server 2005. These operators are extensions of the GROUP...
2015-01-05 (first published: 2014-12-31)
8,647 reads
It’s hard to believe that it’s been 5 years since my first ever post, in which I simply spelled Business Intelligence. Thanks...
2014-12-31
1,098 reads
OLEDB is the native client for SQL Server. Every SSIS developer is familiar with how to use it. Almost every...
2014-12-23 (first published: 2014-12-17)
7,887 reads
When we design a database, we usually need to do an estimate on the size of the database based on the...
2014-12-19
1,117 reads
The Analysis Services Performance Guide from bunch of Microsoft Analysis Services experts have been updated since 2005 edition for 2008 R2...
2014-12-14
1,510 reads
MSOLAP is a native OLE DB provider for Analysis Services
A common task during ETL is to process the OLAP dimensions and the...
2014-12-13
3,126 reads
Now we know how to find all the calculation scripts in a cube by querying the DMV $SYSTEM.MDSCHEMA_MEASURES.
MDX #43–Find a MDX...
2014-11-21 (first published: 2014-11-14)
5,741 reads
In SQL, NULL means undefined value
Any SQL programmer can tell you that zero is not NULL, NULL is not zero, and...
2014-11-18 (first published: 2014-11-12)
22,740 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