Martin Smith

17,507 reputation

43579

bio	website
	location	United Kingdom
	age
visits	member for	1 year, 7 months
	seen	2 hours ago
stats	profile views	1,397

Email: stackoverflowmartinsmith@gmail.com

	17,507 reputation	bio	website		visits	member for	1 year, 7 months
43579 badges		location	United Kingdom		seen	2 hours ago

summary answers questions tags badges favorites bounties reputation activity

1,931 Actions

suggestions reviews revisions comments badges posts accepts all

Mar 8	comment	Does large table variables fill up logs in tempdb? @AaronBertrand - Thanks! I've added some of the pertinent information from their to this answer just looking at logging.
Mar 8	answered	Does large table variables fill up logs in tempdb?
Mar 8	comment	Why would running DBCC FREEPROCCACHE result in different data being returned? Did you happen to keep the execution plan before freeing the procedure cache?
Mar 8	comment	Delete a variable number of records by a chronological order `@RThomas - Yes I deleted the bit about deprecation as I saw you had already mentioned this and was aware of it.
Mar 8	comment	Why would running DBCC FREEPROCCACHE result in different data being returned? What is the query? Does it use any non deterministic constructs? e.g. `ROW_NUMBER` on a non unique `ORDER BY`?
Mar 8	answered	Delete a variable number of records by a chronological order
Mar 8	comment	Does this query make sense? @mdoyle - But excluding those ones for which there doesn't exist a non null `start_date` and including multiple rows for a `person_id` if there are multiple rows matching the `MAX(start_date)` (though there may be constraints that mean neither of these are possible)
Mar 8	comment	Does this query make sense? I don't think these are the correct semantics anyway. It seems you assume that the Sybase behaviour is akin to `WHERE start_date = MAX(start_date) OVER ()` but it seems from the docs to be more like `WHERE start_date = MAX(start_date) OVER (PARTITION BY person_id)`
Mar 8	revised	Does this query make sense? deleted 27 characters in body
Mar 8	revised	Does this query make sense? added 1711 characters in body
Mar 7	answered	Does this query make sense?
Mar 7	comment	Does this query make sense? Actually even with the Sybase non standard `GROUP BY` it doesn't make sense to me that you would `SELECT` the same column as you are grouping by with that `HAVING` clause.
Mar 7	comment	Is it possible to make one column readonly? I think you've missed the point of the question. It was asking whether there was any built in support to enforce precisely that the column should not be updatable.
Mar 7	answered	Is it possible to make one column readonly?
Mar 7	comment	Is it possible to make one column readonly? Rejected connect item request
Mar 7	answered	Is it possible to enforce unique values in a column, excluding nulls?
Mar 7	comment	Is it possible to enforce unique values in a column, excluding nulls? Couldn't find an exact dupe. Surprised it hasn't been asked before...
Mar 7	comment	Is it possible to enforce unique values in a column, excluding nulls? Yes. Use a unique filtered index that excludes `NULL`s. I guess this must be a duplicate.
Mar 7	comment	What is the maximum number of rows in a clustered index on datetime column? @GlennStevens - The uniqueifier only appears on rows that are actually duplicates. Though I suppose given `datetime`s precison of 300 ticks per second and the range '17530101' to '99991231' there are "only" 78,075,005,760,000 unique possibilities so most would be dupes.
Mar 7	comment	How to find DELETE and UPDATE statements that have been executed on a database? @Jester - No the machine name information is not stored. If you need this you need to set up some kind of auditing in advance it is not generally possible to get this retrospectively.