Migrating from Windows server 2003 32-bit to Windows Server 2008 64-bit
The main thing is making sure you have installs for all your applications in 64-bit. Most installers are only for 32-bit and will not work on a 64-bit machine. Just making sure you can install all the programs you need is the first step. The second would be checking the vendors website or contacting their [...]

View Answer   |  November 2, 2010  1:54 PM
Active Directory, SQL 2005, Windows Server 2003, Windows Server 2003 32-bit, Windows Server 2008, Windows Server 2008 64-bit, Windows Server Migrations and Upgrades, Windows Server Upgrades

How do I INSERT records into AS400 DB2 file from SQL server?
Insert requires values of the correct type for all fields except those that allow nulls. It can use the default column sequence or you can include the column list. All fields of the primary key must have values and they must provide a unique key. Any other file constraints, foreign keys, unique keys and other [...]

View Answer   |  November 2, 2010  1:15 AM
AS/400, DB2/400, SQL Server, SQL Server 2005

cpyf and cpysplf: How to copy spool files and database files in AS/400?
This seems to be a very basic question. You need to look at the IBM manual for CL commands to get all the information You specify the From file and the to file You have options to add or replace records in the to file. You can select only certain records ffrom the from file. [...]

View Answer   |  May 13, 2013  7:03 PM
AS/400 Spool Files, CPYF, CPYSPLF, Database Files, RPG

Can’t log in after upgrading SQL Server 2005 express to SQL 2005 standard
Put the Standard DVD back in the drive and open the installer and manually install the client tools. If you didn’t have them installed before they wouldn’t have been upgraded.

View Answer   |  October 30, 2010  4:04 PM
SQL Server, SQL Server 2005 Standard Edition, SQL Server administration, SQL Server Express 2005, SQL Server Upgradation, SQL Server upgrades

Deleted items folder retention policy on exchange 2007
To use the Exchange Management Console to configure deleted item retention for a mailbox database 1. Open the Exchange Management Console. 2. In the console tree, expand Microsoft Exchange, then expand Server Configuration, and then select Mailbox. 3. On the Database Management tab in the work pane, expand the storage group that contains the mailbox [...]

View Answer   |  October 29, 2010  5:45 PM
Data Retention Policy, Deleted Items Retention Policy, Exchange 2007, Exchange policy management, Standard Edition

Migrating SQL Server 2000 to SQL Server 2005
All you need to do is detach the databases from the existing server, then attach them to the SQL Server 2005 instance. They will be upgraded automatically when they are attached.

View Answer   |  October 29, 2010  4:45 AM
Array, SQL Server 2000, SQL Server 2000 migration, SQL Server 2005, SQL Server migration, SQL Server Upgrade

Improve performance on Insert rows into DB2 400 table from SQL server
This is a question rather than an answer. I need to do exactly the same thing. I can update data on my server from the remote 400 but cannot move data from the server to the remote 400.

View Answer   |  October 28, 2010  5:17 PM
AS/400, DB2/400, Linked servers, SQL Server, SQL Server 2005

SQL Server 2005 Enterprise Edition SP3 Performance
based on the second screenshot you’ve got a lot of database tuning that needs to be done. This will require making index changes to improve your query time. This will reduce the SOS_SCHEDULER_YIELD and will probably reduce the disk IO access.

View Answer   |  October 28, 2010  5:13 AM
SQL, SQL performance, SQL Server, SQL Server 2005, SQL Server 2005 SP3, SQL Server Enterprise Edition

Extracting in SQL Server 2005
Your best bet would be to use a regular expression through a SQL CLR procedure.

View Answer   |  October 27, 2010  9:31 PM
EXTRACT, Field-Level keywords, SQL 2005, SQL 2005 Database, SQL Server 2005

ESXi v4.1 White Box
That looks fine. Just make sure that all the components are on the VMware Hardware Compatibility list.

View Answer   |  October 27, 2010  9:27 PM
ESXi, SQL Server, Virtual Machines, VMware ESXi, Web servers, Windows Server 2008

