Predicates and Event Data
A predicate is a filtering mechanism used in SQL Server to target specific data when either querying or updating rows.
Related Posts:
Short Circuiting Your Session January 5, 2019
How To:...
2015-09-21
19 reads
Predicates and Event Data
At one time or another, a predicate has been the best friend or worst enemy of the data professional. If...
2015-09-21
729 reads
Where is my data stored?
Tables within SQL Server can contain a maximum of 8060 bytes per row. However even though columns are limited to...
2015-09-21
380 reads
Where is my data stored?
Tables within SQL Server can contain a maximum of 8060 bytes per row. However even though columns are limited to...
2015-09-21
657 reads
Zombie AD Groups
I spent something like 2 hours today trying to figure out how a particular user had access to one of...
2015-09-21
646 reads
Why I hate Pie Charts
The pie chart should be avoided at all costs. Why?
you can only display a limited number of slices (although that...
2015-09-21
562 reads
I'm alive!!!!
Hi all!
Sorry for long delay but i was a pretty busy preparing SQLSat
Now mission is accomplished and i'll return to...
2015-09-21
463 reads
XML Attribute VS Element Assignment when working with SQL
XML handling with aliases
I find it interesting the difference in behavior with querying XML between column assignment, and quoted alias...
2015-09-21
207 reads
Step by Step SSIS - Conditional Split Transformation TIP #117
In the series of Zero to Hero in SSIS this is our next post. In this post we will see...
2015-09-21
3,291 reads
Clustered Index and related Interview Questions
Since the day I wrote my first blog. My friends are eagerly waiting for just one topic. The Indexing. I...
2015-09-20
387 reads
Blogs
A New Word: Semaphorism
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
SQL Server Linux Container Images Got Smaller: Image Size and Startup Time Across Cumulative Updates
This week I was at PASS Data Community Summit in Seattle, and I attended...
Using AI to Build Semantic Models, Ontologies, and Fabric Data Agents
By James Serra
(This is the third post in a three-part series on how AI is changing...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Layanan BCA KCP Mahendradata Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. Mahendradatta Selatan No. 99 AX, Padangsambian, Kec. Denpasar Bar., Kota Denpasar, Bali...
Alamat Telp BCA KCP Sesetan Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. Raya Sesetan No.301, Sesetan, Denpasar Selatan, Kota Denpasar, Bali 80223
Question of the Day
Adding Bits I
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