SQL Server Trace Events
I answered a forum post the other day over on SSC on the differences between the trace events stmtcompleted and...
2010-02-11
2,999 reads
I answered a forum post the other day over on SSC on the differences between the trace events stmtcompleted and...
2010-02-11
2,999 reads
I have been having an IO subsystem issue recently and I found the whitepapers very useful and wanted to post...
2010-02-09
791 reads
This is a short post on SQL Server storage best practice and what i have learned over the years… Much...
2010-02-07
1,355 reads
Useful link. This is a great best practice article/white paper from Tom Davidson and Danny Tambs.
The word document (880kb) can...
2010-02-07
594 reads
The default trace in SQL Server is something I have been experimenting with lately. It is a feature included in...
2010-02-04
3,904 reads
I recently watched Steve Jones’ (Blog | Twitter) "Building a better blog" presentation from the 24 hours of PASS virtual conference...
2010-02-02
860 reads
I recently discovered the Professional Association of SQL Server (PASS) virtual chapters. For those of you who struggle to make...
2010-01-31
2,033 reads
I was going to spend today finishing off some SQL Server related blog posts, I currently have a list of...
2010-01-30
1,661 reads
This is just a very short post regarding the use of wildcards in a WHERE Clause
It is possible that the...
2010-01-27
601 reads
I run into a small issue at the end last week, a CHECKDB job was reporting corruption on one of...
2010-01-24
678 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