CISL 1.1.0: cstore_doMaintenance (Columnstore Maintenace Solution Explained)
After the initial release of the SQL Server Maintenance Solution in CISL 1.1.0, I felt that a separate blog post...
2016-01-24
653 reads
After the initial release of the SQL Server Maintenance Solution in CISL 1.1.0, I felt that a separate blog post...
2016-01-24
653 reads
I did my presentation on automated restores for the second time, changed a few things. It was/is a presentation with...
2016-01-22
658 reads
Late posting, so reduced notes!
Speaker party was good. Room was loud when full due to wood walls and nothing to...
2016-01-22
637 reads
How secure are your databases?
No, not your network. Just your databases. If your company is like most, the strongest security...
2016-01-22
778 reads
Recently, I wrote about how to get started with SQL Server change tracking, and I demonstrated a design pattern I...
2016-01-22
2,683 reads
It’s that time of year, planning for PASS Summit 2016. We’ve already put out the Call for Volunteers, which closes...
2016-01-22
394 reads
Here is an overview of the articles I published in the final quarter of 2015:
Integrated Logging with the Integration Services Package...
2016-01-22
503 reads
Earlier this month, my friend Tim Ford (b|t) proposed an idea:
A 2016 challenge to technical bloggers: 1 introductory level blog...
2016-01-21
451 reads
I worked in an Agile team in 2000 and we deployed changes to our web platform every Wednesday for over...
2016-01-21
534 reads
Rule "Microsoft .NET Framework 3.5 Service Pack 1 is required" failed.
This is a common problem and relatively easy fix for...
2016-01-27 (first published: 2016-01-21)
1,511 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