Can You Compress a Temp Table?
Hello Dear Reader! We are finishing up the final day of the Performance Tuning Workshop here in Atlanta and I...
2013-09-26 (first published: 2013-09-24)
7,543 reads
Hello Dear Reader! We are finishing up the final day of the Performance Tuning Workshop here in Atlanta and I...
2013-09-26 (first published: 2013-09-24)
7,543 reads
I have gone through and made some minor updates and bug fixes for all of my SQL Server Diagnostic Information...
2013-09-24
1,202 reads
As you may have seen in my post yesterday “PASS Board of Directors Election: Candidates announced” I am running for...
2013-09-24
713 reads
Sometimes I see confusion on the difference between a data warehouse (DW) and master data management (MDM). Below is a...
2013-09-24
1,467 reads
One of the things that can make Windows Azure SQL Databases (WASD) attractive is the fact that they run inside...
2013-09-24
778 reads
Tim Ford is running for a seat on the PASS Board of Directors and has my vote. Yes I think...
2013-09-24
609 reads
If you’re in the DC/Baltimore area, or just feel like coming to DC to learn about SQL Server, please join...
2013-09-24
529 reads
Recently I wrote about the myth that you can’t use an alias in an UPDATE statement. You can of course,...
2013-09-24
900 reads
Yesterday the slate of candidates for the PASS Board of Directors was announced. Seven candidates for three open positions this...
2013-09-24
853 reads
Wow! It’s been one year since I launched my blog, and my how things have changed.
Accomplishments Over the Past...
2013-09-24
737 reads
By James Serra
(This is the third post in a three-part series on how AI is changing...
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
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...
Comments posted to this topic are about the item Adding Bits I
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