16 posts tagged with mssql.
Displaying 1 through 16 of 16. 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

Help me Access my SQL!

Ok, I have an application that is using a back end of MS Access...I have another application that needs to get some of the data in the Access db but it is only SQL compatible. So...how do I set up an ODBC connection that will pull data from the Access db and write it out to a SQL db? This data needs to be updated hourly... Thanks for your assistance!
posted by keep it tight on Mar 14, 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

Building Oracle support into a Microsoft-only product

Currently Microsoft-only, but wanting to change our software soon to support Oracle as well. What are we getting ourselves into? [more inside]
posted by relucent on Jun 5, 2009 - 10 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


After working in a mostly LAMP (Linux, Apache, MySQL, PHP) environment the last few years, I need to make a quick switch to WISA (Windows, IIS, MS SQL, ASP). [more inside]
posted by gringoese on May 18, 2008 - 6 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

But I don't want to learn .NET!

How can I connect to a SQL Server 2005 database using windows authentication with PHP? [more inside]
posted by logic vs love on Mar 20, 2008 - 6 answers

Authentication across Windows, Linux, and Mac

How do you use a single authentication system for different kind of servers, systems, and workstations? [more inside]
posted by remi on Jan 11, 2008 - 6 answers

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

Where's Enterprise Manager?

I have Visual Studio 2005 Professional. I installed VS2k5Pro with all of the options except the sample databases on my WinXP box, but now I can't figure out how to access the Enterprise Manager - replacement ... Enterprise Management Studio, or even find out if that app is included with the version I have. Any suggestions?
posted by SpecialK on Aug 1, 2007 - 3 answers

Mapping drive to MSSQL table

Is there a way of mapping a Virtual Drive letter or a share to an MSSQL database? [more inside]
posted by seanyboy on Jan 30, 2007 - 6 answers


Looking for a dedicated server hosting provider [more inside]
posted by strawberryviagra on Oct 27, 2006 - 14 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