sharptooth

187 reputation

bio	website
	location
	age
visits	member for	1 year, 2 months
	seen	Apr 11 at 8:36
stats	profile views	5

	187 reputation	bio	website		visits	member for	1 year, 2 months
6 badges		location			seen	Apr 11 at 8:36

summary answers questions tags badges favorites bounties reputation activity

26 Actions

suggestions reviews revisions comments badges posts accepts all

2d	awarded	Popular Question
Apr 11	accepted	How is SQL Server host identity ensured?
Apr 9	awarded	Commentator
Apr 9	comment	How is SQL Server host identity ensured? Is this msdn.microsoft.com/en-us/library/ms186362%28v=sql.105%29.aspx article on this specific topic?
Apr 9	revised	How is SQL Server host identity ensured? added 7 characters in body
Apr 9	asked	How is SQL Server host identity ensured?
Jan 17	comment	Is it a good idea to have an index when the column value changes several times over record lifetime? I usually make changes that are more or less easy to validate in testing environment but this one seems to not be of such kind.
Jan 17	comment	Is it a good idea to have an index when the column value changes several times over record lifetime? That's not really possible because it'd be very hard to simulate exactly the same load patterns.
Jan 17	revised	Is it a good idea to have an index when the column value changes several times over record lifetime? added 7 characters in body
Jan 17	comment	Is it a good idea to have an index when the column value changes several times over record lifetime? How do I make sure there's no serious negative impact from my change?
Jan 17	comment	Is it a good idea to have an index when the column value changes several times over record lifetime? I do have `SELECT` against that column - and a lot of them.
Jan 17	asked	Is it a good idea to have an index when the column value changes several times over record lifetime?
Dec 11	comment	What is shared between two instances on the same server? Emm... Why would the server being bare metal Windows 2008 R2 prevent you from using VMs? It has HyperV.
Apr 27	revised	Will altering order of columns in GROUP BY affect performance? deleted 6 characters in body
Apr 27	asked	Will altering order of columns in GROUP BY affect performance?
Apr 27	accepted	How do I count rows with two properties in one index scan in SQL?
Apr 26	awarded	Editor
Apr 26	comment	How do I count rows with two properties in one index scan in SQL? @Nick Chammas: I heard that SQL Azure is a modified version of SQL Server 2k8 R2. Not sure though.
Apr 26	revised	How do I count rows with two properties in one index scan in SQL? added 128 characters in body
Apr 26	comment	How do I count rows with two properties in one index scan in SQL? @Phil: Nope, that should be separate rows.