Understanding database recovery models in SQL Server
A recovery model is a database configuration option that determines the type of backup that one could perform and provides...
2018-04-11
785 reads
A recovery model is a database configuration option that determines the type of backup that one could perform and provides...
2018-04-11
785 reads
Tonight, April 11th starting at 6PM, the Baton Rouge SQL Server User Group will hold its monthly meeting. The Baton Rouge .Net User Group does the same at the...
2018-04-11
19 reads
Tonight, April 11th starting at 6PM, the Baton Rouge SQL Server User Group will hold its monthly meeting. The Baton...
2018-04-11
321 reads
SQL Server 2017 In-Database Machine learning has brought the analytics closer to the data. It is now convenient to do...
2018-04-11
976 reads
[read this post on Mr. Fox SQL blog] Recently we had a requirement to perform SQL Spatial functions on data that was stored in Azure SQL DW. Seems simple...
2018-04-10
26 reads
[read this post on Mr. Fox SQL blog]
Recently we had a requirement to perform SQL Spatial functions on data that...
2018-04-10
648 reads
What are the tools you love to use? What are the tools that maybe need a little sharpening? What tools do you have that maybe you wish were the...
2018-04-10
15 reads
What are the tools you love to use? What are the tools that maybe need a little sharpening? What tools...
2018-04-10
382 reads
This month’s T-SQL Tuesday is brought to you by Jens Bestergaard – the subject is Essential SQL Server tools, the original...
2018-04-10
1,107 reads
I am proud to present an in-person presentation for the New England SQL Server Users Group entitled “Level Up Your...
2018-04-10
276 reads
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...
This is my late response to T-SQL Tuesday #204. I almost always forget about...
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