8 posts tagged with sql and mssql.
Displaying 1 through 8 of 8. Subscribe:

How can I do... anything? with this JSON file?

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 - 11 answers

SQL - Accurately show how many rows an UPDATE statement is going to affect before execution.

SQL - How to get an accurate count of the rows potentially affected by an UPDATE statement, or best practices for performing updates? [more inside]
posted by odinsdream on Feb 9, 2010 - 18 answers

MS SQL please speed up so i dont cry

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 - 9 answers

Upsize Access database?

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 - 11 answers

How can I import a 46GB database into MSSQL without ending up with a 46GB transaction log?

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 - 4 answers

It keeps growing and growing and growing...

Help me understand MSSQL logs... At least enough to do what I need to do. [more inside]
posted by eas98 on Mar 28, 2008 - 1 answer

Right Place, Wrong Time

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 - 3 answers

A query connundrum.

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 - 12 answers

Page: 1