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

Aug
21
reviewed Looks OK Delete all the data from all tables
Aug
21
reviewed Looks OK ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist
Aug
21
reviewed Looks OK Profiling and debugging “Incorrect syntax was encountered while parsing :setvar.”
Aug
21
reviewed Close How to make MySQL log to 2 seperate remote servers?
Aug
21
reviewed Reopen Select on Table times out waiting for lock
Aug
21
reviewed Approve suggested edit on Select on Table times out waiting for lock
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
reviewed Reviewed Delete all the data from all tables
Aug
21
reviewed Reviewed Escape characters in Oracle dump
Aug
21
reviewed Reviewed Arithmetic overflow error
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
reviewed Leave Open Tuple relational calculus for all
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
21
reviewed Looks OK Delete all the data from all tables
Aug
21
reviewed Looks OK where clause: if this value from col x make sure col y is this value
Aug
21
reviewed Looks OK where clause: if this value from col x make sure col y is this value
Aug
21
reviewed Reviewed Can a High number of Worktables/sec and/or workfiles/sec lead to tempdb Contention?
Aug
21
reviewed Close How do I prove that the act of removing foreign keys doesn't corrupt existing data?