My First Technical Job – T-SQL Tuesday #150
I’m late to the party on May’s T-SQL Tuesday, but thought it was an interesting enough topic to be worth a belated blog post. It’s about first technical jobs...
2022-06-05
58 reads
I’m late to the party on May’s T-SQL Tuesday, but thought it was an interesting enough topic to be worth a belated blog post. It’s about first technical jobs...
2022-06-05
58 reads
This month’s T-SQL Tuesday is about how we look at SQL Server upgrades, hosted by Steve Jones. My experience of SQL upgrades is that they tend to be largely...
2022-02-08
45 reads
Sometimes it’s good to look back and appreciate what we have and how far we’ve come. This applies to many things, but today I’m talking about the humble hard...
2022-02-18 (first published: 2022-02-06)
590 reads
I recently encountered a requirement to estimate the size of (a lot of) nonclustered indexes on some very large tables due to not having a test box to create...
2021-08-13 (first published: 2021-08-01)
500 reads
I recently encountered a requirement to estimate the size of (a lot of) nonclustered indexes on some very large tables due to not having a test box to create...
2021-08-01
55 reads
While testing a script that involved calculating index record size recently I was getting some confusing results depending on server version, and after some digging it appears there was...
2021-07-28
95 reads
While testing a script that involved calculating index record size recently I was getting some confusing results depending on server version, and after some digging it appears there was...
2021-07-28
29 reads
Hopefully not many people are still configuring SSIS instances on SQL 2012 or 2014 – especially HA instances – but if you are, this post is for you. If...
2021-05-28
204 reads
Hopefully not many people are still configuring SSIS instances on SQL 2012 or 2014 – especially HA instances – but if you are, this post is for you. If...
2021-05-28
42 reads
Blocking in SQL Server can be good – after all, it’s one of the ways consistency is guaranteed – we usually don’t want data written to by two processes...
2021-05-24 (first published: 2021-05-13)
757 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