Trust, or Verify – How FKs Can (or Cannot) Help Performance
Learn how trusted foreign keys (FK) can help or hurt performance.
2018-08-24 (first published: 2016-03-08)
6,970 reads
Learn how trusted foreign keys (FK) can help or hurt performance.
2018-08-24 (first published: 2016-03-08)
6,970 reads
In this level, Hugo Kornelis looks at how to rewrite your queries to best take advantage of batch mode.
2018-08-08 (first published: 2016-11-23)
3,868 reads
In this level, Hugo explains what batch mode execution is, how it differs from row mode execution, and what its limitations are.
2018-07-04 (first published: 2016-08-31)
4,219 reads
2015-12-14
1,489 reads
2015-12-07
1,391 reads
2015-11-30
1,333 reads
2015-11-19
1,645 reads
2015-11-13
1,380 reads
2015-11-09
1,640 reads
2015-11-03
1,814 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...
Comments posted to this topic are about the item 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