Daily Question and Answer Update for Feb 3, 2009

New questions and answers have been added to the community for the following
tags:
- CRM
- Database
- DataCenter
- DataManagement
- Development
- Linux
- Microsoft Windows
- Mobile
- Networking
- Oracle
- SAP
- Security
- SQL Server
- Storage
- Virtualization
- VoIP
Continue the conversation. Answer or discuss a question and earn Knowledge
Points.

-----------------------------------------------------------------------
CRM UPDATES
-----------------------------------------------------------------------

:::::::::::::::::::::::::: ADVERTISEMENT :::::::::::::::::::::::::::
Sponsored by: ITKE

View all CRM related Questions and Answers
http://go.techtarget.com/r/5747559/4946246/1
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

NEW DISCUSSION on:
What are the most overused tech buzzwords for 2008?

DISCUSSION from Oldbogeydog:
"White Paper"

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5747526/4946246/2

-----------------------------------------------------------------------
DATABASE UPDATES
-----------------------------------------------------------------------

:::::::::::::::::::::::::: ADVERTISEMENT :::::::::::::::::::::::::::
Sponsored by: TechTarget

Read the most targeted, up-to-the-minute news and exclusive features on
pertinent Windows topics.
http://go.techtarget.com/r/5747517/4946246/3

Our newsletters provide the latest Windows-based tips, tutorials, e-guides and
more straight to your inbox.
http://go.techtarget.com/r/5747517/4946246/4

Attend free events to get expert advice on topics such as desktop
virtualization and email archiving.
http://go.techtarget.com/r/5747517/4946246/5

Access research libraries, RSS feeds, ask the expert pages, and other great
resources.
http://go.techtarget.com/r/5747517/4946246/6

Each site provides you with information on a different Windows discipline -
find out more now!
http://go.techtarget.com/r/5747517/4946246/7
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

UPDATED ANSWER on:
Configuring a SQL Server to optimize for best performance

ANSWER from Dschwant:
The only way to truly optimize performance is to monitor (using
perfmon/profiler) and test.

You need someone with the expertise to do this, or someone who can learn the
rudimentary tools and give it a shot. But, I would recommend either hiring a
consultant (I can give some recommendations) or may...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5747548/4946246/8

-----------------------------------------------------------------------
NEW ANSWER on:
Subscript beyond count on nested table (trying to update a column in a trigger
for the same table as trigger)

ANSWER from Carlosdl:
That error usually arises when you try to access a non-existent element on a
collection.

To debug this, you could place all the code inside the for loop in an
if-then-else block to make sure you are referencing only existent elements.

Something like this:

[CODE]for i in g_change_tab.first.....

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5747537/4946246/9

-----------------------------------------------------------------------
NEW ANSWER on:
How to call trigger stored in database using Oracle Forms

ANSWER from Carlosdl:
You can't call database triggers directly. You should use a stored procedure
instead.

You can call stored procedures the same way you do for Forms local procedures.

Please provide more information if you need further help.

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5747539/4946246/10

-----------------------------------------------------------------------
NEW DISCUSSION on:
Reports go blank with Oracle 10g using JReport (work perfect with Oracle 9i)

DISCUSSION from Carlosdl:
Have you re-compiled your report against the 10g database ?

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5747540/4946246/11

-----------------------------------------------------------------------
NEW ANSWER on:
Connecting to Oracle with Visual Basic 2005?

ANSWER from Carlosdl:
Your question is not clear enough, at least for me.
You should be able to connect from any version of Visual Basic to an Oracle
database.

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5747542/4946246/12

-----------------------------------------------------------------------
NEW ANSWER on:
Crystal Reports OBDC (Oracle)

ANSWER from Carlosdl:
Are you using the same database user when connecting from Crystal than when
connecting from Access ?
It could be a problem of missing privileges or synonyms.

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5747543/4946246/13

-----------------------------------------------------------------------
NEW DISCUSSION on:
What are the most overused tech buzzwords for 2008?

DISCUSSION from Oldbogeydog:
"White Paper"

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5747526/4946246/14

-----------------------------------------------------------------------
NEW ANSWER on:
Sending a message from Access thru Lotus

ANSWER from Mimo:
replace de disign of you database to a 6.5 template. it should work

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5747605/4946246/15

-----------------------------------------------------------------------
NEW ANSWER on:
Career advice for moving from development to SAP

ANSWER from Irina:
Really, you, Aditi, have a good skill for SAP. With your knolewdge of Java it
is possible to be SAP Portal Developer or XMII Developer. But if development is
not interested for you any more you always could try to be a SAP tester.

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5747606/4946246/16

-----------------------------------------------------------------------
NEW DISCUSSION on:
delete from flat file

DISCUSSION from Gilly400:
Hi,

Try running the command from the interactive SQL first (STRSQL) - if this
works, use the same command in your RPG.

Regards,

Martin Gilbert.

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5747530/4946246/17

-----------------------------------------------------------------------
NEW ANSWER on:
getting started in security

ANSWER from Labnuke99:
A good understanding of network fundamentals will help you. The Cisco
certifications are vendor specific but will teach you a lot of foundational
knowledge. The CompTia Network+ is not vendor specific and will help you also.
A good mix of both vendor-specific and general education will be the best p...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5747589/4946246/18

-----------------------------------------------------------------------
NEW QUESTION on:
ESX luns allocated on Symmetrix will not format.

QUESTION from Emcsanman:
Recently we allocated Symmetrix space for an ESX cluster. Some of the LUNs
format fine but one or two come up with an error message that says "unable to
read partition information from this disk." All of the luns were exactly the
same capacity. The ESX is currently attached to a Symmetrix array as w...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5747601/4946246/19

-----------------------------------------------------------------------
DATACENTER UPDATES
-----------------------------------------------------------------------

:::::::::::::::::::::::::: ADVERTISEMENT :::::::::::::::::::::::::::
Sponsored by: TechTarget

Read the most targeted, up-to-the-minute news and exclusive features on
pertinent Windows topics.
http://go.techtarget.com/r/5747517/4946246/20

Our newsletters provide the latest Windows-based tips, tutorials, e-guides and
more straight to your inbox.
http://go.techtarget.com/r/5747517/4946246/21

Attend free events to get expert advice on topics such as desktop
virtualization and email archiving.
http://go.techtarget.com/r/5747517/4946246/22

Access research libraries, RSS feeds, ask the expert pages, and other great
resources.
http://go.techtarget.com/r/5747517/4946246/23

Each site provides you with information on a different Windows discipline -
find out more now!
http://go.techtarget.com/r/5747517/4946246/24
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

NEW QUESTION on:
Subversion SVN) on NFS (NetApp)

