IT Dev Connections 2017
The IT Dev Connections conference was in San Francisco, CA this week. While I did not spend any time as a tourist, I did mingle with attendees and speakers....
2017-10-25
13 reads
The IT Dev Connections conference was in San Francisco, CA this week. While I did not spend any time as a tourist, I did mingle with attendees and speakers....
2017-10-25
13 reads
This is my first post where I utilize an hybrid cloud, item that I personally find very interesting and useful so expect more posts like this to come.Microsoft Azure...
2017-10-25
32 reads
If you have worked with me or are a frequent reader of my blogs or a frequent attendee of my...
2017-10-25
531 reads
This is more for my benefit in the future, but hopefully it can help someone else too. We recently had...
2017-10-25
4,513 reads
Next week is the PASS Summit. I’m so excited about it I could pop. Part of why I’m excited is...
2017-10-25
326 reads
One of the things I’ve been able to implement to help with performance is changing from Update Statistics Synchronous to...
2017-11-07 (first published: 2017-10-25)
2,045 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-10-25
1,189 reads
Every now and again you have a database where you don’t necessarily need the data. It can easily be re-loaded...
2017-10-25
1,188 reads
The IT Dev Connections conference was in San Francisco, CA this week. While I did not spend any time as...
2017-10-25
398 reads
Hello,
This post is intended to show you all the steps you will need to follow when you setup a transactional replication, in fact the first 5 steps are one...
2017-10-25
30 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