Performance Impacts of Partitioned Aligned Indexes
[read this post on Mr. Fox SQL blog]
Continuing on with my Partitioning post series, this is part 2.
The partitioning includes several major...
2015-05-12
705 reads
[read this post on Mr. Fox SQL blog]
Continuing on with my Partitioning post series, this is part 2.
The partitioning includes several major...
2015-05-12
705 reads
This is a T-SQL Tuesday that not only makes me smile, but makes my boss happy. In fact, I’m sure...
2015-05-12
821 reads
Thank you Cathrine Wilhelmsen for hosting this week’s #tsql2sday.
If I knew that this T-SQL Tuesday was going to be about...
2015-05-12
545 reads
By David Postlethwaite
Cloud Service Models
There are three main service models in the cloud. You will see these buzz words being...
2015-05-12
666 reads
I am extremely happy to share that I shall be delivering a workshop at the amazing SQLSaturday Cambridge on 10th...
2015-05-12
493 reads
Last week, I took the 70-461: Querying Microsoft SQL Server 2012 exam. I decided recently to try and achieve getting...
2015-05-12
808 reads
A big thank you to Cathrine Wilhelmsen (blog | twitter) for hosting this month’s TSQL2sday party. Monitoring is this month’s topic...
2015-05-12
583 reads
Alerts have been around for as long as I can remember, so some time before breakfast. That probably means you...
2015-05-12
1,167 reads
Per the post from Bill Graziano, if you want to vote in the 2015 election you have to make sure...
2015-05-11
313 reads
You know, these 1 hour sessions that are at most SQL Saturdays are just too short sometimes – you just get...
2015-05-11
578 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