Analysis Services: Solving Hierarchy Errors of Uniqueness
Multidimensional Cubes provide speed when it comes to retrieving aggregations that are important to business decisions. Being able to slice...
2016-03-16
580 reads
Multidimensional Cubes provide speed when it comes to retrieving aggregations that are important to business decisions. Being able to slice...
2016-03-16
580 reads
Working diligently as any good DBA might, you have established maintenance routines for each of the SQL Servers under your purview. Then a small problem occurs: Index Cannot Be...
2016-03-16
36 reads
Working diligently as any good DBA might, you have established maintenance routines for each of the SQL Servers under your...
2016-03-16
545 reads
[read this post on Mr. Fox SQL blog] When it comes to enabling data compression in SQL Server I suspect most people don’t do a lot of testing as to the impacts of...
2016-03-15
21 reads
[read this post on Mr. Fox SQL blog]
When it comes to enabling data compression in SQL Server I suspect most people don’t do a...
2016-03-15
589 reads
This is a reminder to compete the annual Business Intelligence product survey conducted by BARC Research. I’ve been participating in...
2016-03-15
468 reads
I spend a decent amount of time on the road, traveling to events. Last year I think I spent 50...
2016-03-15
569 reads
I’m sure you are aware of Microsoft Azure, but are you aware there is special version of Azure for U.S....
2016-03-15
724 reads
Have you ever had the need to query Active Directory right out of SQL Server using native TSQL? There are...
2016-03-15
157 reads
Have you ever had the need to query Active Directory right out of SQL Server using native TSQL? There are...
2016-03-21 (first published: 2016-03-15)
3,837 reads
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
This week I was at PASS Data Community Summit in Seattle, and I attended...
By James Serra
(This is the third post in a three-part series on how AI is changing...
Comments posted to this topic are about the item Pay for Performance, which is...
Comments posted to this topic are about the item Helping an English Student with...
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