9,591 reputation
11840
bio website careers.stackoverflow.com/cv/…
location Iasi, Romania
age 33
visits member for 3 years, 8 months
seen 22 hours 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:


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
Aug
28
reviewed Approve suggested edit on infosphere-data-architect tag wiki
Aug
27
reviewed Approve suggested edit on blocking tag wiki excerpt
Aug
26
comment SQL Server 2008 R2 Express Silent Install - FullText Service Not working
According to the documentation, the parameter /FTSVCACCOUNT is unsupported on Windows Server 2008 and Windows Vista operating systems. What would make you think it is supported on an older (and currently unsupported) operating system? The default value is LocalService, so this is explained. Can you add a batch file to be executed after the installer runs? That way you can enable and start the service.
Aug
26
reviewed Approve suggested edit on ON DUPLICATE KEY UPDATE faster than UPDATE
Aug
14
awarded  Enlightened
Aug
14
awarded  Nice Answer
Aug
13
comment Can I install SQL Server Management Studio locally?
@Shanky I think you're nitpicking.. maybe the article title is a bit misleading, but each edition has two sections - Express and SSMS alone. If you scan the paragraph you can easily go to where you want. Even I, a non English language native, could find the link in a heartbeat. And the whole purpose of Hanselman's article is to gather in one place what MS didn't. So it's more useful than a direct download link, but it's only my opinion.
Aug
13
comment Can I install SQL Server Management Studio locally?
@Shanky And what's the problem with it? There's a section "Here's just SQL Server 2014 Management Studio" with necessary links.
Aug
10
reviewed Close Wildcard subnet mask for IPv6
Aug
7
reviewed Leave Open Is there a simple, safe and low cost way to implement a (limited) database to be outside (close) IT control?