• Oracle Data Guard Replication between SAN and NAS

    Is it possible to replicate data (using Oracle Data Guard) between Oracle Database which is on SAN at primary site and on NAS at the DR site?

    KetanVora0 pointsBadges:
  • Converting the nvarchar datatype in SQL Server 2005

    SQL Server 2005 automatically converts all the fields with the nvarchar datatype to nvarchar(MAX), which I can’t use with formula functions in Crystal Reports. Is there a way to stop this conversion to nvarchar(MAX)?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Best practice of maintaining master data

    What are best practices in maintaining master data? Who should own the responsibility of owning this data?

    Fi Analyst5 pointsBadges:
  • difference between external described datastructure and program described datastructure

    can any one help me what is the difference between external described datastructure and program described data structure and what is the use of external data structure and, can i use variables of external data structure in another program

    Mohan K695 pointsBadges:
  • datamining SQL with access

    I have been asked by the sales department to datamine our SQL database and pull the names and e-mails of all our guests for the last few years for a contact list. I am new to SQL but have worked with access in the past. Using access, how do I set things up so that access will see the database...

    Daiishi0 pointsBadges:
  • Assigning access to SQL Server Integration Services (SSIS) packages

    How do we assign access for users to SQL Server Integration Services (SSIS) packages?

    SQL Server Ask the Experts2,585 pointsBadges:
  • web search using specified url list

    Can anyone advise how I can use Google "site" operator for searching within more than one url? Say I have a list of websites in which i'de like to find in all of them specific keyword/s. Example: find in sites oracle.com, microsoft.com the phrase: "CRM specialist". If to expand this requirement...

    Raphif5 pointsBadges:
  • Retrieving specific XML data in SQL Server

    I have a question regarding SQL Server. I have a table with an ntext datatype column where I am storing XML data. My question is: How do I write a user-defined function to retrieve a particular xml attribute in that column?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Are the data warehousing,data-mining and document warehousing under the Database Management System?

    Are the data warehousing,data-mining and document warehousing under the Database Management System?

    Hanzter5 pointsBadges:
  • Stop Error (C000021a)

    I am receiving this stop error(C000021a) "windows logon process system process terminated unexpectedly" with win 2000 server. Safe mode and Last Known Good Conf. works fine. Is there any solution without reformating the HDD? I have ERD with me. Will that help me? Any advise on this would be highly...

    BinooDas123410 pointsBadges:
  • About data management

    Hi i have same date like this; 1 ..... ..... 2 ..... ..... 3 -26 -28 4 36 -53 5 -40 -46 6 ... ..... 7 56 -64 8 -31 -29 ı want to change this date like this 1 ..... -28 2 -26 -53 3 36 -46 4 -40 ... 5 ... -64 6 56 -29 7 -31 ... 8 ... ... one column go up a line other column go up two line but...

    Bronzemoon5 pointsBadges:
  • Data Sources for SSAS 2000

    I have a short term issue where I will need a SSAS2000 cube to be using data from a SQLServer2005 database. Can I do this directly? If not, can I Export MSSS2005 data directly to the MSSS2000 database? (Sorry for such a simple question- I am a newbie).

    Petro5 pointsBadges:
  • Working with totals

    I am trying to run cross-tabs (year x gender) on a data set made up of total scores (rather than frequencies) in each cell, but the output only gives me counts. Is there a command to let SPSS know that the cell figure is a total?

    Spcase5 pointsBadges:
  • Help needed for date dimension which is not rolled up properly.

    I'm new to SSAS and I have dim_date table. Which have DateKey which is int and primary key (Eg data 19010101, 19010102 etc.,), date which is datetime(eg: 1901-01-02 00:00:00Z), year - smallint(Eg: 1901), month -tinyint(Eg: 01), monthname -varchar(January), day -tinyint (Eg: 1), dayname - Varchar...

    Sree11195 pointsBadges:
  • how to update a remote sql server2005 database on webserver with multiple similar local database on windows server 2003

    Hello, I am developing an application which has several local windows server 2003. All the servers are having sql server 2005 database exactly similar structure but different datas. I want to keep a remote webserver server having a similar database updated online from all these local servers over...

    Sahaj5 pointsBadges:
  • How do I integrate SQL Server Integration Services and Blaze Advisor?

    I am a Microsoft Business Intelligence (BI) Developer and currently working on a Pharmaceutical BI project. The client wants to integrate his Blaze Advisor rule engine to SQL Server Integration Services (SSIS) so that he can change the rules in Blaze Advisor any time and see the effect of it on the...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Retrieve data (ETL) from 32 bit architecture to a data warehouse running 64 bit

    The proposed data warehouse platform will be a 64 bit platform - both OS and SQL2K5. Will there be any issues with drivers or anything else you can think of as I'll be pulling data (ETL processes will reside on the 64 bit platform) from multiple databases on 32 bit OS and SQL2K5 platforms?

    Jmc5 pointsBadges:
  • Select last 3 transactions

    Hello Can someone help me to put together an SQL statement to select the last 3 transactions from a transaction file. In TransactSQL I would do something like this: select top 3 CustID, TransDate, Amount from Trans where CustID= '12345' order by TransDate desc. I believe there must be a more...

    SuhelAC0 pointsBadges:
  • Community Update: New Site updates and Contest Announcement. Win a Nintendo Wii!!!

    Hello Community If you haven't noticed we have added a few new features to the site. First we added more questions to the home page to allow you to browse the latest 200 Questions, Answers and a new tab of Unanswered questions. Also on each main topic page we have added a recent answers and...

    ITKE353,415 pointsBadges:
  • access2k unicode text column even # of bytes error

    a certain row(s?) in an access2k table is corrupted. it causes the application to fail quite often requiring a messy procedure of bringing it up to date each time and it's been like this for years so no older backup exists. archive and fix fails for the same reason (unicode text column width must...

    Santa35 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following