Database Corruption and IO Errors
A quick way to have your day turned upside down and rip your gut out with nerves and anxiety is...
2018-01-18
1,021 reads
A quick way to have your day turned upside down and rip your gut out with nerves and anxiety is...
2018-01-18
1,021 reads
I was going through my demo for the South Coast User Group meeting tonight and decided to add some details...
2018-01-18
395 reads
Warning: If during reading this post, you feel like a lot of bells started ringing – I might have written about...
2018-01-18
437 reads
@adedba Adrian Buckman has been working hard and has put all of our scripts up on Github https://github.com/SQLUndercover/UndercoverToolbox
2018-01-18
378 reads
Have you ever wished for a visual indicator that you are connected to a production instance of SQL Server? Well,...
2018-01-17
158 reads
Have you ever wished for a visual indicator that you are connected to a production instance of SQL Server? Well,...
2018-01-17
392 reads
Dynamic management views (DMVs) and dynamic management functions (DMFs) are system views and system functions that return metadata of the system...
2018-01-17
919 reads
By now you have probably seen the news about a major flaw in the design of CPUs from all major...
2018-01-17
343 reads
There are thousands, tens of thousands, probably hundreds of thousands of blogs out there on all sorts of topics. If...
2018-01-17
327 reads
A few weeks ago, I wrote Part 1 and 2 of this series, which was a beginner’s guide to Always...
2018-01-17
791 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