680 reputation
49
bio website
location Rio de Janeiro, Brazil
age 39
visits member for 3 years, 2 months
seen Oct 15 at 20:17

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
27
comment Avamar SQL Agent running against live SQL Server databases
The idea of asking them for making a POC is excellent. That will show if their solution can meet your concerns or not.
Jul
5
comment Is select * still a big no-no on SQL Server 2012?
Is that kind of attitude from app developers that harm the entire company. Remember me an Gail Shaw blog post on developers simply omitting from DBA team that they are using an ORM.
Apr
8
comment Getting the database from synonym base object
Never heard of that function!!! Brilliant! +1 and accept.
Apr
8
comment Getting the database from synonym base object
All the 4 object_piece is all the information I need. The and other information part is completely satisfied by your answer, @AaronBertrand. ;-)
Jan
31
comment Migration from SQL Server 2008 to Postgres 9.2
@a_horse_with_no_name I though that modification as a step BEFORE the OP start making the PGSQL database - still in MSSQL2008
Sep
20
comment Can I force a user to use WITH NOLOCK?
I didn't said that. Who said that was Aaron.
Aug
21
comment Is there a DB that will allow the same field name with different cases?
@GreenstoneWalker: it make painkillers' vendors richer.
Aug
8
comment Can I force a user to use WITH NOLOCK?
@AaronBertrand: wow Aaron, you made the hard job for me. Tks. Paul, give up on that. Exist rules I don't like on SO/SE network? Yes. But I can live with it.
Aug
7
comment Can I force a user to use WITH NOLOCK?
@Paul for the use in SO and StackExchange network, "thankyou" is classified as a greeting.
Aug
7
comment Can I force a user to use WITH NOLOCK?
The only other methodology is in Aaron's answer about using SP's and/or views.
Jul
30
comment SQL Server Tuning a table for massive inserts
ALTER SCHEMA...TRANSFER ? Never heard of it. Interesting...
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
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
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
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.
Oct
16
comment How to troubleshoot orm queries interfering with other applications
Seems you didn't got it. I don't want the SQL query that caused the problem. Profiler already gave me that (or those). What I looking for is the process to find the LINQ query(or queries) that are creating the problem (there's no SQL in the application) from a post-morten log (like Profiler).