Washington DC in the Summertime
As I mentioned in my post last week I was fortunate enough to visit Washington DC a week or so...
2012-06-18
734 reads
As I mentioned in my post last week I was fortunate enough to visit Washington DC a week or so...
2012-06-18
734 reads
These topics will give you the brief idea of what happens behind the scenes during failover occurs in Database mirroring....
2012-06-18
1,243 reads
Sometimes the shrink transaction log file doesn't work.
Before we troubleshoot it, we need to know how the log file works:
Transaction...
2012-06-17
3,082 reads
Reblogged from Data on Wheels - Steve Hughes: As I was working through some issues with my cube design, I realized...
2012-06-17
1,087 reads
There are several options available for configuring your storage media in Windows Server 2003 and Windows Server 2008. By understanding...
2012-06-16
2,485 reads
It has been nearly one week since SQL Saturday 132 in Pensacola Florida. I was chosen to give my talk...
2012-06-15
722 reads
The SQL Server maintains all indexes defined against a table regardless of their usage. Index maintenance can cause significant amounts...
2012-06-15
10,097 reads
Microsoft has posted ALL the session videos for TechEd North America 2012 and they are available for free! What a...
2012-06-15
1,051 reads
I think it’s only fitting to follow up a post about performance reviews and self-evaluations with a post about slacking...
2012-06-15
1,025 reads
What is a Connection Pool?
A connection pool is a group of database connections (with same connection properties) maintained in the...
2012-06-15
8,165 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...
WhatsApp:0817819444 Jl. Mahendradatta Selatan No. 99 AX, Padangsambian, Kec. Denpasar Bar., Kota Denpasar, Bali...
WhatsApp:0817819444 Jl. Raya Sesetan No.301, Sesetan, Denpasar Selatan, Kota Denpasar, Bali 80223
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