QUESTION from T0ns:
I have some performane issues on my Subversion (SVN) server on NFS, before we
migrate our data to NFS (NetApp storage) it is in a local hard drive of the
server and the check-out is fast, compare to NFS the time it took is double.
Does any body here have some best practices on Subversion on NFS? We ...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5747560/4946246/25

-----------------------------------------------------------------------
UPDATED ANSWER on:
Default output queue for Dumps

ANSWER from ITKE:
ANSWER
Tjgm88 | Feb 2 2009 9:41PM GMT

We finally found the problem which caused this in the first place, after
contacting IBM.
It appears that on the old system, the system printer files were directed to
the various out queues. When we went to the new machine, no one knew that this
had to b...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5747522/4946246/26

-----------------------------------------------------------------------
NEW ANSWER on:
How to calculate the CPW for AS/400 system?

ANSWER from Lovemyi:
You need to consult the System Builder Redbook or Redpiece for the CPW rating
for your machine. That will be based upon the model, processor feature,
tserver feature and number of activated processors out of the actual number of
processors included in the machine for some COD (Capacity on Demand) s...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5747524/4946246/27

-----------------------------------------------------------------------
NEW DISCUSSION on:
AS400 DDS Specifications and Arrays

DISCUSSION from Krttrs:
I agree with the other posts.
But I would like to say "get away from the M36 environment" if you can. My
experience is that you will eventually convert to an iSeries S/36 emulation
environment from the S/36 "Machine" running under OS400 ( I5/OS ). S36
emulation on the iSeries is much bett...

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5747525/4946246/28

-----------------------------------------------------------------------
NEW DISCUSSION on:
What are the most overused tech buzzwords for 2008?

DISCUSSION from Oldbogeydog:
"White Paper"

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5747526/4946246/29

-----------------------------------------------------------------------
NEW DISCUSSION on:
VERY slow server startup and shutdown

DISCUSSION from NetSupport:
If you're using SBS 2003 check this.

Subject: SBS 2003 Slow to Shutdown

http://support.microsoft.com/?kbid=827610

Start Registry Editor. To do this, click Start, click Run, type regedit in the
Open box, and then click OK.
Locate and then click the following registry subkey:
HKEY_LOCAL...

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5747561/4946246/30

-----------------------------------------------------------------------
UPDATED ANSWER on:
AS/400 QADBIFLD error Duplicate Record Key?

ANSWER from WaltZ400:
You can do a RCLSTG SELECT(*DBXREF). What this does is a reclaim of the DB
cross reference files only and runs faster than doing a RCLSTG SELECT(*ALL)
which touches every library on the system. We had to do this once when the
cross reference got hosed up.

As always, the system needs to be in d...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5747529/4946246/31

-----------------------------------------------------------------------
NEW ANSWER on:
VMware ESX 3.5 not able to create a new datastore

ANSWER from Aguacer0:
I'm assuming you are using the local drives to your server to host your
datastore? Did you partition the free space with VMFS during installation?
If you didn't then you will need to first do a scan to confirm it can see the
drive.

Within the VI Client, do the following:
1) highlight your es...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5747562/4946246/32

-----------------------------------------------------------------------
NEW QUESTION on:
Oracle apps

QUESTION from RPGsadhu:
How to handle manufacturing, in oracle apps?

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5747544/4946246/33

-----------------------------------------------------------------------
DATAMANAGEMENT UPDATES
-----------------------------------------------------------------------

:::::::::::::::::::::::::: ADVERTISEMENT :::::::::::::::::::::::::::
Sponsored by: TechTarget

Read the most targeted, up-to-the-minute news and exclusive features on
pertinent Windows topics.
http://go.techtarget.com/r/5747517/4946246/34

Our newsletters provide the latest Windows-based tips, tutorials, e-guides and
more straight to your inbox.
http://go.techtarget.com/r/5747517/4946246/35

Attend free events to get expert advice on topics such as desktop
virtualization and email archiving.
http://go.techtarget.com/r/5747517/4946246/36

Access research libraries, RSS feeds, ask the expert pages, and other great
resources.
http://go.techtarget.com/r/5747517/4946246/37

Each site provides you with information on a different Windows discipline -
find out more now!
http://go.techtarget.com/r/5747517/4946246/38
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

NEW QUESTION on:
Subversion SVN) on NFS (NetApp)

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5747560/4946246/39

-----------------------------------------------------------------------
NEW ANSWER on:
Crystal Reports OBDC (Oracle)

ANSWER from Carlosdl:
Are you using the same database user when connecting from Crystal than when
connecting from Access ?
It could be a problem of missing privileges or synonyms.

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5747543/4946246/40

-----------------------------------------------------------------------
NEW DISCUSSION on:
What are the most overused tech buzzwords for 2008?

DISCUSSION from Oldbogeydog:
"White Paper"

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5747526/4946246/41

-----------------------------------------------------------------------
UPDATED ANSWER on:
AS/400 QADBIFLD error Duplicate Record Key?

As always, the system needs to be in d...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5747529/4946246/42

-----------------------------------------------------------------------
NEW ANSWER on:
Data Migration Testing

ANSWER from Mimo:
When you talk about Data migration. First you need to know the type of Data,
like DB, CIFS non structured data, etc, what kind of file system you migrate,
from what technology to what technology. Is the File systems (FS) are SAN,
NAS, directe attached, Virtual Luns,

After you need to know who i...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5747607/4946246/43

-----------------------------------------------------------------------
UPDATED ANSWER on:
Duplicate IP addresses?

ANSWER from Labnuke99:
Computer should not be sharing an IP Address. Each machine will need its own
IP address so that the computers now how to talk to each other.

If one computer is on, and your router reboots then another computer is turned
on then both machines could be issued the sameIP address. Because of this i...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5747591/4946246/44

-----------------------------------------------------------------------
NEW QUESTION on:
Conditional Parameters - Crystal Reports 9

QUESTION from AnJoMi18:
Hi,

I want to create linked parameters so that the user will be given different
parameters based on a previous choice. Can this be done in Crystal 9??

Example - User is given 2 parameters P1 & P2, both are mandatory. Depending on
the input for P2, then i want P3 or P4 to be displayed.....

...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5747608/4946246/45

-----------------------------------------------------------------------
NEW ANSWER on:
Autocad

ANSWER from JHOLDER:
VIEWRES

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5747609/4946246/46

-----------------------------------------------------------------------
DEVELOPMENT UPDATES
-----------------------------------------------------------------------

:::::::::::::::::::::::::: ADVERTISEMENT :::::::::::::::::::::::::::
Sponsored by: TechTarget

Read the most targeted, up-to-the-minute news and exclusive features on
pertinent Windows topics.
http://go.techtarget.com/r/5747517/4946246/47

Our newsletters provide the latest Windows-based tips, tutorials, e-guides and
more straight to your inbox.
http://go.techtarget.com/r/5747517/4946246/48

