DAX IsFiltered Function
The DAX IsFiltered function returns True when <columnName> is filtered directly and false if there is no direct filter on...
2012-10-11
2,051 reads
The DAX IsFiltered function returns True when <columnName> is filtered directly and false if there is no direct filter on...
2012-10-11
2,051 reads
Right out of the box, SQL Server makes it pretty easy to grant SELECT, INSERT, UPDATE, and DELETE to all...
2012-10-10
13,621 reads
Last night a client tried to ruin a script to enable Read_Committed_snapshot on a SQL database. There were so many...
2012-10-10
581 reads
In my earlier post, we have discussed about GAM and SGAM Page and Data Page. In this postlet us discuss about...
2012-10-10
6,437 reads
In the 7th article of this series, I will discuss how to manage your partitions with XMLA. We will be...
2012-10-10
649 reads
Win Valuable Prizes!
Impress Your Friends!
This week we’re starting up a health and weight loss competition that I hereby dub #PASSGameOn,...
2012-10-10
979 reads
One week down and we are now 4-weeks from this years PASS Summit. Hopefully, you have already registered for the...
2012-10-10
1,143 reads
Do you think it’s a good idea to add UPDLOCK hint to the table which will be modified in an...
2012-10-10
1,471 reads
One trick I have learned from the folks on the Replication Support Team is how to proactively audit data changes...
2012-10-17 (first published: 2012-10-10)
2,955 reads
If you are trying to generate Uniqueidentifier/Newid() in SSIS data flow, you will soon realize that there is no out-of-the-box...
2012-10-16 (first published: 2012-10-10)
11,563 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