TSQL Tuesday #75 Round Up Redux
Okay so I already posted a round up post for this month. You can see it here. Tonight one of...
2016-02-24
446 reads
Okay so I already posted a round up post for this month. You can see it here. Tonight one of...
2016-02-24
446 reads
I’ll be giving a webinar for MSSQLTips.com on Thursday March 10, 2016.
The title is SQL Server BI Best Practices and its...
2016-02-24
700 reads
Continuation from the previous 76 parts, the whole series can be found at http://www.nikoport.com/columnstore/
I have written previously about SQL Server...
2016-02-23
699 reads
Today, thanks to a customer, I discovered one of those annoying little things that can really drive you nuts.
Basically, they were...
2016-03-01 (first published: 2016-02-23)
2,337 reads
This past weekend was SQL Saturday #478 – Albuquerque, and I was happy to have the chance to attend again. I...
2016-02-23
752 reads
This post, like last week’s, is based off the presentation I did to the DBA Fundamentals virtual chapter.
The request was...
2016-02-23
189 reads
This post, like last week’s, is based off the presentation I did to the DBA Fundamentals virtual chapter.
The request was...
2016-03-02 (first published: 2016-02-23)
2,370 reads
Continuing my blog from last week, Creating KPIs in SQL Reporting Services, I am now going to explain how to...
2016-03-01 (first published: 2016-02-23)
4,165 reads
As usual, the pager went off...
"Server is near 100% memory utilization - what is running?"
http://www.starshipearththebigpicture.com/wp-content/uploads/2015/09/red-alert-picard-300x228.jpgI saw when I signed on that...
2016-02-29 (first published: 2016-02-23)
7,892 reads
I have been wanting to write this for a long time, and finally got time to do it. Which is...
2016-02-29 (first published: 2016-02-23)
2,762 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