650 reputation
38
bio website
location Rio de Janeiro, Brazil
age 39
visits member for 2 years, 8 months
seen 2 days ago

I'm a Delphi developer mainly, with 12+ years of experience, having done things ranging from ActiveX controls, maintaing and evolving systems to creating an (private) web service acting as business layer in Delphi.net.

I have some experience with C#/Vb.net too.


Aug
2
revised Can I force a user to use WITH NOLOCK?
deleted 812 characters in body
Aug
2
answered Can I force a user to use WITH NOLOCK?
Jul
30
comment SQL Server Tuning a table for massive inserts
ALTER SCHEMA...TRANSFER ? Never heard of it. Interesting...
Jul
8
answered How to undo every change made to a database in a controlled environment?
Jun
17
awarded  Necromancer
May
24
answered Updating a table with millions of records, its been 4 days
May
7
comment pros/cons of different ways to store whether a record is one of two options?
Good catch! I never thought of that hypothesis on the question, but it's really the right answer since all the bases are covered up.
Feb
21
answered Manually set log file size after shrink SQL Server 2008 R2
Feb
21
comment Manually set log file size after shrink SQL Server 2008 R2
@AaronBertrand - I agree with you in this. Log backup is nice for those who want almost 0 lost data. In this case, appear that some never changed the default recovery mode of model database........
Nov
30
comment We are running database maintenace with indexing the system, indexing fails due to locking?
@Laurence: maybe they does not have Enterprise Edition?
Oct
31
revised Query performance of a NULL vs an empty ('') varchar in SQL Server 2012
suggestions to solve the problem added
Oct
31
answered Query performance of a NULL vs an empty ('') varchar in SQL Server 2012
Oct
30
comment Query performance of a NULL vs an empty ('') varchar in SQL Server 2012
What is the distribution of values on that varchar column? Is empty string is, for example, a third of the total values on the column? More? Less? We need more information...
Oct
23
comment What can speed up a SQL count query?
@JonSeigel - My $0,05: Normal clustered indexes on normal table created offline applies an Sch-M lock on table. On a view, of course it's not needed but this means an alteration on the Create Index operation to create an special case for indexed view - which was done for SQL2012. IMHO, of course.
Oct
23
awarded  Benefactor
Oct
23
awarded  Scholar
Oct
23
accepted How to troubleshoot orm queries interfering with other applications
Oct
23
comment How to troubleshoot orm queries interfering with other applications
Seems the most aligned to the question, although the others got interesting info too. This one brough an way to enhance traceability using an MSSQL feature.
Oct
18
comment How to troubleshoot orm queries interfering with other applications
Seems you got the nearest so far. Have you tested if that bytes appear on "Binary data" of sql server profiler?
Oct
17
comment How to troubleshoot orm queries interfering with other applications
@dezso: see edit.