Improving SQL Server Performance by using Instant File Initialization
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan, where you are getting week by week via email...
2014-02-21 (first published: 2014-02-18)
3,655 reads
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan, where you are getting week by week via email...
2014-02-21 (first published: 2014-02-18)
3,655 reads
Companies face specific challenges at each stage of their lives. This is a great article on why many sales organizations...
2014-02-18
578 reads
As a database professional, I get asked to review the health of database environments very often. When I perform these...
2014-02-24 (first published: 2014-02-18)
3,136 reads
TweetG’day All,
While I was writing my last blog post about the new SQL SERVER 2012 CHOOSE statement, it also came...
2014-02-20 (first published: 2014-02-18)
13,698 reads
Apache Hive is the de facto standard for SQL-in-Hadoop with more enterprises relying on this open source project than any...
2014-02-17
590 reads
A throwout bearing is a part of an automotive clutch system that temporarily disengages the engine from the manual transmission while shifting....
2014-02-17
455 reads
Toyota Hilux Claims Second Pole Position in Antarctic Race. Have you Hiilux’d?
via Toyota Hilux Claims Second Pole Position (2009).
2014-02-17
514 reads
Monochromatic photos are eye-catching and can bring out details we might miss in regular shots. You can share a single...
2014-02-17
481 reads
If you don’t have kids you might not get the title of the post, it’s part of the theme song...
2014-02-17
638 reads
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-02-20 (first published: 2014-02-17)
1,821 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