Guillermo Gutiérrez

less info
217 reputation
28
bio website itsouvenirs.wordpress.com
location Antiguo Cuscatlán, El Salvador
age 25
visits member for 1 year, 7 months
seen Aug 8 at 13:35

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.


Jul
11
revised Scalar function used in calculated column, what's the cleanest way to update the function?
Added tags "user-defined-functions" and "functions", because the question is directly related to the use of SQL Server user defined function.
Jul
10
suggested suggested edit on Scalar function used in calculated column, what's the cleanest way to update the function?
Jul
2
awarded  Curious
May
28
awarded  Yearling
May
21
accepted Does openquery use distributed transactions?
May
5
awarded  Notable Question
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...