Attend free events to get expert advice on topics such as desktop
virtualization and email archiving.
http://go.techtarget.com/r/5747517/4946246/49

Access research libraries, RSS feeds, ask the expert pages, and other great
resources.
http://go.techtarget.com/r/5747517/4946246/50

Each site provides you with information on a different Windows discipline -
find out more now!
http://go.techtarget.com/r/5747517/4946246/51
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

NEW QUESTION on:
How to make installer of vb.net including sql server 2000?

QUESTION from Rebi977:
I had done my project in vb.net with sql server 2000 but it's installer doesn't
work properly as it displays the message unexcepted error while connecting to
the database.I know setup and deployment in vb.net but doesn't working please
help me.I am stuck in here.thanks in advance.

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5747546/4946246/52

-----------------------------------------------------------------------
NEW ANSWER on:
ASP1 to ASP6library link

ANSWER from MurrayInfoSys:
Shivaratna -
I believe that by definition, what happens in ASPn Stays in ASPn.

You can not cross ASP dotted lines.

I must express that I have not tried to cross this expressed dotted line or
even thought of the idea.

Phil
MIS

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5747610/4946246/53

-----------------------------------------------------------------------
NEW QUESTION on:
converting date time

QUESTION from Zubairm76:
hi all,

I have a column called WBsstartdate (storing dates), that has been created as a
Varchar data type.
If I run a convert on the table, my date comes out in the right format.
(Eg: 2006-04-03 00:00:00). This is fine.
However when I run this date as an sql query in a programme in C#, and sa...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5747611/4946246/54

-----------------------------------------------------------------------
UPDATED ANSWER on:
Pulling multiple values in the same line in SQL

ANSWER from Dschwant:
Doing this requires the use of a function. Something like this.

[CODE]CREATE FUNCTION YourFunction (@UserId varchar(10))
RETURNS VARCHAR(4000)
BEGIN
DECLARE @Return VARCHAR(4000)

SET @Return = ''

DECLARE @error_code VARCHAR(10)

DECLARE cur CURSOR FOR SELECT Error_code FROM You...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5747552/4946246/55

-----------------------------------------------------------------------
NEW ANSWER on:
Connecting to Oracle with Visual Basic 2005?

ANSWER from Carlosdl:
Your question is not clear enough, at least for me.
You should be able to connect from any version of Visual Basic to an Oracle
database.

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5747542/4946246/56

-----------------------------------------------------------------------
NEW DISCUSSION on:
What are the most overused tech buzzwords for 2008?

DISCUSSION from Oldbogeydog:
"White Paper"

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5747526/4946246/57

-----------------------------------------------------------------------
NEW QUESTION on:
update text box using Javascript

QUESTION from Usm:
I have a script which select from database and display
customer name in dropdown list
I want update the email field(textbox) with the customer email address
the script run javascript function
top.frPrint.location.href = '/form.php?action=".FIND_EMAIL."&id='+idCustomer;

in external php code a...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5747612/4946246/58

-----------------------------------------------------------------------
UPDATED ANSWER on:
Passing an array into a Stored Procedure

ANSWER from Msi77:
No, SQL Server doesn't support array's an input parameters. SQL Server 2008
allows you to use a table variable as an input parameter.

