Reputation
328
Top tag
Next privilege 500 Rep.
Access review queues
Badges
2 10
Impact
~9k people reached

  • 0 posts edited
  • 0 helpful flags
  • 10 votes cast
Dec
17
awarded  Popular Question
Sep
22
awarded  Notable Question
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.