SQL Saturday Baton Rouge
Hello Baton Rouge! David Pless and I will be teaching an all day workshop on Performance Tuning and Optimization for Modern Workloads (SQL Server 2017, Azure SQL Database, and...
2019-06-03
13 reads
Hello Baton Rouge! David Pless and I will be teaching an all day workshop on Performance Tuning and Optimization for Modern Workloads (SQL Server 2017, Azure SQL Database, and...
2019-06-03
13 reads
Hello Baton Rouge! David Pless and I will be teaching an all day workshop on Performance Tuning and Optimization for Modern Workloads (SQL Server 2017, Azure SQL Database, and...
2019-06-03
49 reads
Yep. It’s time for your monthly homework session. You’ve finished last months right? Please turn it in over there. This ... Continue reading
2019-06-03
35 reads
Database Engineering: Database Modelling: Do I need to have an incrementing identity int/bigint as my clustered index in a SQL Server database? When you want to produce a professional...
2019-06-03
27 reads
Database Engineering: Database Modelling: Do I need to have an incrementing identity int/bigint as my clustered index in a SQL Server database? When you want to produce a professional...
2019-06-03
19 reads
This is the blog anniversary! 16th Weekly reading has come into the light! For great articles and a video wait for you! Report Parameter Support for Paginated Report E-Mail...
2019-06-03
33 reads
After our SQL in the City Summit in Brisbane last week, Hamish Watson () asked me if I’d do a short version of my keynote talk at the upcoming...
2019-06-02
21 reads
Thanks for joining hundreds of SQL pros from around the country today at UTDallas!Here's my session downloads from my presentation today at 1:15 in room 1.102, there's a handy...
2019-06-01
24 reads
Implicit conversions are not uncommon in the computing world and can be viewed as kind of a fail-safe for when we don't quite follow decent practices when designing the...
2019-05-31
24 reads
Implicit conversions are not uncommon in the computing world and can be viewed as kind of a fail-safe for when we don't quite follow decent practices when designing the...
2019-05-31
22 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