9,700 reputation
11942
bio website careers.stackoverflow.com/cv/…
location Iasi, Romania
age 33
visits member for 3 years, 9 months
seen 1 hour ago

Development DBA for a medium sized project team. Part of a 3 DBAs team and working in close touch with about 30 developers.

I'm here to learn from the best and share my knowledge. Proud and happy to be a part of such a great community.

You can find me here:


Oct
14
awarded  Enlightened
Oct
14
awarded  Nice Answer
Oct
10
reviewed Approve suggested edit on Terrible Bad Query Plan
Oct
9
comment How to join by most recent preceding date?
Can you, please, post a sample schema and data on sqlfiddle?
Oct
7
reviewed Approve suggested edit on hierarchical-queries tag wiki excerpt
Oct
7
reviewed Approve suggested edit on hierarchical-queries tag wiki
Oct
6
reviewed Approve suggested edit on outer-join tag wiki excerpt
Oct
4
comment Permission to view execution report in SSIS Catalog
@Joann.B great, now come back with the details and help this poor man by clicking the up arrow and the answered button ;).
Sep
30
awarded  Explainer
Sep
23
comment 700 million row mixed text/numeric data - read-only in a single table
Please change the person in charge of your data. With someone more compatible with data. Or servers. Or both.
Sep
13
comment AWE to allocate memory in SQL Server 2008 Express with Advanced Services
AWE is useful for your OS to be able to allocate SQL Server more than the limited 4GB of a 32 bit operating system. The fact that your OS will support more than 4 GB for a process doesn't mean your Express SQL will do. It's 2014, switch to: 64 bit OS, any supported SQL Server edition. That will be a better decision than investing time and money in a old SQL/OS pair.
Sep
11
reviewed Approve suggested edit on sharding tag wiki excerpt
Sep
11
reviewed Approve suggested edit on sharding tag wiki
Sep
8
comment INSERT takes over 5 hours, when inserting more than specific number of rows
How do you import the data (bcp, bulk insert, SSIS, batch file)? Where from (local storage, same/different drive, network storage, ..)? What's the table schema? What's the import command? What's the execution plan (if it's plain T-SQL)?
Sep
8
comment SQL Server 2005 Log Truncate - how long for a 60Gb log; mins, hours or days?
Ha, just found this gem. Probably worth reading all the question, comments, answers.
Sep
8
comment SQL Server 2005 Log Truncate - how long for a 60Gb log; mins, hours or days?
Good approximation, but still, OP says they're using FULL recovery model but with no FULL or LOG backups. In this case I'd say a switch to simple recovery and then shrink with truncate will suffice. And I'd try to plan for a sensible growth for the log file (if there's any past info). For my safety, I'd just configure at least a full backup plan and change the db to be in simple recovery model. But this needs to be planned carefully with the site owner (SLA..etc).
Sep
8
comment SQL Server 2005 Log Truncate - how long for a 60Gb log; mins, hours or days?
So you don't have any full or log backups?
Sep
3
reviewed Approve suggested edit on Configuration to stop mysql sleep
Aug
29
reviewed Approve suggested edit on calculating max and joining tables
Aug
28
reviewed Approve suggested edit on infosphere-data-architect tag wiki excerpt