How To Recondition Batteries
These days we are all looking for ways to save money and even to help the
environment. If you came across this site you are most...
2018-04-24
106 reads
These days we are all looking for ways to save money and even to help the
environment. If you came across this site you are most...
2018-04-24
106 reads
On May 18 we will be presenting a half-day of PowerShell learnin', right before SQL Saturday Dallas! Read up and...
2018-04-24
351 reads
I enjoy themes, and when I ran across the SQL Prompt Treasure Island, I had to take a few minutes...
2018-05-04 (first published: 2018-04-24)
2,519 reads
My company’s internal conference is in a couple of weeks, so this seems like a good time to have a quick rant about some presentation failings I’ve seen over...
2018-04-24
30 reads
My company’s internal conference is in a couple of weeks, so this seems like a good time to have a...
2018-05-04 (first published: 2018-04-24)
2,391 reads
dbachecks has seen the light about two months ago. As I'm writing this blog post, the module counts with more...
2018-05-03 (first published: 2018-04-24)
1,988 reads
Creating copies of your Azure SQL Database is a common and relatively simple process. You can issue a TSQL statement...
2018-04-24
364 reads
SQL Server recovery models define when database transactions are written to the transaction log. Understanding these models is critical for...
2018-05-03 (first published: 2018-04-24)
2,993 reads
Watch this week's video on YouTube
SQL Server recovery models define when database transactions are written to the transaction log. Understanding these models is critical for backup and recovery purposes...
2018-04-24
23 reads
Watch this week's video on YouTube
SQL Server recovery models define when database transactions are written to the transaction log. Understanding these models is critical for backup and recovery purposes...
2018-04-24
20 reads
By Steve Jones
“Most overnight successes – in fact any significant successes – take at least 5...
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...
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