Managing SQL Server Transaction Log File
Overview
In our previous section we have discussed how to create an audit trigger in SQL Server and how it helps...
2018-01-29
1,765 reads
Overview
In our previous section we have discussed how to create an audit trigger in SQL Server and how it helps...
2018-01-29
1,765 reads
This post is about the honor and experience of speaking at PASS Summit not once (2016) but twice (2017).
I recently...
2018-01-29
400 reads
2017 was an awesome year for SQLDusty.com! Thank you to all of the readers and visitors that stopped by to...
2018-01-29
413 reads
[read this post on Mr. Fox SQL blog] Recently I had a requirement to collate and briefly compare some of the various methods to perform SQL Server backup for...
2018-01-28
32 reads
[read this post on Mr. Fox SQL blog]
Recently I had a requirement to collate and briefly compare some of the...
2018-01-28
1,146 reads
Over the last several weeks, we have been making several changes to various settings in SSMS. Now that you have...
2018-01-28
405 reads
Houston, We Have a Problem
We are living in a crazy world. And it just gets more and more crazy all...
2018-01-28
884 reads
When you are performance tuning code, you will frequently examine the execution plans to see what is happening. As you...
2018-01-27
471 reads
Earlier this week the folks at PASS reached out to last year’s speakers asking us to share a story of...
2018-01-27
145 reads
I’m proud to announce that I will be speaking at PowerShell + DevOps Global Summit 2018 on the conference runs from April 9th 2018 through April 12th 2018. This is...
2018-01-27
10 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