SQL SERVER 2005 Database Options
None will give you the best performance because no page verification is done. However if there is a corrupt page the database won’t find it until it tries to process the data within the page. The other values will do a set of checks which the pages are read looking to database corruption.

View Answer   |  October 27, 2010  9:25 PM
SQL, SQL Database, SQL Server, SQL Server 2005, SQL Server 2005 Database

SQL Server 2005 Memory
If you don’t have AWE then SQL Server can only use 2 Gigs of memory. With AWE the SQL Server can use the rest of the memory for the buffer cache. The private memory and procedure cache will stay within the first 2 Gigs.

View Answer   |  October 26, 2010  6:26 PM
SQL, SQL 2005, SQL Server, SQL Server 2005, SQL Server memory

Sponsor Post: VMware Expert Live Chat – Tuesday 10/26 at 11am EDT
Shillu13: Thanks for the link to the reminder email. ————————————————————————————- Hi everyone, Just a friendly reminder that TOMORROW is the live chat from 11am-2pm EDT. <b><a href=”http://itknowledgeexchange.techtarget.com/VMware-chat/”>Virtualizing Business-Critical Applications</a></b> will be LIVE with VMware experts. You’ll learn about application performance considerations, best practices and use cases for deploying Tier 1 applications on VMware. <a href=”http://itknowledgeexchange.techtarget.com/VMware-chat/”>Click [...]

View Answer   |  October 25, 2010  2:22 PM
Exchange Server, Infrastructure, Oracle, SAP, SQL Server, Virtualization, Virtualization and hardware, Virtualization how-tos, VMware, vSphere, Windows Server 2008, x86

How do I modify stored procedures in sql 2005?
No, none of that data is logged.

View Answer   |  October 23, 2010  11:48 PM
SQL 2005, SQL stored procedures

Rolling back a SQL server 2005 database.
You will need to restore the most recent full backup, then the log backups from the time the full was taken until the time you want to stop at.

View Answer   |  October 23, 2010  11:46 PM
SQL Server 2005, SQL Server administration, SQL Server Database Rollback, SQL Server Rollback

java
First u have install Oracle as well as java. I guess u know how to install & configure them both. after successful u insert the code below in ur java code. U must create a database in oracle to which u connect with java :- Connection connection = null; // Load the JDBC driver try [...]

View Answer   |  October 21, 2010  9:36 AM
Java 1.6, Java Database Connectivity, MySQL admin, SQL Server

SSRS 2008 from SSRS 2005, Authentication
SSRS 2008 doesn’t support anonymous authentication. There are some work arounds to make it work, but they aren’t supported.

View Answer   |  October 21, 2010  2:12 AM
SQL Server, SQL Server authentication, SQL Server Reporting Services, SQL Server Reporting Services 2008, SSRS 2005, SSRS 2008

Why does SQL server use no more than 500MB in RAM?
Do you have AWE enabled? If so it is normal for task manager to show the wrong amount. Verify using Perfmon to see how much RAM its actually using.

View Answer   |  October 15, 2010  6:50 PM
CPU, RAM, SQL, SQL Server, SQL Server 2005, SQL Server memory, Windows Server 2003 32-bit

Copy a SQL Binary Large Object (BLOB) from one database to another
I don’t know what you are trying to do. I suppose it is some kind of test. Also, I don’t see much relation between the question title and the code you posted. <b>You are getting the error because your source blob is null.</b> I would recommend taking a look at this: <a href=”http://soft.buaa.edu.cn/oracle/bookshelf/oreilly/bipack/ch08_03.htm”>DBMS_LOB Interface</a> But [...]

View Answer   |  October 14, 2010  7:56 PM
Binary Large Object, BLOB, SQL, SQL Database Transfer

Powershell 2
id recommend removing ver 1 as it seems to be causing a issue, if i recall PS 2 is required for SQL 2008 to function

View Answer   |  October 13, 2010  4:47 PM
PowerShell, PowerShell 2, SQL Server 2008, Windows Server 2008, Windows Update