Monitoring SQL Agent Jobs when you work for Mr Krabs
For those of you who don’t know who Mr. Krabs is, he is a character in the TV show Sponge...
2015-04-02
574 reads
For those of you who don’t know who Mr. Krabs is, he is a character in the TV show Sponge...
2015-04-02
574 reads
I recently worked on a project where the client requested to “remove all of the unused jobs” that had been...
2015-04-09 (first published: 2015-04-01)
8,534 reads
This is a short post that is considering the indexes fill factor impact on the fragmentation. Analysis of indexes is a continuous process on the company’s databases that you,...
2015-04-01
18 reads
This is a short post that is considering the indexes fill factor impact on the fragmentation. Analysis of indexes is a continuous process on the company’s databases that you,...
2015-04-01
25 reads
This is a short post that is considering the indexes fill factor impact on the fragmentation. Analysis of indexes is...
2015-04-01
405 reads
As I mentioned in my storage benchmarking post, storage performance is one of the critical infrastructure components underneath a mission-critical...
2015-04-09 (first published: 2015-04-01)
18,454 reads
It seems that Microsoft has finally gotten tired of all the jokes about the word “performant” or using “ask” as...
2015-04-01
500 reads
This is a short post that is considering the indexes fill factor impact on the fragmentation. Analysis of indexes is...
2015-04-01
191 reads
Earlier today, the fine folks at the F. Oobar Corporation released a revolutionary product: a universal data integration utility. This...
2015-04-01
746 reads
This is one of those posts which is due for a long time. I was really excited when Microsoft announced...
2015-04-08 (first published: 2015-04-01)
6,516 reads
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
This week I was at PASS Data Community Summit in Seattle, and I attended...
By James Serra
(This is the third post in a three-part series on how AI is changing...
Comments posted to this topic are about the item Pay for Performance, which is...
Comments posted to this topic are about the item Helping an English Student with...
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