Reputation
589
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
1 4 28
Newest
 Caucus
Impact
~34k people reached

17h
reviewed No Action Needed How can I associate different not done continuation blocks with two cursors in the same scope?
17h
reviewed No Action Needed How to get Business days per month between two dates?
1d
reviewed Reviewed will table partitioning and compression help heavily used OLTP database?
1d
comment will table partitioning and compression help heavily used OLTP database?
Your question pre-supposes this approach will not work, and in fact, I think you will be hard pressed to find proof it will not work. Partitioning is one of the best ways to improve performance in OLTP as well as OLAP. You can switch out partitions in seconds which would take log space and time to delete and you can do this while database is online. I use monthly partitions like this currently,
2d
reviewed Reviewed Migrating all MySQL databases from from one server another. Getting error during import
2d
comment Migrating all MySQL databases from from one server another. Getting error during import
Try the answers posed in this other question: stackoverflow.com/questions/10169960/…
2d
reviewed No Action Needed MySQL Matching records across tables discrepancies
Jul
29
reviewed No Action Needed PostGIS Intersects Query takes lot of time to get the result
Jul
28
reviewed No Action Needed MySQL: Converting Character set fails?
Jul
28
reviewed No Action Needed SQL Server : create dynamically queries to select all related data in DB based on entry table and ID
Jul
28
reviewed Reviewed Finding all date ranges that overlap a target date range
Jul
27
awarded  Caucus
Jul
27
reviewed Reviewed Finding two users with same pair group
Jul
27
comment Finding two users with same pair group
It would be helpful if you actually included the query you tried which did not work.
Jul
26
reviewed No Action Needed optimizing a wild card search query in mysql
Jul
26
reviewed No Action Needed “sqlplus as sysdba” startup error
Jul
17
reviewed No Action Needed Where can I find exact rules of a collation?
Jul
17
reviewed Reviewed Google Datastore (NoSQL) backend for PHP CMS
Jul
17
comment Google Datastore (NoSQL) backend for PHP CMS
Best to paraphrase and answer from a link or include the relevant text rather than just posting the link as the answer. see meta.dba.stackexchange.com/questions/100/…
Jul
17
reviewed No Action Needed DECODE or CASE STATEMENT for PARAMETER in WHERE CLAUSE