Your best option will be to create an XML Document and pass the XML document to
the stored procedure, then parse the XML document using [A
href="http://itknowledg...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5747558/4946246/59

-----------------------------------------------------------------------
NEW DISCUSSION on:
VERY slow server startup and shutdown

DISCUSSION from NetSupport:
If you're using SBS 2003 check this.

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5747561/4946246/60

-----------------------------------------------------------------------
UPDATED ANSWER on:
Need help with SQL commands

ANSWER from SANManJax:
You will need to key off a common field and replace the bad data in the first
table with the corresponding good data from the second table.

To illustrate:

[CODE]
Table 1 Table 2
---------- ------------
Table1.Name Table2.Name
Table1.Address Table2.Address
Table1.Phone ...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5747613/4946246/61

-----------------------------------------------------------------------
NEW ANSWER on:
Data Migration Testing

After you need to know who i...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5747607/4946246/62

-----------------------------------------------------------------------
UPDATED ANSWER on:
How to add CRLF to a CL Message

ANSWER from Tw:
I found that hex '25' is the value for LF (Line Feed).

I defined a variable for x'0D25' and it worked.

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5747532/4946246/63

-----------------------------------------------------------------------
NEW ANSWER on:
How do you convert Executive Asst.1 to EXECUTIVE ASST.1

ANSWER from Carlosdl:
It will depend on what programs/databases you are using.

In a query, it should be something similar to:

[CODE]SELECT UPPER(yourField)
FROM yourTable[/CODE]

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5747614/4946246/64

-----------------------------------------------------------------------
NEW DISCUSSION on:
Software testing - Can anyone help me in this?

DISCUSSION from LightsOutLester:
What do you mean by system? A test system?
Are you talking about a tool that can Manage tests and do the testing or act as
a manager and a tester as a role in a business scenario?

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5747615/4946246/65

-----------------------------------------------------------------------
NEW DISCUSSION on:
How to gauge performance of software testing tools?

DISCUSSION from LightsOutLester:
Can you be more specific? The question is quite broad.
Performance has many aspects.

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5747616/4946246/66

-----------------------------------------------------------------------
LINUX UPDATES
-----------------------------------------------------------------------

:::::::::::::::::::::::::: ADVERTISEMENT :::::::::::::::::::::::::::
Sponsored by: ITKE

View all Linux related Questions and Answers
http://go.techtarget.com/r/5747573/4946246/67
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

UPDATED ANSWER on:
Upgrade from Oracle 10g2 to Oracle 10g4 on Linux

ANSWER from Carlosdl:
What exactly do you mean with 10g2 and 10g4 ?
Could you please provide the exact version numbers ?

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5747536/4946246/68

-----------------------------------------------------------------------
NEW DISCUSSION on:
What are the most overused tech buzzwords for 2008?

DISCUSSION from Oldbogeydog:
"White Paper"

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5747526/4946246/69

-----------------------------------------------------------------------
NEW DISCUSSION on:
How to configure DNS in CentOS

DISCUSSION from Petkoa:
Hi Jeetendra,

I'll try to systematize the discusion alittle ;o) So, what do you intend to
accomplish on your CentOS box - (a) to get domain names resolved for the box,
(b) to get them resolved for a number of hosts on your network, or (c) to run a
DNS server for your zone (or yours and some slav...

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5747574/4946246/70

-----------------------------------------------------------------------
UPDATED ANSWER on:
How does one guarantee the integrity of snapshot done at block level

ANSWER from ISCSIdude:
Are you asking is there a way to have the Equallogic snapshot function force
the database to flush all pending operations to disk before taking the
snapshot?

If this is what you are asking, then out of the box, the answer is no. I've
never done this before, but Equallogic provides some perl ex...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5747575/4946246/71

-----------------------------------------------------------------------
MICROSOFT WINDOWS UPDATES
-----------------------------------------------------------------------

:::::::::::::::::::::::::: ADVERTISEMENT :::::::::::::::::::::::::::
Sponsored by: TechTarget

Read the most targeted, up-to-the-minute news and exclusive features on
pertinent Windows topics.
http://go.techtarget.com/r/5747517/4946246/72

Our newsletters provide the latest Windows-based tips, tutorials, e-guides and
more straight to your inbox.
http://go.techtarget.com/r/5747517/4946246/73

Attend free events to get expert advice on topics such as desktop
virtualization and email archiving.
http://go.techtarget.com/r/5747517/4946246/74

Access research libraries, RSS feeds, ask the expert pages, and other great
resources.
http://go.techtarget.com/r/5747517/4946246/75

Each site provides you with information on a different Windows discipline -
find out more now!
http://go.techtarget.com/r/5747517/4946246/76
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

UPDATED ANSWER on:
Configuring a SQL Server to optimize for best performance

ANSWER from Dschwant:
The only way to truly optimize performance is to monitor (using
perfmon/profiler) and test.

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5747548/4946246/77

-----------------------------------------------------------------------
NEW QUESTION on:
Creating Site in SharePoint, but Loads a Blank Screen

QUESTION from Andrew12345:

Hi ,

I am currently setting up MOSS 2007 to run on Vista on my laptop. I have
Central Administrator running and I can create a new site fine.

The problem is when I load the new site in a browser it just loads a blank
page.

A similar thing happen when I first ran Central Admin but I got ar...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5747576/4946246/78

-----------------------------------------------------------------------
NEW DISCUSSION on:
Laptop cannot detect home WLAN server

DISCUSSION from Wlannovice:
Thank you very much for your answer Admin89, wireless connection is enabled on
the T42 in question and automatic IP as well.

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5747577/4946246/79

-----------------------------------------------------------------------
NEW DISCUSSION on:
What are the most overused tech buzzwords for 2008?

DISCUSSION from Oldbogeydog:
"White Paper"

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5747526/4946246/80

-----------------------------------------------------------------------
UPDATED ANSWER on:
Port Forwarding with Cisco 3560

ANSWER from Ihsan:
You can do this by applying PBR (Policy Based Routing). See below a very
simple config. You can amend the PBR rules in below ACL

[B]1. Define your PBR rule ACL [/B]

[CODE][CODE]ip access-list extended PBR
permit ip any any eq 80
permit ip any any eq 445[/CODE]

[B]2. Define next hop[/B]...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5747578/4946246/81

-----------------------------------------------------------------------
NEW DISCUSSION on:
How to configure DNS in CentOS

DISCUSSION from Petkoa:
Hi Jeetendra,

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5747574/4946246/82

-----------------------------------------------------------------------
UPDATED ANSWER on:
Using VMware to migrate files in Windows Server 2003 environments

ANSWER from Aguacer0:
Hello
You have two options here....

1. If you want to keep Win 2003 as the host OS then they would have to use
VMware Server
2. If you are willing to replace the host OS with ESXi then use that and
install all the apps inside new guest VMs inside ESXi

Hope that helps!

Thank you,
David Da...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5747579/4946246/83

-----------------------------------------------------------------------
UPDATED ANSWER on:
Where does the rest of the memory space in diskettes go?

ANSWER from 3dinfluence:
When you look at the raw disk size in something like fdisk or other disk
partitioning tool you'll see that in most cases the size of the drive reported
by the tool doesn't match the size that the manufacturer's label says. This is
due to a somewhat ambiguous definition of megabyte and gigabyte.

...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5747580/4946246/84

-----------------------------------------------------------------------
NEW ANSWER on:
Microsoft Exchange 2003 On Windows Server 2003 64-bit

ANSWER from Aguacer0:
From my experience, Exchange needs to be installed on the same set as the OS
due to Exchange files.

This link should clarify if you are interested:
http://msexchangeteam.com/archive/2005/07/11/407529.aspx

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5747570/4946246/85

-----------------------------------------------------------------------
NEW ANSWER on:
Need to get exchange server working with windows server 2003

ANSWER from Aguacer0:
Here are good instructions to use:

http://computerperformance.co.uk/exchange2003/exchange2003_recovery_options.htm

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5747571/4946246/86

-----------------------------------------------------------------------
UPDATED ANSWER on:
Log onto to Windows w/o username or password

ANSWER from KarlG:
Here?s the link to download Offline NT Password and Registry Editor and
instruction on how to use it.
If your computer allows booting from floppy disk or cdrom, your Windows?
password can also be reset using some boot disk or CD like that one. You should
disable booting from any disk, like flop...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5747581/4946246/87

-----------------------------------------------------------------------
NEW QUESTION on:
Templates in Microsoft Word 2003

QUESTION from BrentSheets:
This drove me nuts, too. All you need to do is open the Normal.DOT template and
check the [I]View > Header and Footer[/I] option and then save the template.
Then you'll be all set. I'll never understand why the Header and Footer View
isn't the default.

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5747582/4946246/88

-----------------------------------------------------------------------
NEW DISCUSSION on:
Windows login

DISCUSSION from Carlosdl:
Does it happen with every computer on the domain ?
Are you using roaming profiles ?

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5747583/4946246/89

-----------------------------------------------------------------------
MOBILE UPDATES
-----------------------------------------------------------------------

:::::::::::::::::::::::::: ADVERTISEMENT :::::::::::::::::::::::::::
Sponsored by: TechTarget

Read the most targeted, up-to-the-minute news and exclusive features on
pertinent Windows topics.
http://go.techtarget.com/r/5747517/4946246/90

Our newsletters provide the latest Windows-based tips, tutorials, e-guides and
more straight to your inbox.
http://go.techtarget.com/r/5747517/4946246/91

Attend free events to get expert advice on topics such as desktop
virtualization and email archiving.
http://go.techtarget.com/r/5747517/4946246/92

Access research libraries, RSS feeds, ask the expert pages, and other great
resources.
http://go.techtarget.com/r/5747517/4946246/93

Each site provides you with information on a different Windows discipline -
find out more now!
http://go.techtarget.com/r/5747517/4946246/94
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

NEW DISCUSSION on:
What are the most overused tech buzzwords for 2008?

DISCUSSION from Oldbogeydog:
"White Paper"

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5747526/4946246/95

-----------------------------------------------------------------------
NETWORKING UPDATES
-----------------------------------------------------------------------

:::::::::::::::::::::::::: ADVERTISEMENT :::::::::::::::::::::::::::
Sponsored by: TechTarget

Read the most targeted, up-to-the-minute news and exclusive features on
pertinent Windows topics.
http://go.techtarget.com/r/5747517/4946246/96

Our newsletters provide the latest Windows-based tips, tutorials, e-guides and
more straight to your inbox.
http://go.techtarget.com/r/5747517/4946246/97

Attend free events to get expert advice on topics such as desktop
virtualization and email archiving.
http://go.techtarget.com/r/5747517/4946246/98

Access research libraries, RSS feeds, ask the expert pages, and other great
resources.
http://go.techtarget.com/r/5747517/4946246/99

Each site provides you with information on a different Windows discipline -
find out more now!
http://go.techtarget.com/r/5747517/4946246/100
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

NEW QUESTION on:
Routing

QUESTION from Killerj:
Hi..We have two cisco 2600 router, one deployed in our main office and the
other in our remote site.We also have two DSL connections.We have our exchange
server in main office.
Q1.how to configure the two router to use the 2 dsl connections that we have.
Q2.how to route our exchange server to pas...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5747584/4946246/101

-----------------------------------------------------------------------
NEW QUESTION on:
Wireless access gone, XP

QUESTION from XMac:
I have a wireless card in a Dell GX260 running XP. It was working just fine.
Then I replaced the harddrive and installed XP again. I have the CD with the
driver to the card and installed it. Since that time, the computer "sees" the
wireless router but does not connect. (Sees - in the software that ...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5747585/4946246/102

-----------------------------------------------------------------------
NEW ANSWER on:
load balance on WAN interfaces

ANSWER from Jmflanag:
There are a few ways to accomplish this task, and that will depend on what type
of routing you are going to have between both sites. Also, I am assuming that
your hand-off will be copper r-j5 connected to the ethernet ports on your
routers, since you have a 2mb leased line. If you where to have se...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5747586/4946246/103

-----------------------------------------------------------------------
NEW DISCUSSION on:
Spyware/trojan is getting on my last nerve i need help!!

DISCUSSION from Dwiebesick:
Here is a list of sites that you can use to help you clean your computer.
Anti-Virus/Spy/Scumware Programs
a-Squared http://www.emsisoft.com/en/software/ax/
Avira AntiVir Rescue System - Burn CD and boot to scan
http://www.free-av.de/en/tools/12/avira_an...cue_system.html

Bitdefender http://w...

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5747587/4946246/104

-----------------------------------------------------------------------
NEW DISCUSSION on:
Laptop cannot detect home WLAN server

DISCUSSION from Wlannovice:
Thank you very much for your answer Admin89, wireless connection is enabled on
the T42 in question and automatic IP as well.

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5747577/4946246/105

-----------------------------------------------------------------------
NEW DISCUSSION on:
What are the most overused tech buzzwords for 2008?

DISCUSSION from Oldbogeydog:
"White Paper"

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5747526/4946246/106

-----------------------------------------------------------------------
UPDATED ANSWER on:
Exchange Capabilities

ANSWER from Technochic:
Depending on your version of Exchange, you can utilize Outlook Web Access.
We're using Exchange 2003 and for users external of the domain, they log into
email witn OWA. It works fairly well. Everything has it's limitations, but you
don't need a VPN just to get your email.
If I remember right, Excha...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5747564/4946246/107

-----------------------------------------------------------------------
UPDATED ANSWER on:
Port Forwarding with Cisco 3560

ANSWER from Ihsan:
You can do this by applying PBR (Policy Based Routing). See below a very
simple config. You can amend the PBR rules in below ACL

[B]1. Define your PBR rule ACL [/B]

[CODE][CODE]ip access-list extended PBR
permit ip any any eq 80
permit ip any any eq 445[/CODE]

[B]2. Define next hop[/B]...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5747578/4946246/108

-----------------------------------------------------------------------
UPDATED ANSWER on:
De-Duplication Live in production

ANSWER from Billm11:
We've implemented de-dup on primary storage using NetApp technology, works
pretty well, but you have to be selective about the volumes you target. There
seems to be a small overhead in performance, about 3% from what we've tested so
far, but this has not been noticeable to end-users.

The CIFS vol...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5747588/4946246/109

-----------------------------------------------------------------------
NEW ANSWER on:
getting started in security

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5747589/4946246/110

-----------------------------------------------------------------------
UPDATED ANSWER on:
Monitoring Exchange 2007 Administrators

ANSWER from Technochic:
You will need a third-party tool for this. Maybe someone is already using one
successfully who coud recommend it. I have reviewed the one from [A
href="http://www.quest.com/InTrust-Plug-in-for-Exchange/"]Quest software[/A]
but we ou compnay is not allocating any spending for this sort of thing so I
...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5747567/4946246/111

-----------------------------------------------------------------------
UPDATED ANSWER on:
Is it possible to lift router-based bandwidth caps (if they exist)?

ANSWER from Labnuke99:
If your ISP has put a bandwidth limit on your account it would need to be
removed by them. Nothing you are able to do on our side will increase the
speed if they are limiting you.

===============
Check the speed and duplex settings if possible on your network card and on the
router LAN connecti...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5747590/4946246/112

-----------------------------------------------------------------------
UPDATED ANSWER on:
Duplicate IP addresses?

ANSWER from Labnuke99:
Computer should not be sharing an IP Address. Each machine will need its own
IP address so that the computers now how to talk to each other.

If one computer is on, and your router reboots then another computer is turned
on then both machines could be issued the sameIP address. Because of this i...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5747591/4946246/113

-----------------------------------------------------------------------
UPDATED ANSWER on:
8 port fast ethernet switch

ANSWER from Labnuke99:
Yes, you can.

================
If it is a switch, then you won't be able to use it as a hub by definition - a
hub is half-duplex and a switch is full duplex and only transmits either
broadcasts on all ports or unicast directed to the device(s) connected to the
switch port.
-LabNuke99

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5747592/4946246/114

-----------------------------------------------------------------------
UPDATED ANSWER on:
iSCSI SAN how many IP Addresses are needed?

ANSWER from ISCSIdude:
I would say 1 for each LUN you have would make sense.

My recommendation would be a minimum of one IP address for each controller in
the SAN for a total of 4. If you had a fairly redundant network and could take
advantage of MPIO then I would recommend two IP addresses per controller for a
total ...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5747593/4946246/115

-----------------------------------------------------------------------
NEW QUESTION on:
Cisco 2811 Power Supply Jumper - PS Type

QUESTION from Greencj:
I have replaced a DC supply with an AC 100V but the new power supply doesn not
havbe anywhere for the PS Type Jumper connection.

What does the PS Type do and can I operate without that connected (as the new
power supply has no connector) ?

Thanks in Advance.

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5747594/4946246/116

-----------------------------------------------------------------------
ORACLE UPDATES
-----------------------------------------------------------------------

:::::::::::::::::::::::::: ADVERTISEMENT :::::::::::::::::::::::::::
Sponsored by: ITKE

View all Oracle related Questions and Answers
http://go.techtarget.com/r/5747535/4946246/117
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

UPDATED ANSWER on:
Upgrade from Oracle 10g2 to Oracle 10g4 on Linux

ANSWER from Carlosdl:
What exactly do you mean with 10g2 and 10g4 ?
Could you please provide the exact version numbers ?

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5747536/4946246/118

-----------------------------------------------------------------------
NEW ANSWER on:
Subscript beyond count on nested table (trying to update a column in a trigger
for the same table as trigger)

ANSWER from Carlosdl:
That error usually arises when you try to access a non-existent element on a
collection.

To debug this, you could place all the code inside the for loop in an
if-then-else block to make sure you are referencing only existent elements.

Something like this:

[CODE]for i in g_change_tab.first.....

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5747537/4946246/119

-----------------------------------------------------------------------
NEW ANSWER on:
Problem running Oracle Forms 9i

ANSWER from Carlosdl:
Are you getting some error message when trying to install JInitiator ?

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5747538/4946246/120

-----------------------------------------------------------------------
NEW ANSWER on:
How to call trigger stored in database using Oracle Forms

ANSWER from Carlosdl:
You can't call database triggers directly. You should use a stored procedure
instead.

You can call stored procedures the same way you do for Forms local procedures.

Please provide more information if you need further help.

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5747539/4946246/121

-----------------------------------------------------------------------
NEW DISCUSSION on:
Reports go blank with Oracle 10g using JReport (work perfect with Oracle 9i)

DISCUSSION from Carlosdl:
Have you re-compiled your report against the 10g database ?

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5747540/4946246/122

-----------------------------------------------------------------------
NEW ANSWER on:
Best practices for migrating Oracle 6i to Oracle 10g

ANSWER from Carlosdl:
Are you going to migrate your database, or your Developer applications (or
both) ?

There is no version 6i of Oracle database, so I guess you are talking about
Forms.

If you are going to migrate the database also, please specify your current
database version.

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5747541/4946246/123

-----------------------------------------------------------------------
NEW ANSWER on:
Connecting to Oracle with Visual Basic 2005?

ANSWER from Carlosdl:
Your question is not clear enough, at least for me.
You should be able to connect from any version of Visual Basic to an Oracle
database.

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5747542/4946246/124

-----------------------------------------------------------------------
NEW ANSWER on:
Crystal Reports OBDC (Oracle)

ANSWER from Carlosdl:
Are you using the same database user when connecting from Crystal than when
connecting from Access ?
It could be a problem of missing privileges or synonyms.

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5747543/4946246/125

-----------------------------------------------------------------------
NEW DISCUSSION on:
What are the most overused tech buzzwords for 2008?

DISCUSSION from Oldbogeydog:
"White Paper"

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5747526/4946246/126

-----------------------------------------------------------------------
NEW QUESTION on:
Oracle apps

QUESTION from RPGsadhu:
How to handle manufacturing, in oracle apps?

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5747544/4946246/127

-----------------------------------------------------------------------
SAP UPDATES
-----------------------------------------------------------------------

:::::::::::::::::::::::::: ADVERTISEMENT :::::::::::::::::::::::::::
Sponsored by: ITKE

View all SAP related Questions and Answers
http://go.techtarget.com/r/5747619/4946246/128
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

NEW QUESTION on:
SAP Testing

QUESTION from Shreehari:
Hi all,
Can any one please provide me information on:
What is SAP testing?
How the SAP testing will be done?

Regards,
Shreehari.

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5747620/4946246/129

-----------------------------------------------------------------------
UPDATED ANSWER on:
which SAP certification will help my MBA in HRM?

ANSWER from RABK:
As far as I know, SAP HCM is one of the best modules SAP has to offer. The way
it integrates with other modules is amazing. On the other hand, the SAP
controls are considered the most powerful amongst the ERP systems. I believe
HCM has a good future, especially when clubbed with the MBA degree you h...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5747621/4946246/130

-----------------------------------------------------------------------
NEW DISCUSSION on:
What are the most overused tech buzzwords for 2008?

DISCUSSION from Oldbogeydog:
"White Paper"

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5747526/4946246/131

-----------------------------------------------------------------------
NEW QUESTION on:
Could not start layout designer

QUESTION from Irina:
I wonder what is a reson for this message:
"Could not start layout designer (see long text)".
It has happened:
- transaction SFP
- tab LAYOUT.

Thank you

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5747622/4946246/132

-----------------------------------------------------------------------
NEW ANSWER on:
Career advice for moving from development to SAP

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5747606/4946246/133

-----------------------------------------------------------------------
SECURITY UPDATES
-----------------------------------------------------------------------

:::::::::::::::::::::::::: ADVERTISEMENT :::::::::::::::::::::::::::
Sponsored by: ITKE

View all Security related Questions and Answers
http://go.techtarget.com/r/5747595/4946246/134
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

NEW DISCUSSION on:
Spyware/trojan is getting on my last nerve i need help!!

Bitdefender http://w...

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5747587/4946246/135

-----------------------------------------------------------------------
NEW DISCUSSION on:
What are the most overused tech buzzwords for 2008?

DISCUSSION from Oldbogeydog:
"White Paper"

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5747526/4946246/136

-----------------------------------------------------------------------
UPDATED ANSWER on:
Port Forwarding with Cisco 3560

ANSWER from Ihsan:
You can do this by applying PBR (Policy Based Routing). See below a very
simple config. You can amend the PBR rules in below ACL

[B]1. Define your PBR rule ACL [/B]

[CODE][CODE]ip access-list extended PBR
permit ip any any eq 80
permit ip any any eq 445[/CODE]

[B]2. Define next hop[/B]...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5747578/4946246/137

-----------------------------------------------------------------------
UPDATED ANSWER on:
Bare Metal Restore

ANSWER from Swaroop:
you can use ghost to mirror your data drives but the sql won't run on
workstation addition and limits you to 10 connections. you can use in an
emergency, but you could also back up to nas and access the data the same way.
buy a second server and cluster them, then if one fails the other takes over...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5747596/4946246/138

-----------------------------------------------------------------------
NEW QUESTION on:
implementing POP3 in Outlook clients in exchange 2000

QUESTION from ITKE:
Im having a problem implementing POP3 in Outlook clients.

My company has an Exchange Server 2000 and users need to use outlook outside
the office.

We are using POP3 to do that, but when the our users outside the office send
mail using POP3, all the recipients receive it as SPAM.

In all cas...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5747572/4946246/139

-----------------------------------------------------------------------
UPDATED ANSWER on:
Log onto to Windows w/o username or password

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5747581/4946246/140

-----------------------------------------------------------------------
SQL SERVER UPDATES
-----------------------------------------------------------------------

:::::::::::::::::::::::::: ADVERTISEMENT :::::::::::::::::::::::::::
Sponsored by: ITKE

View all SQL Server related Questions and Answers
http://go.techtarget.com/r/5747545/4946246/141
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

NEW QUESTION on:
How to make installer of vb.net including sql server 2000?

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5747546/4946246/142

-----------------------------------------------------------------------
NEW DISCUSSION on:
Creating a summary table in SQL Server

DISCUSSION from Sivu:
B'cause Dynamic SQL kills the performance for large data.

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5747547/4946246/143

-----------------------------------------------------------------------
UPDATED ANSWER on:
Configuring a SQL Server to optimize for best performance

ANSWER from Dschwant:
The only way to truly optimize performance is to monitor (using
perfmon/profiler) and test.

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5747548/4946246/144

-----------------------------------------------------------------------
NEW QUESTION on:
Date Parameters in SSRS - showing total by day as well as by total by parameter
chosen

QUESTION from Ericamorrison:
I have a date range parameter set up in SSRS. I need to show the total for
each day chosen in the data range parameter as well as the grand total of the
entire filtered selection. Is this possible?

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5747549/4946246/145

-----------------------------------------------------------------------
NEW QUESTION on:
SQL Server 2008 compression experiences?

QUESTION from Dschwant:
We are about to migrate a database from SS2005 32-bit to 2008 64-bit. One of
the biggest drivers for this is the compression capability in SS2008. We expect
to shrink our 2TB database down to about 500GB (proven in testing), and get the
comparable IO performance improvements (4x faster reads - also ...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5747550/4946246/146

-----------------------------------------------------------------------
NEW DISCUSSION on:
Upgrading to a 64-bit SQL Server 2005 environment

DISCUSSION from Dschwant:
Like I said "This is so general, though, that you will get a lot of people
questioning it." My take is that, with the price of RAM, put in as much as the
thing can fit. If you are doing a significant amout of re-reads in IO, the
performance impovements you get from having it cached are very impres...

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5747551/4946246/147

-----------------------------------------------------------------------
UPDATED ANSWER on:
Pulling multiple values in the same line in SQL

ANSWER from Dschwant:
Doing this requires the use of a function. Something like this.

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5747552/4946246/148

-----------------------------------------------------------------------
NEW ANSWER on:
Scheduling a Shrink Database in SQL Server 2000

ANSWER from Mrdenny:
Yes, you can simply add another job step to use the DBCC SHRINKFILE statement.

However it is typically recommended that you not shrink the files on a regular
basis. Doing so causes the database engine and disk subsystem to do extra work
that it doesn't need to do. If the log has grown to that s...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5747553/4946246/149

-----------------------------------------------------------------------
NEW ANSWER on:
Data updation issues in a SQL Server table

ANSWER from Mrdenny:
If you have a primary key in your table that is messed up that corresponds to a
value in the other table then yes you can.

You may want to look a Lumigents Log Explorer and simply roll back the
incorrect statement (will only work if your database is in full recovery mode).

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5747554/4946246/150

-----------------------------------------------------------------------
NEW ANSWER on:
Dumping a table in a SQL Server database

ANSWER from Dschwant:
Please provide more details. What exactly do you mean by dump (Select *)? What
do you want the text for? Thanks!

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5747555/4946246/151

-----------------------------------------------------------------------
NEW ANSWER on:
Removing a node from a working SQL Server 2005 cluster

ANSWER from Mrdenny:
With the node removed the system won't have any performance impact it will only
impact the high availability of the system.

I would recommend replacing the node as soon as you can.

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5747556/4946246/152

-----------------------------------------------------------------------
NEW DISCUSSION on:
What are the most overused tech buzzwords for 2008?

DISCUSSION from Oldbogeydog:
"White Paper"

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5747526/4946246/153

-----------------------------------------------------------------------
NEW ANSWER on:
Creating a SQL Server trigger to capture data

ANSWER from Dkrueger:
I have asked a similar question in the past and Mrdenny was able to assist me
with the information below:

That trigger would look something like this.

CREATE TRIGGER t_YourTable_u on dbo.YourTable
FOR UPDATE
AS
UPDATE YourTable
SET UserName = suser_sname(),
...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5747557/4946246/154

-----------------------------------------------------------------------
UPDATED ANSWER on:
Passing an array into a Stored Procedure

ANSWER from Msi77:
No, SQL Server doesn't support array's an input parameters. SQL Server 2008
allows you to use a table variable as an input parameter.

Your best option will be to create an XML Document and pass the XML document to
the stored procedure, then parse the XML document using [A
href="http://itknowledg...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5747558/4946246/155

-----------------------------------------------------------------------
STORAGE UPDATES
-----------------------------------------------------------------------

:::::::::::::::::::::::::: ADVERTISEMENT :::::::::::::::::::::::::::
Sponsored by: ITKE

View all Storage related Questions and Answers
http://go.techtarget.com/r/5747597/4946246/156
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

NEW ANSWER on:
BRMS using newly expired tapes

ANSWER from Pgpatel:
Hi,

Might be tapes are not expired. Manually expire the tapes which you want to
recycle.
If using veritas netbackup then command is bpexpdate.
After manually expiring the tapes you can clean and reuse those tapes.

Thanks,
Prabodh.

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5747519/4946246/157

-----------------------------------------------------------------------
NEW ANSWER on:
iscsi and FC network

ANSWER from ITKE:
With the right network switch they can run on the same network

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5747598/4946246/158

-----------------------------------------------------------------------
NEW DISCUSSION on:
What are the most overused tech buzzwords for 2008?

DISCUSSION from Oldbogeydog:
"White Paper"

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5747526/4946246/159

-----------------------------------------------------------------------
NEW QUESTION on:
File system using FUSE

QUESTION from Swaroop:
I'm working on understanding and building a usable file system using FUSE(FIle
system in user space). I currently have two file systems in mind that I think
are useful.

1. Versioning file system
2. Gmail File system

Any suggestions on what I can work on to make the project more exciting? An
u...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5747599/4946246/160

-----------------------------------------------------------------------
UPDATED ANSWER on:
Bare Metal Restore

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5747596/4946246/161

-----------------------------------------------------------------------
UPDATED ANSWER on:
De-Duplication Live in production

The CIFS vol...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5747588/4946246/162

-----------------------------------------------------------------------
NEW QUESTION on:
EMC CX4 VS Netapp 3140 VS Lefthand SAN/iQ

QUESTION from Jhiraldo:
I would like to know what SAN is best to implement ESX 3.5.
In regards to features, management, and useable space. If anyone here went
through the process of implementing any of these products why did you choose
the one you have. If you're using 2 of the 3 or maybe all, why do you like one
over the...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5747600/4946246/163

-----------------------------------------------------------------------
NEW ANSWER on:
VMware ESX 3.5 not able to create a new datastore

Within the VI Client, do the following:
1) highlight your es...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5747562/4946246/164

-----------------------------------------------------------------------
UPDATED ANSWER on:
Where does the rest of the memory space in diskettes go?

...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5747580/4946246/165

-----------------------------------------------------------------------
NEW QUESTION on:
ESX luns allocated on Symmetrix will not format.

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5747601/4946246/166

-----------------------------------------------------------------------
UPDATED ANSWER on:
Archiving Emails on a CD

ANSWER from Aguacer0:
from the file menu, archive, select folders , subfolders, select older than
date, include items marked do not archive. Create the .pst and burn it to a
CD/DVD. You can also archve from tools|option|other|autoarchive and then run
from there. There is an option here to delete email messages when archi...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5747569/4946246/167

-----------------------------------------------------------------------
NEW DISCUSSION on:
Looking for NAS solution

DISCUSSION from Cannyab:
Look for Netgear's products for NAS. Not sure what your affordable limit is,
but they have different product categories.

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5747602/4946246/168

-----------------------------------------------------------------------
NEW ANSWER on:
Need to get exchange server working with windows server 2003

ANSWER from Aguacer0:
Here are good instructions to use:

http://computerperformance.co.uk/exchange2003/exchange2003_recovery_options.htm

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5747571/4946246/169

-----------------------------------------------------------------------
NEW QUESTION on:
Dell/EqualLogic Transportable Snapshots and Backup Exec 12.x

QUESTION from Jrrbrown:
Has anyone put together a step-by-step on how to get the transportable
snapshots created by Dell/EqualLogic Auto Snapshot manager to be used by
Symantec Backup Exec 12 or 12.5 for backing up their data or if you have any
links to how this can be facilitated. I have read all the Dell/EqualLogic
white...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5747603/4946246/170

-----------------------------------------------------------------------
UPDATED ANSWER on:
iSCSI SAN how many IP Addresses are needed?

ANSWER from ISCSIdude:
I would say 1 for each LUN you have would make sense.

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5747593/4946246/171

-----------------------------------------------------------------------
UPDATED ANSWER on:
How does one guarantee the integrity of snapshot done at block level

ANSWER from ISCSIdude:
Are you asking is there a way to have the Equallogic snapshot function force
the database to flush all pending operations to disk before taking the
snapshot?

If this is what you are asking, then out of the box, the answer is no. I've
never done this before, but Equallogic provides some perl ex...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5747575/4946246/172

-----------------------------------------------------------------------
VIRTUALIZATION UPDATES
-----------------------------------------------------------------------

:::::::::::::::::::::::::: ADVERTISEMENT :::::::::::::::::::::::::::
Sponsored by: TechTarget

Read the most targeted, up-to-the-minute news and exclusive features on
pertinent Windows topics.
http://go.techtarget.com/r/5747517/4946246/173

Our newsletters provide the latest Windows-based tips, tutorials, e-guides and
more straight to your inbox.
http://go.techtarget.com/r/5747517/4946246/174

Attend free events to get expert advice on topics such as desktop
virtualization and email archiving.
http://go.techtarget.com/r/5747517/4946246/175

Access research libraries, RSS feeds, ask the expert pages, and other great
resources.
http://go.techtarget.com/r/5747517/4946246/176

Each site provides you with information on a different Windows discipline -
find out more now!
http://go.techtarget.com/r/5747517/4946246/177
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

NEW QUESTION on:
VNC without or with domain

QUESTION from Toit512:
I want to setup vnc over adsl and some 3g connections over a distance on
several computers.
Is it needed to configure them as domain controllers or can they be connected
just like that?
Can someone please help me with the connection setup etc.

Tnx

Toit

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5747604/4946246/178

-----------------------------------------------------------------------
NEW DISCUSSION on:
What are the most overused tech buzzwords for 2008?

DISCUSSION from Oldbogeydog:
"White Paper"

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5747526/4946246/179

-----------------------------------------------------------------------
UPDATED ANSWER on:
De-Duplication Live in production

The CIFS vol...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5747588/4946246/180

-----------------------------------------------------------------------
NEW QUESTION on:
EMC CX4 VS Netapp 3140 VS Lefthand SAN/iQ

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5747600/4946246/181

-----------------------------------------------------------------------
UPDATED ANSWER on:
Using VMware to migrate files in Windows Server 2003 environments

ANSWER from Aguacer0:
Hello
You have two options here....

Hope that helps!

Thank you,
David Da...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5747579/4946246/182

-----------------------------------------------------------------------
NEW ANSWER on:
VMware ESX 3.5 not able to create a new datastore

Within the VI Client, do the following:
1) highlight your es...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5747562/4946246/183

-----------------------------------------------------------------------
NEW QUESTION on:
ESX luns allocated on Symmetrix will not format.

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5747601/4946246/184

-----------------------------------------------------------------------
VOIP UPDATES
-----------------------------------------------------------------------

:::::::::::::::::::::::::: ADVERTISEMENT :::::::::::::::::::::::::::
Sponsored by: TechTarget

Read the most targeted, up-to-the-minute news and exclusive features on
pertinent Windows topics.
http://go.techtarget.com/r/5747517/4946246/185

Our newsletters provide the latest Windows-based tips, tutorials, e-guides and
more straight to your inbox.
http://go.techtarget.com/r/5747517/4946246/186

Attend free events to get expert advice on topics such as desktop
virtualization and email archiving.
http://go.techtarget.com/r/5747517/4946246/187

Access research libraries, RSS feeds, ask the expert pages, and other great
resources.
http://go.techtarget.com/r/5747517/4946246/188

Each site provides you with information on a different Windows discipline -
find out more now!
http://go.techtarget.com/r/5747517/4946246/189
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

NEW DISCUSSION on:
What are the most overused tech buzzwords for 2008?

DISCUSSION from Oldbogeydog:
"White Paper"

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5747526/4946246/190

-----------------------------------------------------------------------
-----------------------------------------------------------------------

UNSUBSCRIBE
You are receiving this e-mail because you subscribed to tag e-mail alerts
on ITKnowledgeExchange.com.

To unsubscribe from tag e-mail alerts click the link below to
"Edit My Account". Go to the Newsletter Preferences section and un-check
tags you no longer wish to receive e-mail alerts on and click "Save".
http://ITKnowledgeExchange.techtarget.com/settings/account/

To unsubscribe from all tag e-mail alerts, click the link below:
http://ITKnowledgeExchange.techtarget.com/unsubscribe?email=sekhargreen@gmail.com&key=41289&tag=1

-----------------------------------------------------------------------

ABOUT THIS E-NEWSLETTER
This e-newsletter is published by ITKnowledgeExchange.com, a
targeted Web site from TechTarget, The IT Media ROI Experts and
events company.