Forcing Execution Plan
Very rarely there is a need to force an execution plan and even more rarely we should be doing it....
2018-07-30 (first published: 2018-07-20)
13,451 reads
Very rarely there is a need to force an execution plan and even more rarely we should be doing it....
2018-07-30 (first published: 2018-07-20)
13,451 reads
Someone I stumbled across this picture of @brento on my drive.
This might be the best one:
And this was a good...
2018-07-20
331 reads
Not even close to being about SQL, I ran across the plans for a paper model of the Hubble Telescope while...
2018-08-03 (first published: 2018-07-20)
2,350 reads
I have heard some people say if you have a data warehouse, there is no need for cubes (when I say “cubes” I am referring to tabular and multidimensional OLAP...
2018-07-20
22 reads
I have heard some people say if you have a data warehouse, there is no need for cubes (when I...
2018-07-31 (first published: 2018-07-20)
3,236 reads
A couple of times recently I’ve seen the question asked, ‘How can I select a single row at random from...
2018-07-26 (first published: 2018-07-20)
747 reads
Haven’t posted one of these for a while! It’s good to have some time back to be able to read/write.
I’ve...
2018-07-20
341 reads
I’ve asked for #SQLCareer posts, and I haven’t done any. My job isn’t a data platform DBA or developer, but...
2018-07-20
477 reads
Earlier this year Brent Ozar invited me to attend some of his online classes for free. Free is good! Training...
2018-07-27 (first published: 2018-07-19)
2,404 reads
A few months back I ran across this article for checking semantic equivalencies of queries. That’s interesting, from the perspective...
2018-07-19
424 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...
Telp/Wa 62817825533 Jl. Cempaka No.17, Sukorejo, Kec. Sukorejo, Kota Blitar, Jawa Timur 66111
Telp/Wa 628217555651 Jl. Gajah Mada No.14-18, Kelurahan Jember Kidu, Jember Kidul, Kec. Kaliwates, Kabupaten...
Comments posted to this topic are about the item Why Successful SQL Server Backups...
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