Alex Erwin

316 reputation

bio	website
	location
	age
visits	member for	9 months
	seen	Apr 20 at 21:13
stats	profile views	12

	316 reputation	bio	website		visits	member for	9 months
7 badges		location			seen	Apr 20 at 21:13

summary answers questions tags badges favorites bounties reputation activity

46 Actions

suggestions reviews revisions comments badges posts accepts all

Apr 20	accepted	How do I specify a linked server in SQL Server 2008 R2 to a remote database over tcp/ip?
Apr 20	comment	How do I specify a linked server in SQL Server 2008 R2 to a remote database over tcp/ip? That worked! None of the examples say I can use an IP directly.
Apr 20	asked	How do I specify a linked server in SQL Server 2008 R2 to a remote database over tcp/ip?
Feb 25	accepted	How do I create a CLR UDF with external name specifying namespace, class, and subclass?
Feb 25	comment	How do I create a CLR UDF with external name specifying namespace, class, and subclass? I did not know nested namespaces was possible. Now I do.
Feb 25	asked	How do I create a CLR UDF with external name specifying namespace, class, and subclass?
Feb 1	comment	*Simple Select on SQL Server 2008 R2 table of 1812 rows is taking 3 minutes to load** The table target is included in a transaction that I am running, should I set an isolation level so that I can still read the contents?
Feb 1	comment	*Simple Select on SQL Server 2008 R2 table of 1812 rows is taking 3 minutes to load** @a_horse_with_no_name I am using SSMS. I think may be due to a locking situation. I see in the dm_os_waiting_tasks a keylock is being held on the table.
Feb 1	asked	*Simple Select on SQL Server 2008 R2 table of 1812 rows is taking 3 minutes to load**
Jan 26	answered	How to remove column output in a for xml path query with a group by expression?
Jan 26	awarded	Editor
Jan 26	revised	How to remove column output in a for xml path query with a group by expression? Added XML Body and Explanation
Jan 23	asked	How to remove column output in a for xml path query with a group by expression?
Dec 6	comment	I need help using hierarchyid datatype and requiring a unique constraint on a varchar field Good answer, although it could get a bit cluttered because www and index.html were only examples. So if I could theoretically end up with thousands or tens of thousands of filtered indexes. But I will use this with a trigger on insert and update to force uniqueness.
Dec 6	accepted	I need help using hierarchyid datatype and requiring a unique constraint on a varchar field
Dec 5	asked	I need help using hierarchyid datatype and requiring a unique constraint on a varchar field
Sep 26	answered	Upgrading to SSMS with SQL Web Edition turned off Code Outlining : How do I get it back?
Sep 26	comment	Upgrading to SSMS with SQL Web Edition turned off Code Outlining : How do I get it back? Not sure if this helps, but Intellisense is not working either.
Sep 25	comment	Upgrading to SSMS with SQL Web Edition turned off Code Outlining : How do I get it back? Yes.I made sure all was the same as before the upgrade took place.
Sep 25	asked	Upgrading to SSMS with SQL Web Edition turned off Code Outlining : How do I get it back?