Flipping Sides in SQL Operations Studio
I’ve been starting to use SQL Operations Studio (SOS) a bit more. This is a small, lightweight editor that is...
2018-08-08
483 reads
I’ve been starting to use SQL Operations Studio (SOS) a bit more. This is a small, lightweight editor that is...
2018-08-08
483 reads
If you’re a long time Profiler user like me then you probably often take the option of saving (or loading)...
2018-08-23 (first published: 2018-08-08)
2,378 reads
Determining what is causing your tempdb to grow can be difficult at times and troublesome during production issues. Luckily SQL...
2018-08-08
9,921 reads
A shorter post this week, but an important one. Last week, Erik Darling commented on my post saying that we...
2018-08-08
482 reads
A while back I was given the advice Move your tabs (Object Explorer etc) to the right side of SSMS....
2018-08-08
307 reads
I am a little late in posting this, but I still wanted to share. It is a huge honor to...
2018-08-08
367 reads
I am very excited about my upcoming IEAzure class being held in London, September 10th and 11th at the Marriott in Kensington (London).
This...
2018-08-08
373 reads
This is my first installment in (I hope) a series responding to Steve Jones’s (blog|twitter) #SQLCareer challenge. I decided to jot down most of what I did through the...
2018-08-08
13 reads
Wanted to be proactive and move a database that was in the default path on C: to a secondary drive as it was growing pretty heavily.
What I didn’t realize...
2018-08-08
24 reads
In this module you will learn how to use the Overview by CloudScope. The Overview by CloudScope show a list...
2018-08-21 (first published: 2018-08-07)
2,289 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