Creating a SQL Server Test Lab On Your Workstation – Part One, Installing The Domain Controller
One of the most useful tools to the DBA when we need to test new features, recreate a fault that...
2017-12-18
649 reads
One of the most useful tools to the DBA when we need to test new features, recreate a fault that...
2017-12-18
649 reads
The slides and demo scripts from today’s GroupBy session are now available on our GitHub repository
https://github.com/SQLUndercover/UndercoverToolbox/tree/master/GroupBy
Many thanks again for watching,...
2017-12-08
363 reads
Now I’m all for making my life easier and one thing that makes life easier for me is having a...
2017-11-27
543 reads
Ladies and Gentlemen, welcome to the main event of the evening. The SQL Undercover Smackdown Heavy Weight Championship of the...
2017-11-16
2,583 reads
So this month’s T-SQL Tuesday subject is a shout out and high-five to those people who have inspired or made a...
2017-11-14
328 reads
This months TSQL Tuesday subject is a shout out and high-five to those people who have inspired or made a contribution...
2017-11-14
715 reads
Hi Folks,
I’m the new guy that my two colleagues are still trying to convince to write my first blog post...
2017-11-14
475 reads
Recently I’ve been thinking about Python and whether it can be useful to the DBA as well as the data...
2017-10-30
410 reads
SQL Server tracks untrusted Foreign keys in sys.Foreign keys with a column called is_not_trusted, there may be a number of...
2017-10-24
206 reads
SQL Server’s integration of Python has been heavily marketed towards the machine learning and BI guys, but does it offer...
2017-10-18
1,235 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