Matthew

270 reputation

bio	website
	location	Reno, NV
	age	26
visits	member for	1 year, 7 months
	seen	May 20 at 21:44
stats	profile views	10

I love creating elegant software solutions to novel problems.

Data is the future. Optimization is not our enemy.

	270 reputation	bio	website		visits	member for	1 year, 7 months
38 badges		location	Reno, NV		seen	May 20 at 21:44

summary answers questions tags badges favorites bounties reputation activity

28 Actions

suggestions reviews revisions comments badges posts accepts all

May 20	awarded	Caucus
May 20	awarded	Constituent
Apr 14	awarded	Popular Question
Apr 10	awarded	Good Question
Oct 10	awarded	Yearling
Jun 13	accepted	Are SQL Server's Date values stored as a single int?
Jun 13	comment	Are SQL Server's Date values stored as a single int? @AaronBertrand This was migrated from SO, at that time it had a downvote which has since been removed.
Jun 13	awarded	Commentator
Jun 11	comment	Are SQL Server's Date values stored as a single int? +1 excellent exploration of the page data and `CONVERT` behavior~
Jun 11	comment	Are SQL Server's Date values stored as a single int? @AaronBertrand I wonder whether or not the database needs to convert between `INT` and `UNICORN` in order to perform a comparison operation....
Jun 11	comment	Are SQL Server's Date values stored as a single int? +1 not sure how I missed that... I'll mark this as the answer if the question isn't closed first!
Jun 11	comment	Are SQL Server's Date values stored as a single int? @cdhowie I'm curious how it's stored in the back-end. It if doesn't matter to you then feel free to click a different question?
Jun 11	asked	Are SQL Server's Date values stored as a single int?
Nov 28	awarded	Scholar
Nov 28	accepted	Is the concept of a clustered index in a DB design sensical when using SSDs?
Nov 28	comment	Is the concept of a clustered index in a DB design sensical when using SSDs? good point, poor word use on my part, when I say "standard index" I mean all types of non-clustered indices.
Nov 28	comment	Is the concept of a clustered index in a DB design sensical when using SSDs? @RemusRusanu that's an interesting read. Does the use of a clustered index even remotely assist my data reads be aligned "properly?"
Nov 28	comment	Is the concept of a clustered index in a DB design sensical when using SSDs? but I'm not discussing the merits of having no indices, simply questioning the importance of a clustered versus standard index given identical seek times.
Nov 28	comment	Is the concept of a clustered index in a DB design sensical when using SSDs? @RemusRusanu I think that ruakh hits on my question to you. What benefit is there for choosing the clustered index over choosing a standard index; particularly in your example of an in-RAM DB... Is it solely Bill Karwin's example of the coincidence that data will be on the same page?
Nov 28	comment	Is the concept of a clustered index in a DB design sensical when using SSDs? @NickChammas I'm referring to the fact that SQL Server automatically created a clustered index on the primary key.