PaulB-TheOneAndOnly

Forum Replies Created

Viewing 15 posts - 256 through 270 (of 3,060 total)

RE: SQL question

edward_hall76 (7/14/2012)
Right now I have been asking people who the phone carrier is and can just add it to the end of there number. But I was trying to find...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

July 14, 2012 at 5:40 pm

#1512838
RE: SELECT COUNT(*) Oracle Table SSIS w/o Linked Server & assign to variable

Welsh Corgi (7/14/2012)
I need to get a record count from an Oracle Table and store the values in a log table before and after the load (OLE DB).
I need to...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

July 14, 2012 at 5:35 pm

#1512835
RE: Converting Oracle Timestamp with 9 fractions of second

prvmine (7/11/2012)
something like
to_char(QD_RDB_ENTRY_DATE, 'yyyy-mm-dd 'HH24:MI:SS.FF7')
you might have to remove the 24 from the HH portion depending on how the instance of oracle is configured
Sql Server datetime2(7) is the largest fractional...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

July 13, 2012 at 6:59 am

#1512509
RE: Surrogat Key be Created in DW or Stage?

herladygeekedness (7/12/2012)
akirajt (7/7/2012)
Should the surrogate key, for instance customerKey for dimension customer, be created in the stage process and then the all data should be loaded into the dimCustomer or...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

July 13, 2012 at 6:09 am

#1512488
RE: Oracle 11g Client Version 11.2 is missing Drop down to specify Oracle Home Name -- looking for a oraparam.ini

I'm sorry for the delay.
You are correct, runInstaller is for Unix/Linux - as you figured it out setup does it for Windows.
In regards to the sqlplus error be sure environmental...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

July 13, 2012 at 5:47 am

#1512478
RE: Oracle 11g Client Version 11.2 is missing Drop down to specify Oracle Home Name -- looking for a oraparam.ini

Oracle home can be specified at the command line, like:
./runInstaller ORACLE_HOME="OH_location" ORACLE_HOME_NAME="OH_name"
Hope this helps.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

July 10, 2012 at 4:52 pm

#1511286
RE: Contraint creation error

Please do sp_help table_name and post results; we trying to figure out the already existing constraints in such a table.
Either constraint already exists or creation of the constraint is creating...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

July 2, 2012 at 5:25 am

#1507684
RE: SQL Server DBA learning Oracle

Elizabeth Good (5/4/2012)
I would also run logical backups (exports or datapump exp) fairly regularly. These are very helpful for "oops" moments-someone deletes a table accidentally, etc.
Also, setting up a...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

June 30, 2012 at 5:50 pm

#1507511
RE: dynamic query

... select top 3?
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

June 26, 2012 at 5:11 pm

#1505916
RE: How to Join Two tables with row numbers.

sambireddy chirra (6/26/2012)
Hi All,
I have two tables, Employee table have master data and Employee_Details have transactional data.it has added EmpID with row number. how to join two table based on...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

June 26, 2012 at 5:53 am

#1505511
RE: Roles and Responsibilities of Different Teams When Supporting SQL Server

foreverloops (6/26/2012)
Hi,
I work for an organisation where we have approximately 75 IT staff. We have a development team, an application service team and an infrastructure team who jointly support MS...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

June 26, 2012 at 5:31 am

#1505500
RE: Updating oracle table from SQL server

muthyala_51 (6/19/2012)
Can any one give me syntax of Updating an oracle table using Openquery. I will be running this query from SQL Server Management studio.
Is this correct?....
UPDATE OPENQUERY (Ora_link,
'SELECT Flag...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

June 22, 2012 at 9:17 am

#1504566
RE: ssis package so slow-coping table from sql 2 oracle

DBA_AUS (6/20/2012)
all i am trying to do is copy data from a table from SQL Server to Oracle. table has 5000 rows only but ssis package takes ages to complete...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

June 21, 2012 at 10:50 am

#1504081
RE: Transactional Replication to Oracle

Well... if TNSNAMES is changed to point to a different database I would also want to re-initialize; new database, new replication schema.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

June 21, 2012 at 10:47 am

#1504078
RE: Key Assignment in a Time Dimension Table with Duplicate Entries

dj1202 (6/15/2012)
PaulB-TheOneAndOnly (6/15/2012)
dj1202 (6/15/2012)
Hello all, I am creating a table, named DimCalendar, which has the following columns:
DateID (date)
Quarter
Year
Month
Week
Day
InvoiceNumber
There are duplicate dates in the DateID column, but I would like to...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

June 17, 2012 at 5:52 pm

#1502054

Viewing 15 posts - 256 through 270 (of 3,060 total)