T-SQL Tuesday #17 – APPLY Knowledge
It’s that time of the month again… again. Time for T-SQL Tuesday! This month’s event is being hosted by Matt...
2011-04-12
1,249 reads
StrateSQL
April PASSMN Meeting (April 19)
Every career, whether on purpose or accident, is a journey from one job or project to another. To achieve great...
2011-04-11
582 reads
I Got Registered!
I’m going to SQL Rally! Are you going to SQL Rally? Have you heard of SQL Rally?
What’s SQL Rally?
I’m glad...
2011-04-07
427 reads
#Meme Monday
Use extended events; they work – and make you appear magical.
– “Write a SQL blog post in 11 words or less”...
2011-04-04
635 reads
MCM Exam – Take 2
Yesterday, I went in for my re-take of the MCM written exam. If you recall, I failed the exam last...
2011-03-29
579 reads
#SQLSat67… it’s mystery is only exceeded by it’s power.
We’ve seen a few summaries come through by now, so I’m going to throw mine into the mix. To recap...
2011-03-29
684 reads
Index Black Ops Series
Previously, in a TSQL2sDay index summary post, I started a series on the DMV sys.dm_db_index_operational_stats. The series investigates how the...
2011-03-26
865 reads
TechFuse Follow-Up
Last week I spoke at the TechFuse event in Minnesota – out at Mystic Lake Casino. As I mentioned in the...
2011-03-24
486 reads
What Are Your Indexing Strategies?
A couple weeks ago, I got some pretty great new. The book proposal that I had submitted to Apress was...
2011-03-22
639 reads
Twin City Code Camp 10 Is Coming
Twin Cities Code Camp will be hitting the University of Minnesota Campus again next month. This is a biannual event...
2011-03-18
593 reads
Blogs
A New Word: Semaphorism
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
SQL Server Linux Container Images Got Smaller: Image Size and Startup Time Across Cumulative Updates
This week I was at PASS Data Community Summit in Seattle, and I attended...
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...
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...
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