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


1d
comment MS SQL Server Implement Limit Functionality
This will be your answer. Also see here some detailed description.
Apr
16
reviewed Leave Open Reference assembly in sqlproj not being deployed to server
Apr
16
reviewed Close Every 30 minutes mysql stuck for 20-30 seconds
Apr
16
reviewed No Action Needed Check for table corruption
Apr
16
reviewed Reject suggested edit on Mysql Master Offline
Apr
15
awarded  Proofreader
Apr
15
reviewed Approve suggested edit on Get first login-Hit on huge table
Apr
15
reviewed Approve suggested edit on galera tag wiki excerpt
Apr
15
reviewed Approve suggested edit on Which version of linux OS has support for MongoDB installation?
Apr
15
reviewed Approve suggested edit on Help me improve my query
Apr
14
reviewed Reject suggested edit on why does mysql query running slower on server?
Apr
14
reviewed Reject suggested edit on MYSQL 5.5 Fail start Fedora 16
Apr
14
reviewed Reject suggested edit on From freelancer to team of two : best way to share/sync db?
Apr
12
comment SMS Suggesting covering all columns in an index?
As @JonSeigel asked, could this be a case where the clustered index could be changed to be build on the FileId? This would remove the necessity for a fully covering index, but only you know if this query is important enough to base your table ordering on this column. Other than that, Ypercube's question is legitimate. Can you test with a NC index on that FK column alone?
Apr
12
reviewed Approve suggested edit on How to access external DLL's static methods that incorporate output parameters in SQL Server
Apr
11
comment Best database for fast read all in one table
If you pass the table structure (columns and datatypes, also useful would be indexes that will suit your querying patterns), we may be able to estimate (roughly) the table size. But I suspect 4 million rows won't be an overkill (you said the filtering is always a perfect match). Is your db schema normalized or are we talking about a single table?
Apr
10
reviewed Reject suggested edit on How to Configure PostgreSQL Hotstandby Automatic Failover
Apr
7
reviewed Approve suggested edit on How do I Delete A Database And Log Files With SQL 2008 Script?
Apr
6
reviewed Close SQL string field lengths in a db having about 6 different types of addresses, with about 20 markets and environments
Apr
6
reviewed Leave Open Drastic performance difference in View Dependencies between SQL Server 2005 and 2008 R2