A look on the CXPACKET wait type
I was given a task to optimize a black-box application. I wasn’t able to see its code, but the database was open for analysis. I caught the queries from...
2015-09-10
46 reads
I was given a task to optimize a black-box application. I wasn’t able to see its code, but the database was open for analysis. I caught the queries from...
2015-09-10
46 reads
I was given a task to optimize a black-box application. I wasn’t able to see its code, but the database was open for analysis. I caught the queries from...
2015-09-10
10 reads
I was given a task to optimize a black-box application. I wasn’t able to see its code, but the database...
2015-09-10
387 reads
I was given a task to optimize a black-box application. I wasn’t able to see its code, but the database...
2015-09-10
708 reads
Time for the T-SQL Tuesday #70 roundup! I asked people for their best enterprise management strategies, and they responded beautifully....
2015-09-10
768 reads
Next week is the wonderful IT/Dev Connections conference in Las Vegas, and I’m proud to announce that I’m presenting two...
2015-09-10
484 reads
I wrote a test earlier and forgot one of the two cardinal rules about tSQLt so I was running my...
2015-09-24 (first published: 2015-09-10)
1,238 reads
I wrote a test earlier and forgot one of the two cardinal rules about tSQLt so I was running my...
2015-09-10
48 reads
I wrote a test earlier and forgot one of the two cardinal rules about tSQLt so I was running my...
2015-09-10
56 reads
Such a topic related to SQL Server 2014 CTP1 may seem a bit strange, but it was chosen not randomly. The questions like “How can I protect my data...
2015-09-10
30 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