How I designed my VMware vSAN based Home Lab
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2018-01-24 (first published: 2018-01-15)
2,658 reads
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2018-01-24 (first published: 2018-01-15)
2,658 reads
I had an interesting issue last week. I had to rename non-domain (Workgroup) SQL Server Virtual Machine in Azure. The server...
2018-01-25 (first published: 2018-01-15)
7,293 reads
I decided to go to the SQL Saturday at Nashville this year to get some good learning and networking in...
2018-01-15
450 reads
Management of the database is very much essential in today’s date and for doing this, there is a need to...
2018-01-15
3,294 reads
Over the last couple of weeks I’ve been looking at various different locations around Dublin as my tenancy in the...
2018-01-15
279 reads
With technology expanding in both complexity and quantity, the task to name each component and functions of a technology product...
2018-01-24 (first published: 2018-01-15)
1,730 reads
Did you know that items in the Object Explorer can be dragged and dropped into a query window? This can...
2018-01-14
320 reads
We’re all used to using the clipboard in Windows programs. You copy something into it with Ctrl+C, and paste it...
2018-01-13
406 reads
This is day 2 of the Advent of Code 2017. If you want to read about the puzzles, start with...
2018-01-13
891 reads
(2018-Jan-13) You never know how the weather will behave itself, especially when the temperature gets dramatically changed from +10 to -10...
2018-01-23 (first published: 2018-01-13)
1,853 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