The SQL Server is only hosting 2 databases currently, and the largest is the one moving, so thresholding SQL back so they share resources shouldn't be a problem. Thanks for the assistance!

Performance tuning like that wasn't available on past versions of Microsoft's SQL Server, when tuning was regarded as a black art.

There is one commonality amongst all these professionals: no one has time to spare. Everyone wants to streamline processes and solve problems as quickly as possible and move on to the next issue of ...

SQL Sentry, Inc., a developer of software products that optimize the performance of Microsoft SQL Server environments, and DBSophic, a provider of performance management products for database-centric ...

We run JD Edwards' One World here on an NT 4 sql server. It's a pretty decent server but lately it's been running like a dog.It's a 4-way 450mhz Xeon(2mb cache) machine with 4gigs of ram. All ...

As any database admin knows, mastering the subtler nuances of SQL can be likened to the black arts. For me, tuning the efficiency of SQL queries on large, heavily used databases is a perfect ...

That is why bridging the SQL expertise gap is about so much more than simply plugging resource holes. It is about unlocking agility. With the right managed service and the right platform, your teams ...

SQL performance tuning, which 78% of database developers say they do manually, can take up large amounts of time; 73% cited it as their biggest time commitment. Automating SQL performance tuning with ...

SQL Server 2005 introduces a new tool, the Database Engine Tuning Advisor, which replaces the functionality of the Index Tuning Wizard and provides even more information than its predecessor.