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

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

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

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

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

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

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

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

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

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

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