SQL Saturday 828 - T-SQL Basics: Coding for performance
A great experience!Thanks to all the atendess to my session about T-SQL, for being my first time as a speaker...
2019-02-16
156 reads
A great experience!Thanks to all the atendess to my session about T-SQL, for being my first time as a speaker...
2019-02-16
156 reads
If you have SQL Server Integration Services installed on your server, and you left the default configurations a table named sysssislog is created on MSDB database, it contains logging entries...
2019-02-11
34 reads
I’m very thrilled to announce that I will be participating as speaker in this year’s SQL Saturday #828 event in Guatemala...
2019-02-05
168 reads
I’m very thrilled to announce that I will be participating as speaker in this year’s SQL Saturday #828 event in Guatemala city!This will be my first time as a speaker...
2019-02-05
21 reads
Graphic representation of the difference between 0 and NULL
Image taken from 9gag.comAccording to database theory, a good RDBMS must implement...
2019-01-30
1,476 reads
Graphic representation of the difference between 0 and NULLImage taken from 9gag.com
According to database theory, a good RDBMS must implement a marker to indicate "Missing or inapplicable information".SQL Server...
2019-01-30
30 reads
You need a lot of hard work for success!2018 was a good year for me in a lot of areas...
2019-01-21
261 reads
You need a lot of hard work for success!
2018 was a good year for me in a lot of areas of my life both personal and professional (the birth...
2019-01-21
21 reads
You can maintain and deploy code easilySource control is a vital part of IT work, since it is used to...
2019-01-09
3,513 reads
You can maintain and deploy code easily
Source control is a vital part of IT work, since it is used to track changes over software and documents, with two main...
2019-01-09
32 reads
Recently, in an attempt to thwart leechers (1990s kids will know), I added some...
Once upon a time I had a series about some cool stuff in Snowflake:...
By Steve Jones
“Most overnight successes – in fact any significant successes – take at least 5...
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