SQL Homework – October 2017 – Sample/Test Database(s)
Last month your homework was to set up your own lab. Now it’s time to put a sample database or...
2017-10-02
440 reads
Last month your homework was to set up your own lab. Now it’s time to put a sample database or...
2017-10-02
440 reads
You have the ability to actually pause SQL Server, if you are in SQL Server Management Studio (SSMS), you might...
2017-10-02
380 reads
Last week I asked the following question on twitter: –
I had a load of responses from a lot of DBAs...
2017-10-02
293 reads
This is related to my previous post about installing things on my Private-Hosted agent that I use for my VSTS...
2017-10-02
285 reads
My new course “LFCE: Linux Service Management – HTTP Services” in now available on Pluralsight here! If you want to learn about the course, check out the trailer here or if you want to...
2017-10-01
35 reads
My new course “LFCE: Linux Service Management – HTTP Services” in now available on Pluralsight here! If you want to learn about the course,...
2017-10-01
522 reads
This post is linked to my post about hosting VSTS private agents . I had recently upgraded my Visual Studio environment...
2017-10-01
508 reads
I started my IT career twenty years ago as a VB and C developer, wandered into C++ for a bit,...
2017-09-30
360 reads
“Trusted Assemblies”, a new feature starting in SQL Server 2017, is a means of whitelisting Assemblies that one feels pose...
2017-10-09 (first published: 2017-09-29)
2,340 reads
It’s not stable until Service Pack 1…
Are you at a company that doesn’t install a new version of SQL Server...
2017-09-29
780 reads
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...
By DesertDBA
I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it...
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