Learning Goals–January Review
In December I participated in T-SQL Tuesday #97 and wrote a post about 2018 goals. I promptly spent two weeks...
2018-02-05
402 reads
In December I participated in T-SQL Tuesday #97 and wrote a post about 2018 goals. I promptly spent two weeks...
2018-02-05
402 reads
Wait statistics are a vital part of understanding what is causing your system to run slowly. Capturing them can be...
2018-02-14 (first published: 2018-02-05)
2,777 reads
This month let’s create some security!
Create logins: GUI 5 pts/Script 5 pts
Create a SQL login and a Windows authenticated login....
2018-02-05
316 reads
The Importance of Log Files in SQL Server
On the SQL server every day we perform many transactions and as we...
2018-02-05
3,477 reads
I’ve been incredibly lucky in my career. I’ve somehow managed to meet and become friends with highly talented people who...
2018-02-05
341 reads
I need a new social media profile picture.
That’s one of the most important (non-technical) conclusions I drew from my week at PASS Summit 2017. It seemed like everywhere I...
2018-02-05
13 reads
(2018-Feb-04) I've had a case working with very large data files as a source for my heat map visualizations in...
2018-02-04
736 reads
Re-Imagining the SSIS development environment.
oooh:
ahhh:
SSIS is a powerful and versatile tool for extracting, transforming and loading data into or out...
2018-02-04
561 reads
Re-Imagining the SSIS development environment.
oooh:
ahhh:
SSIS is a powerful and versatile tool for extracting, transforming and loading data into or out of SQL Server. The development environment, BIDS...
2018-02-04
10 reads
Re-Imagining the SSIS development environment.
oooh:
ahhh:
SSIS is a powerful and versatile tool for extracting, transforming and loading data into...
2018-02-04
93 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