Twilight TimeZone: Handling Time in Your App Architecture at SQLSaturday Baton Rouge
Thanks to everyone who joined my colleague Steve Schaneville and me for a presentation on date/time data architecture in modern...
2017-07-31
663 reads
Thanks to everyone who joined my colleague Steve Schaneville and me for a presentation on date/time data architecture in modern...
2017-07-31
663 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-08-21 (first published: 2017-07-31)
1,735 reads
I read a lot of self-help and improvement information. I’m always trying to hack my brain or my attitude to...
2017-07-31
357 reads
I read a lot of self-help and improvement information. I’m always trying to hack my brain or my attitude to...
2017-08-18 (first published: 2017-07-31)
1,918 reads
I’ve been teaching my 17 yr old SQL Server and other various topics. I have quite a bit of experience...
2017-08-18 (first published: 2017-07-31)
2,443 reads
I’ve always thought it would be fun to have a DBA themed magic 8-ball. Now you may not be aware...
2017-07-31
589 reads
In this Video tutorial we will look at creating a SQL Server database using both Management Studio and TSQL. We’ll...
2017-07-31
591 reads
Over the weekend I saw a few tweets about the role of the DBA. These tweets (and corresponding blog posts)...
2017-07-31
570 reads
Was working with a client who had an existing Availability Group, but did not have the RegisterAllProvidersIP setting enabled on...
2017-08-17 (first published: 2017-07-30)
21,738 reads
Continuation from the previous 108 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
Do you remember one of the major...
2017-08-16 (first published: 2017-07-30)
1,603 reads
This is my late response to T-SQL Tuesday #204. I almost always forget about...
By Steve Jones
I was experimenting with CHOOSE() recently after I was asked a question. In a...
By DesertDBA
I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it...
Comments posted to this topic are about the item Why Successful SQL Server Backups...
Comments posted to this topic are about the item Adding Bits II
Comments posted to this topic are about the item An Unlimited Token Budget
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