Populating My DBA Database for Power Bi with PowerShell – Databases
Following my post about using Power Bi with my DBA Database I have been asked if I would share the...
2015-09-22
873 reads
Following my post about using Power Bi with my DBA Database I have been asked if I would share the...
2015-09-22
873 reads
Here I continue a series of articles devoted to new options in SQL Server 2014. Today let’s review another useful operation – ONLINE rebuilding some partitions of partitioned objects...
2015-09-22
57 reads
Here I continue a series of articles devoted to new options in SQL Server 2014. Today let’s review another useful operation – ONLINE rebuilding some partitions of partitioned objects...
2015-09-22
46 reads
Here I continue a series of articles devoted to new options in SQL Server 2014. Today let’s review another useful...
2015-09-22
1,047 reads
Welcome back to DR drill series!
In the last post (here), we have highlighted a number of ways to setup disaster...
2015-09-22
1,510 reads
Continuation from the previous 66 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
Continuing from the last couple of blog...
2015-09-22
623 reads
Statistics, in simplest terms, refer to the distribution of data in a column or index. They are represented in a...
2015-09-21
798 reads
One of the hassles of working in a development team is that you will have conflicts between your code and...
2015-09-21
1,062 reads
XML handling with aliases
I find it interesting the difference in behavior with querying XML between column assignment, and quoted alias...
2015-09-21
319 reads
I have spoken a number of times at different SQLSaturdays around the world, including some rather rare editions, such as...
2015-09-21
441 reads
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
This week I was at PASS Data Community Summit in Seattle, and I attended...
By James Serra
(This is the third post in a three-part series on how AI is changing...
Comments posted to this topic are about the item Pay for Performance, which is...
Comments posted to this topic are about the item Helping an English Student with...
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