Happy new year 2018 to all!
From SQL Guatemala, we wish you a happy new year 2018.
We hope this new year brings you joy and zero:...
2017-12-30
336 reads
From SQL Guatemala, we wish you a happy new year 2018.
We hope this new year brings you joy and zero:...
2017-12-30
336 reads
A very interesting feature was recently added to SQL Server Management Studio 17.4 (SSMS): The new SQL Vulnerability Assessment.
What is...
2017-12-12
166 reads
To check the available advanced options configured at instance level in SQL Server, you need to use the sp_configure system...
2017-11-24
45,601 reads
I have recently obtained the certification Microsoft Certified Solutions Associate: SQL Server 2012/2014.
I began with this path almost 2 years...
2017-11-20
110 reads
I am sharing today a SQL Script to quickly check on an instance which databases are in mirrored and their...
2017-11-10
6,798 reads
In the new Project deployment model for SQL Server Integration Services, a new SQL Server database is used to provide...
2017-11-06
289 reads
One useful sentence when you need to add data to an existing table from an external source or database, and...
2017-10-06
430 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