Reputation
23,723
Top tag
Next privilege 25,000 Rep.
Access to site analytics
Badges
2 27 63
Newest
 Nice Answer
Impact
~1.6m people reached

Apr
30
answered MySQL is trimming my numbers and I can't figure out why
Apr
26
awarded  Nice Answer
Apr
13
comment MySQL is trimming my numbers and I can't figure out why
When I dump the values from the POST the values are correct. The INSERT statement is just grabbing the values from the POST and sticking them into an array, which is passed to the function which uses the code in the original section to run the query. The query is pretty simple. When I var_dump the array it has the decimal data in the value.
Apr
13
revised MySQL is trimming my numbers and I can't figure out why
Added the code to creat the table as requested.
Apr
13
comment MySQL is trimming my numbers and I can't figure out why
Sorry, been slammed and haven't had a chance to look back at this. @MaxVernon it's a WordPress plugin that I built myself. I'll update the question with the create table code that I used for the initial table creation.
Apr
9
awarded  Student
Apr
9
asked MySQL is trimming my numbers and I can't figure out why
Apr
7
awarded  Nice Answer
Feb
22
awarded  Nice Answer
Feb
22
comment How can I make a database backup go faster?
SAN snapshots are only useful when you don't need point in time recovery as you can't restore transaction logs on top of a database which you've taken a SAN snapshot of. I talked about this in this post (dcac.co/…) as well as an upcoming blog post.
Jan
3
awarded  Yearling
Dec
29
awarded  Nice Answer
Nov
30
comment What can be done, if anything, to tune a SharePoint database?
SharePoint doesn't handle index rebuilds and stats updates. You have to do that in SQL Server directly. As for splitting the content databases, that has to be done through SharePoint.
Nov
3
answered Non Clustered Index Scan Properties window - Predicate order different than query order
Oct
10
awarded  Revival
Oct
9
awarded  sql
Oct
8
awarded  Revival
Sep
27
answered database corruption
Sep
9
awarded  Nice Answer
Sep
4
comment Can't restore SQL Server db from full backup, log processing fails, database in 'restoring' state
Sounds like the source database is corrupt. Has anyone run DBCC CHRCKDB against the source server?