Where are my 32-bit Perfmon Counters?
I have run into this before, but not in this same way, so I decided it would be worth writing...
2014-05-05 (first published: 2014-04-23)
3,427 reads
Blog Posts
Why is there a sysobjects when we already have sys.objects?
Once upon a time in a version of SQL far far away we had system tables that were easy to...
2014-05-05
726 reads
A few words about simplicity: Using Red-Gate Ecosystem framework
In my first blog post I briefly covered when and why I created SQL Code Guard (SCG).To be honest, the first version...
2014-05-04
549 reads
Presentation Slides for Modern Data Warehousing
Thanks to everyone who attended my session “Modern Data Warehousing” at the PASS SQLSaturday Business Analytics edition in Dallas. The abstract is below. Great...
2014-05-04
1,168 reads
PROVIDING LOGGING INFORMATION AT COMMAND LINE
For providing logging information at command line utility use the option /l
for example
dtexe /f "some path" /l "logging type; connection...
2014-05-03
459 reads
Blogging-Write More
Blogging isn’t easy. You have to come up with a topic, write about it, and then release it for the...
2014-05-02 (first published: 2014-04-22)
1,505 reads
Building the SQLSaturday Orlando Marketing Plan–Part 5
More notes, many from a chat with Kendal.
We wish we could see the open rate on email and an...
2014-05-02
329 reads
Building the SQLSaturday Orlando Marketing Plan–Part 6 (Seminars)
Seminars (aka “pre-cons”) have been part of the DNA of SQLSaturday going back to #1. For those that weren’t there...
2014-05-02
493 reads
Collation: Confusion
I started reading about collations after I had a recent run in with them. As I read I started to...
2014-05-02 (first published: 2014-04-23)
2,404 reads
Data Quality Matching in SQL Server
Every IT person is more than introduced to the problems of integration – in the ideal perfect world we could join...
2014-05-02
209 reads
Blogs
Using AI to Build Semantic Models, Ontologies, and Fabric Data Agents
By James Serra
(This is the third post in a three-part series on how AI is changing...
SSMS Is Getting Smarter—and This Isn’t Just About Writing SQL
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
Yippee-Kai-Yay 2027 Summit in Denver
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Helping an English Student with R
Comments posted to this topic are about the item Helping an English Student with...
Adding Bits I
Comments posted to this topic are about the item Adding Bits I
Question of the Day
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