Guillermo Gutiérrez

less info
193 reputation
7
bio website itsouvenirs.wordpress.com
location Antiguo Cuscatlán, El Salvador
age 25
visits member for 1 year, 2 months
seen Mar 20 at 12:41

Programador Analista. Experiencia en C# y SQL Server, por mi trabajo desde 2011. Conocimientos sobre el diseño de bases de datos relacionales. Experiencia de uso de controles Developer Express para Windows Forms. En cuanto a la web, poseo conocimientos de PHP con uso de framework Symfony 1.4 y ORM Doctrine 1.2, así como uso de HTML, Javascript y CSS. Experiencia en MVC framework 2 y 3, con uso de NHibernate y StructureMap. Otros lenguajes de programación: Java, C, Visual Basic, DrScheme, Prolog.


Dec
16
awarded  Popular Question
Oct
22
accepted How to insert in table from remote stored procedure without creating a distributed transaction?
Oct
21
comment How to insert in table from remote stored procedure without creating a distributed transaction?
It seems to be available from SQL Server 2008 and above, but not for SQL Server 2005 :( (technet.microsoft.com/en-us/library/ms178532%28v=sql.90%29.aspx)
Aug
30
comment Find the first gap in an aggregation of integers in SQL Server
I guess this is the fastest way. However, if rank=1 is deleted, it will never be taken.
Jul
22
accepted SQL:StmtStarting event originated from application
Jul
22
comment SQL:StmtStarting event originated from application
Thanks, I'll take your suggestion. I'm a noob with SQL Server Profiler.
Jul
22
asked SQL:StmtStarting event originated from application
Jul
22
comment Which is the uniqueness level of object_id?
And now I know I shouldn't use it...
Jul
22
comment Which is the uniqueness level of object_id?
I need the shortest value to unique identify the columns and tables of the same database amongst many computers. That's why I was interested in a number like the object_id, instead of the names, but I've seen cases where the id was modified, so I wasn't sure to use it.
Jul
18
accepted Which is the uniqueness level of object_id?
Jul
18
comment Why is SSMS inserting new rows at the top of a table not the bottom?
As I have seen sometimes, it depends on the PK's ordering how the rows are displayed, if you select a single table. If you make some joins, it can change depending on the other tables PK's, FK's and indexes...
Jul
18
asked Which is the uniqueness level of object_id?
Jul
17
revised How to insert in table from remote stored procedure without creating a distributed transaction?
added 119 characters in body
Jul
17
comment How to insert in table from remote stored procedure without creating a distributed transaction?
Yes, that's it...
Jul
17
asked How to insert in table from remote stored procedure without creating a distributed transaction?
Jul
17
revised Does openquery use distributed transactions?
edited body
Jul
17
asked Does openquery use distributed transactions?
Jul
13
accepted Which one is more efficient: select from linked server or insert into linked server?
Jul
12
revised How can I query data from a linked server, and pass it parameters to filter by?
Added more details.
Jul
12
awarded  Editor