323 reputation
19
bio website
location
age
visits member for 1 year, 11 months
seen Apr 20 '13 at 21:13

Jul
2
awarded  Curious
Aug
25
awarded  Popular Question
Aug
14
awarded  Yearling
Apr
20
accepted How do I specify a linked server to a remote database over tcp/ip?
Apr
20
comment How do I specify a linked server 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 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
awarded  Editor
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?