Scalar UDF Inlining in SQL Server 2019 – Simpler functions
I recently published a post detailing the new Scalar UDF Inlining feature in SQL 2019 here. That post introduced the...
2019-03-26 (first published: 2019-03-11)
675 reads
I recently published a post detailing the new Scalar UDF Inlining feature in SQL 2019 here. That post introduced the...
2019-03-26 (first published: 2019-03-11)
675 reads
Share your story and you could win. Enter as often as you like before Mar 20.
https://www.red-gate.com/hub/entrypage/competition
2019-03-11
380 reads
I frequently present at user groups, and always try to create a brand new presentation to keep things interesting. We all know technology changes so quickly so there is...
2019-03-11
24 reads
I frequently present at user groups, and always try to create a brand new presentation to keep things interesting. We...
2019-03-11
371 reads
I’ve shown before how to use the DMVs that read the plan cache as a way to connect the missing indexes suggestions with specific queries, but the other place...
2019-03-11
33 reads
I’ve shown before how to use the DMVs that read the plan cache as a way to connect the missing...
2019-03-22 (first published: 2019-03-11)
2,400 reads
Hello, fellow data nerds! I wanted to make you aware of a fantastic event coming up this month in Tampa,...
2019-03-11
607 reads
I’m taking a brief break from daily blogging, even though it has been a ton of fun.
No excuses
I hope...
2019-03-11
241 reads
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2019-03-25 (first published: 2019-03-11)
556 reads
Databricks-Connect – FINALLY! Do write your code in VS Code and run it remotely on Azure Databricks cluster. Automatically validate E-mail...
2019-03-11
311 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