Ed Harper

307 reputation

bio	website
	location
	age
visits	member for	1 year, 7 months
	seen	May 16 at 9:33
stats	profile views	17

	307 reputation	bio	website		visits	member for	1 year, 7 months
38 badges		location			seen	May 16 at 9:33

summary answers questions tags badges favorites bounties reputation activity

40 Actions

suggestions reviews revisions comments badges posts accepts all

May 2	comment	SELECT COL_NAME(969262708, ORDINAL_POSITION) returns a NULL value in one of the rows Could this be permissions related? BOL states that `COL_NAME` can return `NULL` if the caller doesn't have permission to view the object. Are any column-level permissions in place? Is the query running under an equivalent security context in test and production?
Apr 3	awarded	Enlightened
Apr 3	awarded	Nice Answer
Apr 2	awarded	Yearling
Apr 2	answered	SQL Server uses only 1 CPU of 4 available
Mar 26	awarded	Organizer
Oct 10	revised	How do I tell what is filling up the transaction log? correct typo in title
Oct 10	suggested	suggested edit on How do I tell what is filling up the transaction log?
Aug 14	comment	Is the SQLTRACE_FILE_BUFFER wait type documented? What does it indicate? @Aaron - the default trace wasn't as heavily used as on other boxes in our environment; one average two or three objects being created per second, almost exlusively in tempdb - but disabling it made the wait disappear. We're going to get up to the latest service pack and see if anything changes.
Aug 14	revised	Is the SQLTRACE_FILE_BUFFER wait type documented? What does it indicate? added 141 characters in body
Aug 13	comment	Is the SQLTRACE_FILE_BUFFER wait type documented? What does it indicate? @Aaron - it's SQL 2008 R2 RTM (10.50.1600) Enterprise for X64. We haven't turned off the default trace; I will get that done.
Aug 13	comment	Is the SQLTRACE_FILE_BUFFER wait type documented? What does it indicate? @Aaron - thanks for your thoughts. We decided to try disabling the trace entirely, which had no effect - the same wait type continues to appear in the monitoring table.
Aug 13	revised	Is the SQLTRACE_FILE_BUFFER wait type documented? What does it indicate? updated
Aug 11	awarded	Student
Aug 11	asked	Is the SQLTRACE_FILE_BUFFER wait type documented? What does it indicate?
Jun 18	awarded	Commentator
Jun 8	awarded	Constituent
Jun 8	awarded	Caucus
May 2	comment	*Fast SQL query with but extremely slow with specific columns?** Are any of the views in the query indexed? Are you running on Standard edition?
Apr 15	comment	Which should be used after messing up clustered index? Update statistics, Reindex or Reorganize @Daniel - read the links in my answer. The clustered index determines the order the data is stored in the table.