SQL Saturday 828 - T-SQL Basics: Coding for performance
A great experience!
Thanks to all the atendess to my session about T-SQL, for being my first time as a speaker for a SQL Saturday it was good!As I promised,...
2019-02-17
26 reads
A great experience!
Thanks to all the atendess to my session about T-SQL, for being my first time as a speaker for a SQL Saturday it was good!As I promised,...
2019-02-17
26 reads
A great experience!Thanks to all the atendess to my session about T-SQL, for being my first time as a speaker...
2019-02-16
156 reads
I’ve finally updated my Power BI Architecture Diagram to include some of the new features that are now available and...
2019-02-16
817 reads
Note: I’ve been meaning to start a series on the basics of SQL Server Reporting Services (SSRS). The last time...
2019-02-16
422 reads
If you have been following my blog, you probably know that I write a lot of step-by-step guides for building...
2019-02-15
1,244 reads
If you ever tried to capture a benchmark on your SQL Server, you probably know that it is a complex...
2019-02-15
575 reads
I’m excited to have just clicked ‘publish’ on four new videos in the brand new Evangelist Tutorials playlist on Redgate’s YouTube channel. These videos step through setting up and...
2019-02-15
32 reads
I am so excited and honored to announce that I have been selected to speak at SQL Saturday Chicago on Saturday, March 23, 2019. I will be presenting my...
2019-02-15
30 reads
I am so excited and honored to announce that I have been selected to speak at SQL Saturday Chicago on...
2019-02-15
109 reads
Several weeks ago, while on a flight traveling home from San Francisco, I received an exciting email. I had submitted...
2019-02-15
494 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