Performance Basics: Key lookup operator and query optimization
One of the most basic things to improve performance in our queries is using indexes, but this doesn't mean that...
2018-02-14
578 reads
One of the most basic things to improve performance in our queries is using indexes, but this doesn't mean that...
2018-02-14
578 reads
One of my goals for 2018 is to expand the reach of my blog.
As a blogger starting out I had...
2018-02-14
332 reads
For TSQL Tuesday #99, @AaronBertrand gave us an invitation to write about something we’re passionate about outside of SQL Server. As a community we spend a lot of time digging into nerdy...
2018-02-13
33 reads
This month Aaron Bertrand (b | t) has given us a Dealer’s Choice on the T-SQL Tuesday topic. I’m of course going...
2018-02-13
149 reads
It’s hard to believe that we have reached T-SQL Tuesday #99 already. This month’s host is Aaron Bertrand (blog|@AaronBertrand), and...
2018-02-13
783 reads
In this module you will learn how to use the Brick Chart by MAQ Software. The Brick Chart provides a...
2018-02-27 (first published: 2018-02-13)
2,529 reads
Database maintenance does not have to be expensive. There are free tools out there that will make your life easier. Of...
2018-02-22 (first published: 2018-02-13)
3,194 reads
A common problem when looking at execution plans is attributing too much meaning and value of the costs of operators. The percentages shown for operators in query plans are...
2018-02-13
35 reads
A common problem when looking at execution plans is attributing too much meaning and value of the costs of operators.
The...
2018-02-22 (first published: 2018-02-13)
2,268 reads
So this month’s T-SQL Tuesday invitation comes from Aaron Bertrand. It’s a non-technical post this month as he asks us...
2018-02-13
834 reads
By Steve Jones
“Most overnight successes – in fact any significant successes – take at least 5...
This is my late response to T-SQL Tuesday #204. I almost always forget about...
By Steve Jones
I was experimenting with CHOOSE() recently after I was asked a question. In a...
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