690 reputation
49
bio website
location Rio de Janeiro, Brazil
age 40
visits member for 3 years, 4 months
seen Dec 14 at 18:56

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.


Oct
15
comment How to troubleshoot orm queries interfering with other applications
Interesting... No one even risked an answer...
Oct
9
comment Schema blocking in READ_COMMITTED_SNAPSHOT
@AlexKuznetsov: you think the OP have an unindexed FK on a big table causing table scans?
Sep
17
comment SQL Server - Database per company. How to query across databases?
Unless those are for different customers of the paying customer, which certainly won't like to see their data shared with other customer's. Even error messages can reveal sensitive information - which is not desirable.
Jul
24
comment What would be a good name for a job schedule?
If you put the name of jobs that use the schedule on schedule's name you can create a trap to yourself, as you can create a new job and associate it with a already existing schedule forgetting of update the schedule name to include the new job...
Jul
23
comment Efficient way of changing VARCHAR to NVARCHAR fields in a large table in SQL Server 2008?
The more bytes to operate, more work to do. (Based on a SQL2008, not R2, installation). You read/write/compare/cache the double of bytes. But on R2 there is an interesting feature - cited on the discussion above - which is Unicode compression. That changes the map. Aaron has some blog posts on it and I'm personally very curious of it. (Although I have no actual practical use for nvarchars now).
Jul
19
comment Efficient way of changing VARCHAR to NVARCHAR fields in a large table in SQL Server 2008?
And it will tax your I/O subsystem if that table is really big (example: a table with 1M rows with a varchar column with string with average size of 40 chars. With varchar you'll have an table with 36Mb of char data, with nvarchar the same data will need 76Mb to be stored/read/written).
Jul
19
comment Efficient way of changing VARCHAR to NVARCHAR fields in a large table in SQL Server 2008?
Is this an effort to make database internationalized? Because your index keys will double (AFAIR, NVARCHAR spend 2x the storage space of the varchar fields) and that, if you have an index key particularly long, can create a key that cannot be rebuilt (index keys are limited to 900 bytes, AFAIR)
Jul
12
comment Do you set an index on JOIN clauses or where clauses, or both?
Her blog posts about indexing is a exceptional reading...
Jul
9
comment Do indexes consume memory?
+1 That Ms Tripp's articles are EPIC on clustering keys...
Jun
30
comment Why does = NULL not work in Oracle?
@NickChammas - thanks for the reference. I hinted, because I saw the wars that the question Null is a value or a state can generate...
Jun
19
comment Running total with count?
@MartinSmith It is a VERY BIG article at sqlservercentral.com (go to Author page and find his' articles on quirck updates).
Jun
4
comment No luck trying out Firebird 3.0
I did some systems in Firebird and they're working flawlessly for almost half decade - I know it as the person maintaining it tell me that.
Mar
26
comment Data Base Administration Oracle vs MySql?
MySQL = Camry? It's more to a Corolla.....
Mar
26
comment Is there a reason/benefit I am not aware of for this kind setup?
In MySQL I really have no idea. In MS SQL Server, one could specify exclusive row locks to be held to the end of the transaction on a table hint on the above SELECT query and no one will be able to read that record until the txn ends.
Feb
8
comment Is it more secure to go through a 3rd database to connect two databases using the same login?
@FabricioAraujo: the requisites defines the design, so a design must be correct before being secure. A secured incorrect design is worthless - a insecure correct design can be made secure anytime.
Feb
8
comment Is it more secure to go through a 3rd database to connect two databases using the same login?
@Rachel: why you don't mentioned the "multiple PrivateDB" on the question? That changes everything... ;-\
Jan
25
comment Can someone explain why select with nolock will query a potion of updated data?
@SQLKiwi: Thank you, corrected.
Dec
22
comment Primary Key on a View
because that virtual table (select) is a intermediary result of a more complex process, so in that step of the process is easier to get the intermediate result with duplications (because have just the needed columns to exibition, and other columns would be needed to disambiguate) and finalize it on the client.
Dec
20
comment Primary Key on a View
what is the use of a table (virtual or otherwise) with duplicate rows? Reporting is one. You generate a resultset that have all info needed in a single (somewhat denormalised) presentation to the report tool get this job done easily. You can make that query remain on the database using a view and reports only need to include some filters to get the info needed.
Dec
12
comment One Big Database vs. Several Smaller Ones
Unless you put them on different instances/home...