Continuation from the previous 46 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/
This post is a continuation from the the post 44, where I...
2015-02-03 (first published: 2015-01-26)
5,783 reads
I wanted to find out how many SQL Saturday’s I’d spoken at and how I ranked with others. I got...
2015-01-26
955 reads
Commercial database systems like SQL server have many recovery mechanisms to restore data hardware or software failure. Checkpoints are part of such recovery mechanism.SQL Server Database Engine is programmed...
2015-01-26
34 reads
Commercial database systems like SQL server have many recovery mechanisms to restore data hardware or software failure. Checkpoints are part...
2015-01-26
15,143 reads
Omaha’s next SQL Saturday event, #397, is now live and scheduled for May 23rd, 2015, at Mammel Hall on the...
2015-01-26
676 reads
Parents, you know that feeling you get after you’ve brought home that brand new baby (or in my case, babies) where...
2015-01-30 (first published: 2015-01-26)
6,364 reads
Right():- This function returns the specified number of characters from the Right part of the given character string.Syntax:- Select RIGHT ( character_expression , integer_expression ) For example, the below query will...
2015-01-26
23 reads
I wanted to start this series in regards to impact players that go above and beyond in the SQL Community....
2015-01-26
588 reads
I was recently working on some code where I needed to be able to go from an EntitySet name to...
2015-01-26
233 reads
Every month SQL Judo (Russ Thomas) (b/t) challenges us to do his Monthly DBA Challenge. I’ve decided it would be...
2015-01-29 (first published: 2015-01-26)
6,314 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...
WhatsApp:0817819444 Jl. Pemuda No.3 C, Tawangsari, Leteh, Kec. Rembang, Kabupaten Rembang, Jawa Tengah 59217
WhatsApp:0817819444 Jl. Pemuda No.57B, Blora, Tempelan, Kec. Blora, Kabupaten Blora, Jawa Tengah 58211
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