9,798 reputation
11943
bio website careers.stackoverflow.com/cv/…
location Iasi, Romania
age 34
visits member for 3 years, 10 months
seen Nov 18 at 22:20

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:


Nov
4
reviewed Approve suggested edit on SSD vs HDD for databases
Nov
4
reviewed Approve suggested edit on opening_database
Nov
4
reviewed Approve suggested edit on Grouping data by MONTH on DATETIME column in SQL Server
Nov
1
reviewed Leave Closed The column order of composite clustered primary key on a partitioned table?
Nov
1
comment What does a high level overview of the logic backing database queries look like?
A short summary on what SQL Server does you can find here. A longer one can be found here: Understanding how SQL Server executes a query. PS: unfortunately the question seems too wide and will most likely get closed.
Nov
1
reviewed Close MySQL stops unexpectedly on CentOS 6.5 with WHM/Cpanel after migrating server with transfer tool
Nov
1
reviewed Close Cancel Query in remote ssms from ssms in my pc
Nov
1
reviewed Close Can you use CDC on a subscriber for transactional replicaiton
Oct
30
reviewed Approve suggested edit on odp.net tag wiki
Oct
30
reviewed Approve suggested edit on odp.net tag wiki excerpt
Oct
30
reviewed Approve suggested edit on Why am I getting cardinality issues when querying a single table
Oct
30
comment Why am I getting cardinality issues when querying a single table
With all due respect, I don't think @James's answer is a solution here (the article yes, it's brilliant, the proposed solution I don't think so because it's not feasible to do computed columns every time estimate/actuals don't match). And also it doesn't match what your own fix was. By seeing the execution plan we could've seen that your query doesn't use the composite index but probably does a table scan with implicit conversion on that condition (just a guess now).
Oct
30
comment Why am I getting cardinality issues when querying a single table
Can you post somewhere (pastebin/dropbox) the actual execution plan XML?
Oct
30
comment Why am I getting cardinality issues when querying a single table
How are your indexes looking? Do you have an index on both RateItemType and Status or distinct indexes on each?
Oct
30
reviewed Reject suggested edit on Cancel Query in remote ssms from ssms in my pc
Oct
29
reviewed Approve suggested edit on Char in select why
Oct
28
reviewed Approve suggested edit on Inconsistent information from different DMVs
Oct
28
awarded  Nice Answer
Oct
24
comment Corrupted mdf file causing the backup job to fail
@user2996309 BCP needs to be done table by table, indeed, but that shouldn't be an issue, there are articles like this or this or this or this that can help.
Oct
24
answered Corrupted mdf file causing the backup job to fail