XEvent Session Supporting Cast
Beyond the metadata in the the catalog views and DMVs, there are a few more objects that come in handy when dealing with Extended Events. I call these the...
2015-09-04
22 reads
Beyond the metadata in the the catalog views and DMVs, there are a few more objects that come in handy when dealing with Extended Events. I call these the...
2015-09-04
22 reads
So far, in this series, I have discussed the means to view the metadata associated with Extended Events. I also demonstrated...
2015-09-10 (first published: 2015-09-04)
993 reads
After a short little break on Hekaton series, we are now back with the 5th post.
Two new index types...
2015-09-04
758 reads
In the upcoming release of SQL Server Analysis Services 2016, one of the new features you’ll see is the ability...
2015-09-09 (first published: 2015-09-03)
2,141 reads
A few years ago Andy Warren had this idea for a networking dinner. We had been chatting about all the...
2015-09-03
883 reads
I was toying around with the new SQL Server 2016 CTP release and I wanted to run a few SSIS packages...
2015-09-03
5,490 reads
Running session metadata, while it can be still be viewed in the catalog views, is exposed via DMVs. Putting it a slightly different way, if I query DMVs that...
2015-09-03
16 reads
In the previous article, I wrote about getting into some of the metadata to take a peek at session metadata...
2015-09-08 (first published: 2015-09-03)
1,335 reads
In this article I’d like to tell about monitoring tools available in SQL Server 2014 to evaluate the performance of...
2015-09-03
1,305 reads
Continuation from the previous 63 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
I have decided to write a rather...
2015-09-02
633 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