So, I've found the source of all the data I need in my database, but it is in a JSON file.
MSSQL cannot read JSON and the entire internet seems devoted to telling me how brilliant and easy JSON is and then giving me 20 pages of code to deal with it.
I don't have time to implement a JSON parse in C or anything like that.
I just need to put this perfectly simple bit of data into a database.
Can you help? [more inside]
posted by Just this guy, y'know
on Jun 27, 2013 -
MS SQL Pros, I need your help! What's causing MS SQL 2005 to import records so slowly? It's a persistent problem across all databases that just developed yesterday. Details inside... [more inside]
posted by antonymous
on Oct 20, 2009 -
I have been asked to make a proposal to upsize an Access database to allow for a few more concurrent users (currently 10) and ideally improve the overall performance of the system. Am I getting in over my head? [more inside]
posted by cbrody
on Mar 10, 2009 -
I need to import a database into MS SQL but I do not want to end up with a transaction log as large as the database. What's the best way to do the import? [more inside]
posted by odinsdream
on May 29, 2008 -
I have a set of dates/times in a MS SQL table that lack a timezone offset. I want to convert them to UTC, but I have to be mindful of Daylight Time for each of these dates (they're in the future). How can I convert them to UTC correctly? [more inside]
posted by dw
on Nov 13, 2007 -
Attention SQL gurus. This has me completely stumped. How can I find the index (position) of a row in a table without querying the entire set? [more inside]
posted by Civil_Disobedient
on Sep 3, 2006 -