Join me at the PASS Summit
It seems just yesterday that we were all in Seattle together, getting a crash course in what’s new and exciting...
2012-06-25
434 reads
It seems just yesterday that we were all in Seattle together, getting a crash course in what’s new and exciting...
2012-06-25
434 reads
It seems just yesterday that we were all in Seattle together, getting a crash course in what’s new and exciting...
2012-06-25
647 reads
Two days back one of my colleque came to me and started complaining about the performance of an Stored Procedure....
2012-06-29 (first published: 2012-06-25)
9,021 reads
When we first announced the return of SQLSaturday to NYC (after 2 long years), we knew we'd get a decent...
2012-06-27 (first published: 2012-06-24)
2,278 reads
SQL Server 2012 allows you to store file/directories in a special table called FileTable that builds on top of SQL...
2012-06-24
13,808 reads
A surrogate key is an auto generated value, usually integer, in the dimension table. It is made the primary key...
2012-06-28 (first published: 2012-06-24)
7,789 reads
This presentation gives an excellent overview of the process of upgrading SQL Server 2008 SSIS packages to work with SQL...
2012-06-24
1,318 reads
You can rebuild all index for a table with "Alter Index Rebuild" and "DBCC DBREINDEX" .
First, in BOL, for "DBCC...
2012-06-27 (first published: 2012-06-23)
17,993 reads
Just as a society’s civilization is mostly nurtured by its culture, I believe that DBA work quality is mostly determined...
2012-06-23
941 reads
This article walks the user through installation of SQL Server 2012 on a Windows Server 2008 system using the SQL...
2012-06-23
215,194 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