WITH DATA_PURITY (from recent experience, the key to knowing if patching to 14.0.3015.40 was okay)
So there I am, all keen on keeping ahead of the latest security issue, as usual, whilst handling my patching...
2018-01-07
515 reads
So there I am, all keen on keeping ahead of the latest security issue, as usual, whilst handling my patching...
2018-01-07
515 reads
Do you have scripts that you need to run frequently, but every time you need to set some different parameters?...
2018-01-18 (first published: 2018-01-07)
1,583 reads
This non-technical post is about why I am leaving a technical company after working there for 17 + years.
If you are...
2018-01-07
535 reads
Have you ever had a long script that you are trying to scroll through? Do you wish that you could...
2018-01-06
590 reads
In this article I introduce you to some basics in regards to default behaviors and settings in tempdb along with some best practices. It is advisable to investigate from...
2018-01-06
38 reads
Once in a while I come across something that sounds fun or interesting and decide to dive a little deeper...
2018-01-06
567 reads
Continuation from the previous 117 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
As a logical continuation from the blog...
2018-01-05
875 reads
So you’re working with a query that you have loaded from a saved file. And now you want to open...
2018-01-05
384 reads
A bug was recently discovered on almost every processor made on the last 10 years, and it seems that almost...
2018-01-05
71 reads
As I mentioned in my recent blog Use cases of various products for a big data cloud solution, with so many...
2018-01-05
101 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