19,172 reputation
456107
bio website sqlperformance.com/author/…
location New Zealand
age 45
visits member for 3 years, 5 months
seen 2 mins ago

Aug
21
comment Arithmetic overflow error
What is the name of the report you are trying to run? And what exact version of SQL Server and SSMS are you using?
Aug
21
comment Arithmetic overflow error
On closer inspection of the screenshot, it seems you are running one of the six standard reports at the instance node level that start with the word "performance". Which report are you running?
Aug
21
comment Arithmetic overflow error
What report? A built-in one? One you wrote yourself? I don't mean to be rude, but we're not psychic here - you have to provide detail if you want an answer!
Aug
21
comment Arithmetic overflow error
What were you doing that produced the error message? The screenshot is not terribly helpful, please add details.
Aug
21
comment Tuple relational calculus for all
'Homework'-type questions are not necessarily off-topic here but we do like to see evidence of effort.
Aug
14
comment Why does transaction log continue to grow in Simple recovery mode with nightly backups
Another thing to consider: an automatic checkpoint for a simple recovery database is only queued once the log is already 70% full. So, you might not need all that much log activity to result in growth, depending on timing.
Aug
11
comment Slow compilation of a SQL statement
How long does compilation take if you don't use the new cardinality estimator? (add OPTION (QUERYTRACEON 9481) to the query).
Aug
8
comment How to find when change tracking was enabled?
Just curious: what problem is this solving? I can't immediately think of a reason I'd need to know when CT was enabled (as opposed to checking the version I have versus CHANGE_TRACKING_MIN_VALID_VERSION)
Aug
8
comment Filtered index not chosen, and rejected with hint
@AdamRackis Speaking of the merge join, it's hard to be certain without seeing all the details, but you may be running up against this issue
Aug
7
comment SQL Server data structure (in protocol)
Ok FWIW I'm pretty certain there isn't any compression of the sort you are asking about. One wonders why you are concerned about this though.
Aug
7
comment SQL Server 2008 R2, error creating file for FileStream
HBSS? What's that?
Aug
7
comment SQL Server data structure (in protocol)
If you really want to dig into the protocol details, see the TDS documentation
Aug
7
comment Dropped index from view still referenced in execution plans
This would be a bug. I imagine it has been fixed now (2005 SP2 is quite old).
Aug
5
comment Update on view over partitioned tables updating all indexes
@user3789393 Complex partitioned view queries can be tricky to get optimal. It often/usually/always helps to keep things as simple as possible and e.g. use literals instead of variables, try OPTION (RECOMPILE) and so on. Aaron's proposed solution effectively does much of the optimizer's work by rewriting the update against the base tables. It's a perfectly good strategy, see how it works out for you. My aim was just to explain bits from the question that hadn't been addressed yet.
Aug
5
comment Update on view over partitioned tables updating all indexes
@user3789393 Always remember the costs (and percentages) seen in plans are always optimizer estimates based on a model. Always. Even in actual plans. The optimizer uses these costs to choose between strategies. There are ways to get a feel for actual performance, e.g. SET STATISTICS IO ON - reflected in the Table I/O tab of Plan Explorer but only when the query is run directly from P/E. Sorry there are lots of details in this area.
Aug
5
comment Update on view over partitioned tables updating all indexes
@user3789393 The plan fragments in my answer are taken directly from Statement1 in the anonymized execution plans you uploaded to the SQLpeformance.com Q & A site. I can't tell which numbers you are asking about. You'll have to be a bit more precise, or provide additional information. BTW I'm not saying this is a great plan, it's not, but you did ask why.
Aug
4
comment Update on view over partitioned tables updating all indexes
What plan do you get if you add OPTION (RECOMPILE) to the UPDATE query?
Aug
3
comment Linked Server Query Results: OPENQUERY vs Distributed Transactions
This question appears to be off-topic because it was cross-posted on SO and answered there.
Aug
3
comment How to merge multiple .ndf files into 1 .ndf file
Which database product are you using? SQL Server? Which version? How much data is in each partition? Do you have an offline maintenance window available for this work? Etc. Questions with more useful detail get better answers :)
Aug
1
comment Adding a sequence number to existing rows
It was Daniel's. I just made it look pretty and did the admin :)