9,737 reputation
11943
bio website careers.stackoverflow.com/cv/…
location Iasi, Romania
age 34
visits member for 3 years, 9 months
seen 56 mins 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:


21h
reviewed Approve suggested edit on odp.net tag wiki
21h
reviewed Approve suggested edit on odp.net tag wiki excerpt
21h
reviewed Approve suggested edit on Why am I getting cardinality issues when querying a single table
23h
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).
23h
comment Why am I getting cardinality issues when querying a single table
Can you post somewhere (pastebin/dropbox) the actual execution plan XML?
1d
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?
1d
reviewed Reject suggested edit on Cancel Query in remote ssms from ssms in my pc
1d
reviewed Approve suggested edit on Char in select why
2d
reviewed Approve suggested edit on Inconsistent information from different DMVs
2d
awarded  Nice Answer
2d
comment SQL server transaction log recovery
And where's the diff backup in this sequence? What's the exact order of steps?
Oct
27
reviewed Approve suggested edit on inserting information into database tables created using wamp server
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
Oct
23
comment Disk space Report for CMS
This question appears to be off-topic because it is about "gimme teh codez". Please show us your try first. Before requesting anyone's help you need to show you've done your bit.
Oct
23
reviewed Approve suggested edit on How to change table with innodb/myisam engine to federated
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?