Reputation
Top tag
Next privilege 50 Rep.
Comment everywhere
Badges
4
Newest
 Scholar
Impact
~177 people reached

  • 0 posts edited
  • 0 helpful flags
  • 4 votes cast
Feb
1
comment Manage multiple short-term tables with same schema or use single table for short-term data?
Will do. There will be a round of testing various designs first.
Feb
1
awarded  Scholar
Feb
1
accepted Manage multiple short-term tables with same schema or use single table for short-term data?
Jan
31
awarded  Editor
Jan
31
revised Manage multiple short-term tables with same schema or use single table for short-term data?
clarify that data in session table is relational and will be joined to other db tables
Jan
31
comment Manage multiple short-term tables with same schema or use single table for short-term data?
Yes, for durability. Also because complex business logic is calculated at login, that governs how the user is allowed to interact with the rest of the system.
Jan
30
comment Manage multiple short-term tables with same schema or use single table for short-term data?
This is a Java application server. It has a pool of threads that all need to have access to the table(s). I thought a global temp table would support this.
Jan
30
comment Manage multiple short-term tables with same schema or use single table for short-term data?
Using global temp tables might be practicable. Let's assume for now that these short-term tables are in a user database. The POC for this project uses a user database.
Jan
30
asked Manage multiple short-term tables with same schema or use single table for short-term data?
Nov
13
awarded  Supporter
Jul
6
comment How can I find out which statistics are evaluated by the optimizer?
Yes, those are the links I found yesterday by following the link in Aaron's answer.
Jul
5
comment How can I find out which statistics are evaluated by the optimizer?
Btw I'm a heavy user of the SQL Sentry Plan Explorer. Thank you for the freebie.
Jul
5
comment How can I find out which statistics are evaluated by the optimizer?
The link you provided has a link to IMO a better post on how to use traceflags to see the statistics being used. Thank you.
Jul
5
comment How can I find out which statistics are evaluated by the optimizer?
I'll give an example of the kind of thing we've experienced. In a production system with an ad-hoc statistics entity, a certain query ran quickly and successfully. The execution plan indicates it performed a SEEK on index X. When we dropped the statistics, the same query failed. The execution plan changed dramtically; it now performs a SCAN. As it turns out that the join logic in the query is joining int to varchar, and doing implicit conversion on the varchar. We now recognize this as a risk, and we don't want to make more changes without full understanding.
Jul
5
comment How can I find out which statistics are evaluated by the optimizer?
I should mention that we have disabled the AUTOCREATE STATISTICS option in our production environments.
Jul
5
awarded  Student
Jul
5
asked How can I find out which statistics are evaluated by the optimizer?