Recently I was analyzing a stress test result for an AG configuration, and as usual I was reading to SQL error...
2016-11-07
1,621 reads
This requires an immediate caveat. You should absolutely be using sp_executesql over any type of non-parameterized execution of T-SQL. You...
2016-11-07
1,224 reads
I’ll have several more posts this week on specific activities at the Summit, but wanted to start with how the...
2016-11-07
387 reads
Back in September I received a call from my MVP lead that I wasn’t being renewed. Not a big surprise,...
2016-11-07
390 reads
Applies to: xSQL Schema
Compare v7.0.0 – 9.0.2
Before I develop a scenario where
xSQL Schema Compare snapshot comparison is necessary let’s explain what xSQL
Schema snapshots are. An xSQL Schema snapshot is...
2016-11-07
26 reads
Applies to: xSQL Schema Compare v7.0.0 – 9.0.2
Before I develop a scenario where xSQL Schema Compare snapshot comparison is necessary let’s...
2016-11-07
372 reads
I haven’t written much in a while, having had to put more time into both personal and professional obligations over...
2016-11-07
374 reads
Last week I shared my custom Query Store Dashboard that can be used to view additional performance information that isn’t...
2016-11-07
2,154 reads
By Steve Bolton
…………Information on set operations like complements, intersections and unions is plentiful in the literature on fuzzy sets, which...
2016-11-07
805 reads
This
article is the part of series Mastering Index, in this particular article
we will be exploring Index on computed
columns. Take a look...
2016-11-07
579 reads
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
By James Serra
(This is the third post in a three-part series on how AI is changing...
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
Comments posted to this topic are about the item Pay for Performance, which is...
Jl. PB.Sudirman No.40, Tekoan, Tanggul Kulon, Kec. Tanggul, Kabupaten Jember, Jawa Timur 68155
Jl. YOS Sudarso No.49, Dusun Kp. Baru, Jajag, Kec. Gambiran, Kabupaten Banyuwangi, Jawa Timur...
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