Installing SSAS 2012
I don’t usually write posts like this but there have been a few substantial changes to how SSAS 2012 is...
2012-05-07
8,369 reads
I don’t usually write posts like this but there have been a few substantial changes to how SSAS 2012 is...
2012-05-07
8,369 reads
Enterprise Data Warehouse Architecture Options
Of course, your architecture depends on your business requirements along with technical, historical, and political factors....
2012-04-25
4,294 reads
Data growth is related to Moore’s law. As computers get faster and more powerful, we are using them to process...
2012-04-15
7,834 reads
The Kimball Approach
There are a lot of misconceptions about dimensional modeling and the Kimball approach to building a DW/BI system....
2012-04-08
58,781 reads
Most of my day-to-day work is currently centered around Microsoft’s Massively Parallel Processing Appliance call PDW (Parallel Data Warehouse). Many...
2012-04-02
1,862 reads
Building the Enterprise DW/BI System with SQL Server PDW
Most readers considering a Parallel Data Warehouse already have a data warehouse...
2012-03-25
4,434 reads
Columnstore Indexes for Fast DW
The SQL Server 11.0 release (2012) introduces a new data warehouse query acceleration feature based on...
2012-03-19 (first published: 2012-03-15)
4,065 reads
One of the most compelling features of the new SSAS Tabular Model is the ability to set the model’s Query...
2012-03-09
2,987 reads
<rant> One of the most frustrating things about working with the Microsoft BI Stack is after you go through all...
2012-03-02
9,353 reads
I was once asked in a job interview if I knew what a Cartesian/Cross Join was.
A more interesting question is:...
2012-02-19
2,753 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