What Are These Backup Settings All About?
I ran across a client the other day that had these Backup and Recovery options set like the picture below...
2017-11-08
887 reads
I ran across a client the other day that had these Backup and Recovery options set like the picture below...
2017-11-08
887 reads
Why use SQL Service Broker It enables you to execute SQL Statements faster and do the real work later. SQL Server...
2017-11-08
389 reads
Continuation from the previous 114 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
This blog post is dedicated to the...
2017-11-08
408 reads
Last weekI wrote about what is a contained database, the benefits and challenges, today as promised I'll show you how...
2017-11-08
269 reads
[read this post on Mr. Fox SQL blog] Recently I had a requirement to load streaming JSON data to provide a data feed for near real-time reporting. The solution streamed...
2017-11-07
24 reads
[read this post on Mr. Fox SQL blog]
Recently I had a requirement to load streaming JSON data to provide a...
2017-11-07
775 reads
Tricky triggers
In my last entry I noted that the performance of "instead-of" triggers can be tricky.
One of the reasons for...
2017-11-07
606 reads
I had a question from my good friend Andrew Pruski dbafromthecold on twitter or SQL Container Man as I call...
2017-11-07
659 reads
Today’s tip is a very basic functionality that comes with any SSMS (SQL Server Management studio), we are talking about...
2017-11-07
206 reads
Better late than never: The Analytics Platform System (APS), which is a renaming of the Parallel Data Warehouse (PDW), released an appliance update...
2017-11-07
1,057 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