Query to determine XE Session status
On a previous post, we discussed what is an extended event (XE) and how to create one.With the following T-SQL you can quickly check what are the currently running...
2018-10-03
36 reads
On a previous post, we discussed what is an extended event (XE) and how to create one.With the following T-SQL you can quickly check what are the currently running...
2018-10-03
36 reads
On a previous post, we discussed what is an extended event (XE) and how to create one.
With the following T-SQL...
2018-10-03
296 reads
This post is part of #tsql2sday event :)I know, in the world of the database administrators and developers, the triggers...
2018-09-11
562 reads
This post is part of #tsql2sday event ๐
I know, in the world of the database administrators and developers, the triggers are the ugly duck of the database development.They are...
2018-09-11
27 reads
One of the things I enjoy about my job is when I have to develop or review some T-SQL code, for my own projects or reviewing someones else code....
2018-09-10
26 reads
One of the things I enjoy about my job is when I have to develop or review some T-SQL code,...
2018-09-10
783 reads
JSON (JavaScript Object Notation) is a file format used to transmit data from various applications, very similar to XML, it...
2018-09-06 (first published: 2018-08-22)
3,747 reads
JSON (JavaScript Object Notation) is a file format used to transmit data from various applications, very similar to XML, it also used to stored NoSQL unstructured data, and because...
2018-08-22
18 reads
Views help our query writing by simplifying writing the same sentences and/or aggregations over and over again, but it has...
2018-08-17
365 reads
I am very happy to announce that after a long time struggling and filling all the requirements, we were able...
2018-08-16
733 reads
Recently, in an attempt to thwart leechers (1990s kids will know), I added some...
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...
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