T-SQL Window Functions – Part 1: The OVER() Clause
This is a reprint with some revisions of a series I originally published on LessThanDot. You can find the links...
2014-06-26
2,756 reads
Blog Posts
T-SQL Window Functions – Part 2: Ranking Functions
This is a reprint with some revisions of a series I originally published on LessThanDot. You can find the links...
2014-06-26
1,261 reads
Why Is your datetime saved as a bigint anyway?
Yet another issue I had never seen before - thankfully this time I was able to find a relatively quick answer.
On...
2014-06-26
741 reads
Worst Day As A DBA
I remember the day pretty vividly, it was in the summer months and I was as green as green can...
2014-06-26
446 reads
“A good DBA is a lazy DBA”
I’m borrowing from Andy Leonard (blog | twitter) who says all the time, “Good engineers are lazy.”
If you’re thinking, “Why would I want (to...
2014-06-25
1,960 reads
5 Things to Know About Indexes for SQL Server
One of the first questions I got while interviewing for a potential position as a DBA was “If there is...
2014-06-25 (first published: 2014-06-19)
6,687 reads
Clustered Columnstore Indexes – part 32 (“Size Does Matter, but how ?”)
Continuation from the previous 31 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/
The Columnstore Row Group Size Question:
What is better for SQL Server performance:...
2014-06-25
266 reads
Dealing with a long string
Every now and again you have to put a really long string (more than 8000 characters). Dynamic SQL is the...
2014-06-25
2,662 reads
Final Summer Precon for Me – Portland Maine
This coming weekend is the SQL Saturday #293 in Portland, Maine with my precon on Friday. I am really looking forward to attending...
2014-06-25
454 reads
I am speaking at the PASS Summit 2014
I am super excited to announce that I have been selected to speak at the 2014 PASS Summit. This is...
2014-06-25
1,234 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