The Cardinality Estimator in SQL Server 2014 – Going Forward and Backward
I saw a talk from Joe Sack (b | t) on the cardinality estimator (CE) in SQL Server 2014 and found...
2014-05-08 (first published: 2014-04-30)
3,532 reads
Decks & Demos Live
Hello Dear Reader! Just a quick update. I've been traveling a lot and I'm behind in posting some Decks & Demos....
2014-04-30
1,383 reads
Building the SQLSaturday Orlando Marketing Plan–Part 3
Not to short change fund raising, but the toughest goal to meet for this year is registration/attendance if we’re going...
2014-04-30
1,529 reads
Modern Data Warehousing Presentation
I will be presenting the session “Modern Data Warehousing” on Saturday at the PASS SQLSaturday Business Analytics edition in Dallas...
2014-04-30
1,770 reads
A New Stressor
I tend to be amused when I run into something that causes me stress because I like to think – foolishly...
2014-04-30
1,438 reads
DBA Myths: TRUNCATE TABLE deletes all the rows of a table instantly.
Most DBAs and developers I’ve talked to over the years have felt that TRUNCATE TABLE is an instant DELETE. However...
2014-04-30
2,735 reads
ERROR OPENING SSRS REPORT MANAGER IN INTERNET EXPLORER
Writing this post only for internet explorer as not aware of the settings of other browsers such as chrome/mozilla.
To be...
2014-04-30
1,266 reads
Colorado SQL Events for May 2014
SQL Meetings are training events for SQL Server professionals and those wanting to learn about SQL Server. Please note that...
2014-04-29
1,543 reads
Most important feature of SQL 2014
There are a whole raft of cool new features in 2014 including things like In-Memory OLTP, increased Azure integration/options and...
2014-04-29
1,690 reads
Find SQL Database Owner with T-SQL
One thing that on occasion bugs me about PDW or APS or whatever it happens to be called this week...
2014-05-08 (first published: 2014-04-29)
4,640 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...
Layanan BCA KCP Rembang Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. Pemuda No.3 C, Tawangsari, Leteh, Kec. Rembang, Kabupaten Rembang, Jawa Tengah 59217
Layanan BCA KCP Blora Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. Pemuda No.57B, Blora, Tempelan, Kec. Blora, Kabupaten Blora, Jawa Tengah 58211
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