How do I rename a column?
Everyone makes mistakes right? And sometimes you create an object and decide later that you messed up and need to...
2016-04-18
481 reads
Everyone makes mistakes right? And sometimes you create an object and decide later that you messed up and need to...
2016-04-18
481 reads
I ran into an interesting problem early this month. I was spinning up an Azure VM with SQL Server 2016...
2016-04-18
565 reads
Continuation from the previous 81 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
Previously, I have blogged about about the...
2016-04-16
630 reads
Thanks for attending my session on window functions in TSQL. I hope you learned something you can take back and...
2016-04-16
474 reads
Microsoft announced SQL Server 2016 Release Candidate 3 Evaluations
Benefits of SQL Server 2016 Release candidate 3:
Enhanced in-memory performance provide up...
2016-04-16
174 reads
I have been really busy lately with articles, podcasts and so forth. Lately I have been working on 2 public...
2016-04-16
161 reads
?????
(“MARR-hah-bah”, Arabic: Hello)
This year takes me to yet another part of the world:
I have been invited to speak at THE...
2016-04-15
556 reads
2016-04-15
461 reads
Brief Description
Temporal tables allow automated change tracking of a table directly in to a history table which can be queried...
2016-04-15
87 reads
By Steve Bolton
…………Since I’m teaching myself as I go in this series of self-tutorials, I often have only a vague...
2016-04-25 (first published: 2016-04-15)
1,696 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