Working with Consultants
After being immersed into the consulting world again for 6 months now, I’ve gotten to work with clients in several...
2018-04-27
503 reads
After being immersed into the consulting world again for 6 months now, I’ve gotten to work with clients in several...
2018-04-27
503 reads
You may and should have monitoring in place to monitor state of your servers, services, jobs, critical and not critical...
2018-04-27
816 reads
An SQL Server Expert Thoughts : I would like to recommend my readers to use SysTools SQL LDF recovery software for viewing transaction log file of SQL Server 2016,...
2018-04-27
33 reads
An SQL Server Expert Thoughts : I would like to recommend my readers to use SysTools SQL LDF recovery software for...
2018-04-27
1,063 reads
Quick and easy backup for VisualSVN. Wraps the svnadmin.exe and performs a hotcopy of all repositories in the $source_path, dumping them to the $backup_path [crayon-5c98d5a77e81c224584330/]
2018-04-27
90 reads
2018-04-26
19 reads
This post is part 1 of a 3 part series…
Part 1 Grouping SetsPart 2 ROLLUP and CUBEPart 3 GROUPING and...
2018-04-26
123 reads
I’ve been in technology a long, long time (more than 2 decades). Over the years, I learned Access which took...
2018-04-26
1,206 reads
What needs to change? The challenge to explore is are there things in your current day to day that needs...
2018-04-26
517 reads
One of the most important roles of a database administrator is to constantly protect the integrity of the databases and...
2018-04-26
567 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