Extended Events Made Easy – Sorting, Grouping and Aggregation
When I’m using Profiler to analyse performance issues I often save the results to a table, or upload a trace...
2018-10-29 (first published: 2018-10-16)
2,134 reads
When I’m using Profiler to analyse performance issues I often save the results to a table, or upload a trace...
2018-10-29 (first published: 2018-10-16)
2,134 reads
At Microsoft Ignite, one of the announcements was for Azure SQL Database Hyperscale, which was made available in public preview October 1st, 2018 in 12 different Azure regions. SQL Database Hyperscale is...
2018-10-16
99 reads
At Microsoft Ignite, one of the announcements was for Azure SQL Database Hyperscale, which was made available in public preview October 1st,...
2018-10-26 (first published: 2018-10-16)
2,442 reads
Table variables, they’re nasty, dirty little things that perform about as well as a Robin Reliant in a crosswind, right? ...
2018-10-25 (first published: 2018-10-16)
2,094 reads
While I normally prefer formatting my query results in a downstream app/reporting layer, sometimes I can’t get around adding some...
2018-10-29 (first published: 2018-10-16)
2,684 reads
Watch this week's video on YouTube
While I normally prefer formatting my query results in a downstream app/reporting layer, sometimes I can't get around adding some business formatting logic to...
2018-10-16
68 reads
Watch this week's video on YouTube
While I normally prefer formatting my query results in a downstream app/reporting layer, sometimes I can't get around adding some business formatting logic to...
2018-10-16
19 reads
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2018-10-25 (first published: 2018-10-16)
3,920 reads
In Joyful Craftsmen we provide, among other things, technical support to our customers, which from time to time involves us...
2018-10-16
886 reads
AdvertisementsI am seeing in more environment the database recovery model is set FULL and there is no transaction log backup...
2018-10-16
303 reads
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