SQL Server “Denali”: Installing SSAS Multidimensional vs Tabular Mode
As I play with the recently released CTP3 of SQL Server Denali, I wanted to point something out about installing SSAS, since...
2011-07-15
1,939 reads
As I play with the recently released CTP3 of SQL Server Denali, I wanted to point something out about installing SSAS, since...
2011-07-15
1,939 reads
Microsoft has released the final build of SQL Server 2008 R2 SP1. It includes fixes from SQL Server 2008 R2 RTM Cumulative Updates 1 through...
2011-07-14
1,359 reads
When you open a SQL Server Integration Services (SSIS) package in SSIS Designer or add components to a package, SSIS...
2011-07-13
2,600 reads
CTP3 of SQL Server Code Name “Denali” was made available for download this morning. You can download the 32-bit and...
2011-07-12
2,262 reads
If you are using environment variables in SSIS when using package configuration, chances are you will run into a situation...
2011-07-11
2,125 reads
If you are new to Business Intelligence (BI) and learn best by watching videos and “playing”, then this course is...
2011-07-08
5,228 reads
Another whitepaper to add to your “to read” list: SQL Server 2008 R2 Analysis Services Operations Guide
This white paper describes...
2011-07-06
1,048 reads
Project “Crescent” is a new interactive data exploration and visual presentation experience coming in the next version of SQL Server, code-named “Denali”. It will...
2011-07-05
1,394 reads
Juneau is the code name for the new SQL Server Development Tool (SSDT), to be released along with the next...
2011-07-01
1,275 reads
I have always wondered if queries against a SSAS cube while it is processing would be forced to wait the...
2011-06-29
2,612 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