Reblog: March 15 to March 21
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-03-22
668 reads
April 2013 Events
April is going to be a fantastic month! I am slated to have quite a few speaking and training opportunities...
2013-03-22
688 reads
Sub query pass through
Occasionally in forums and on client sites I see conditional subqueries in statements. This is where the developer has decided...
2013-03-26 (first published: 2013-03-22)
3,595 reads
We Need a Place for SQLFamily News
I’m writing this because I was thinking about a member of the local PASS chapter on the way home last...
2013-03-29 (first published: 2013-03-22)
1,206 reads
Why I’m Considering a Surface and Windows Phone 8
Anyone who knows me will see the title of this post and tell you I’m about to trash the Surface,...
2013-03-22
682 reads
Customizing SSMS – Bigger Queries
This is a short series on some customizations in SSMS to make it visually more appealing.
As a presenter, I’ve learned...
2013-03-21
1,747 reads
SQL Server : Part 6 : Design consideration of Clustered Index
In our earlier post, we have discussed about the structure and storage of clustered index. In this post we will discuss...
2013-03-21
2,082 reads
CU3 for SQL2012 SP1 – Couple of interesting hotfixes.
Here comes CU 3 (Build 11.0.3349.0.) for SQLServer 2012 SP1. You can download the same from
http://support.microsoft.com/kb/2812412
Similar to CU2 there...
2013-03-21
1,442 reads
SQL in Chicago
Hello Dear Reader! I've got some very exciting news! Pragmatic Works is holding a Two Day Performance Tuning Workshop in...
2013-03-21
1,214 reads
A Second March ‘Index Analysis’ Update
After this month’s Index Analysis update, I was contacted by a reader about the index analysis script. Reader Dick Baker let...
2013-03-21
750 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