Finding the Default Path with dbatools
I really like the dbatools project. This is a series of PowerShell cmdlets that are built by the community and...
2018-01-19
508 reads
I really like the dbatools project. This is a series of PowerShell cmdlets that are built by the community and...
2018-01-19
508 reads
With the announcement of the recent security issues, namely Meltdown and Spectre, we at Denny Cherry & Associates Consulting have been...
2018-01-19
535 reads
I have written previously (here)about how to tell which database files have free space in them when your drive starts...
2018-01-19
3,767 reads
REPAIR_ALLOW_DATA_LOSS is the repair level, which is recommended by DBCC CHECKDB when the database is found in a corrupted state.SQL...
2018-01-19
3,277 reads
It’s been absolutely freezing here in Dublin this week. Been spending pretty much all time wrapped up indoors reading…
Discussing PASS...
2018-01-19
316 reads
In the human history, there was a huge drive (such an ambiguous meaning here) to get faster.
Maybe within our DNA...
2018-01-19
323 reads
You may have noticed that in many places in SSMS, you can create a new item and SSMS opens up...
2018-01-18
86 reads
You may have noticed that in many places in SSMS, you can create a new item and SSMS opens up...
2018-01-18
292 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2018-01-18
743 reads
A quick way to have your day turned upside down and rip your gut out with nerves and anxiety is to come in one day to find that users...
2018-01-18
23 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