Attracting Non-Technical Speakers to Your SQLSat Events
Fellow DBA and community leader Peter Shore of the Columbus SQL PASS UG and SQLSat Columbus OH asked me via Twitter, "What is the...
2017-12-04
400 reads
Fellow DBA and community leader Peter Shore of the Columbus SQL PASS UG and SQLSat Columbus OH asked me via Twitter, "What is the...
2017-12-04
400 reads
When I present or teach on a security topic, I take the time to cover the mindset of the adversary....
2017-12-13 (first published: 2017-12-04)
1,763 reads
In this module you will learn how to use the TreeViz Custom Visual. The TreeViz is a breakdown tree that...
2017-12-12 (first published: 2017-12-04)
1,758 reads
A few folks have asked: will auto-tuning and adaptive query plans mean the end of performance tuning jobs for SQL Server? In this week’s episode, I talk about why...
2017-12-04
31 reads
I ran across a post from a tester, wondering how to write a query for birthday months. This makes sense,...
2017-12-15 (first published: 2017-12-04)
1,951 reads
I know that when some people see AdventureWorks, their vision turns all red around the edges, their blood pressure spikes...
2017-12-04
382 reads
What is a graph database?
A graph is composed of two elements: a NODE (vertices) and an EDGE (relationship). Each node...
2017-12-04
807 reads
Last homework of the year. Last month was to create a view. This month it’s time to take a look...
2017-12-04
321 reads
One of the new features that we have with SQL 2017 is that you no longer need a Windows cluster to enable the AlwaysOn feature with SQL server (remember...
2017-12-04
66 reads
This is my first opportunity hosting a T-SQL Tuesday and am super excited!!T-SQL Tuesday is the brainchild of well respected SQL Guru...
2017-12-04
960 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