Search Results

Search found 30858 results on 1235 pages for 'database tuning'.

facebook twitter digg google delicious technorati stumbleupon myspace wordpress linkedin gmail igoogle windows live tumblr viadeo yahoo buzz yahoo mail yahoo bookmarks favorites email print

Page 502/1235 | < Previous Page | 498 499 500 501 502 503 504 505 506 507 508 509  | Next Page >

  • SSIS is Case-Sensitive

    - by andyleonard
    Introduction SSIS is case-sensitive even if the database is case-insensitive. Imagine... ... you work in an ETL shop where someone who believes in natural keys won the Battle of the Joins. Imagine one of your natural keys is a string. (I know it's a stretch... play along!). Let's build some tables to sketch it out. If you do not have a TestDB database, why not? Build one! You'll use it often. Use TestDB go Create Table SSIS1 ( StrID char ( 5 ) , Name varchar ( 15 ) , Value int ) Insert Into SSIS1...(read more)

    Read the article

  • Mview??????????????~BI/DWH????????(3)

    - by Yusuke.Yamamoto
    Oracle Database ???BI???????????????????????????????????????????????????????????????????????????????????? ?????????????·???(Mview)???????????!????????????? ??????????(08:12)????????????? BI???????????? Enterprise Manager ??SQL??????????????????????? Enterprise Manager ??SQL????·??????????? ????????????????????·???????????? ?????·??????????? BI????????????(Oracle Database ??????·?????????????Mview???) Enterprise Manager ?????????????????? ??????????????Oracle GRID Center ??????????????? ????????????????????????? ????????DWH????????????????·???????? ???? ????????·???(Mview/????????)|??????????? Oracle Enterprise Manager|??????????? DWH(?????????)??·??

    Read the article

  • Using Friendly Names for SQL Servers via DNS

    Wouldn't it be great if your HR folks only had to put in HR-SQL.mydomain.com for the database connection in their reports? They wouldn't have to remember it was on server Nile and they certainly wouldn't have to change their reports if you migrated their database from the Nile server to the server named Danube. In DNS there are two easy ways to do this. New! SQL Monitor 3.0 Red Gate's multi-server performance monitoring and alerting tool gets results from Day One.Simple to install and easy to use – download a free trial today.

    Read the article

  • Too Much Swapping, even though RAM is 2/3 Empty

    - by indyaah
    I have a VPS with 9GB RAM, 300GB HDD, 3 GB Swap, 7 Cores. The OS is CentOS 5.7 Final. I have postgres9.0 running on my machine, with proper tuning done (at least by book/wiki of PostgreSQL). What happens is most of the times when some complex query run (by complex I mean select with maximum 3 Joins), eventhough 66% of my RAM is unused there is ~99% swapping is happening. Plus it screws up my disk IO which is most of the time reaching ~100% and slows down everything else. (I tend to believe something's wrong with my disk.) I dont understand the reason of this much of swapping happening. Is it because of context switching?? Most of the time my processors are idle, while the IO wait goes upto 30% during pick times. Would appreciate if some can shed some light on it. Thanks.

    Read the article

  • Content Management Systems - Why Should I Build My Website With One?

    Why would you want your website built using a Content Management System (CMS)? Well, there are quite a few compelling reasons. A CMS is driven by a database that stores all the content of the website and only delivers pages when called for by the users' browser. The CMS has a "back end" where content is added to the database, and all you need to do it is your browser. This changes everything! It means for the first time a site owner can make changes to their website when they want to and how they want to - read on for more information...

    Read the article

  • simple app for salary calculation [on hold]

    - by user17981
    I am very new to webdevelopment. I've been given this task to built an application to calculate final salary in the end of the month. The employees are callers and after every call they will get some form on which they will give their call summery like time duration. They are payed for each call depending on time duration. In the back end there will be sql database and some code to calculate the the final salary. Current they have to calculate the salary manually, they are just using google docs form.I have some idea that i need php in the front end sql in the back end but i am not clear about the whole picture please can someone give me a clear skeleton. My main question is what to use to calculate the salary from the database??And what should i use to create a front end form ??

    Read the article

  • What differences should I know? I just upgraded to 13.10 from 10.10 [on hold]

    - by test
    I ran Ubuntu 10.10 for a long time because I liked the menu style. The change in GUI with the upgrades drove me nuts but I finally gave in and downloaded Saucy Salamander 13.10 x64. It's a fresh install running as a virtual machine guest in VMWare Workstation 9 on a Windows 7 x64 host. Well it looks like all those icons are still there on the side which I would be OK with if there were some way to bring back my menus. I have no organized way of accessing things now, or do I? That is the purpose for this question, maybe there is some functionality I just can't find but is there. Also all my fine tuning was gone. I used to be able to change DPI but that's gone. I went ahead and installed Unity Tweak Tool via sudo apt-get install unity-tweak-tool but I couldn't find an icon for it after I installed it.. because again no menu. So I did a search for it and found it there. I've changed the font and which side the window buttons appear on which is good enough for now. Anyway... any suggestions you may have for me I'm game. I'm a Windows 7 user primarily but I use Ubuntu every once in a while. I really liked the old style where everything was categorized like for Applications there was Accessories, Games, Graphics, Internet, Office, Sound & Video, Wine.

    Read the article

  • 'outlier': I/O ???

    - by katsumii
    ??? outlier ???????????????????????????????? - Wikipedia???(????)????????????????????????????????????????????????????????????????outlier site:docs.oracle.com - Google SearchOutlier Update Percent (MRP and Supply Chain Planning Help) Oracle Demantra Implementation Guide OraSVMClassificationSettings (Oracle Data Mining Java API ... Defining a Forecast Set (MRP and Supply Chain Planning Help)????????????????????? I/O ???????????? ????????? 'Exadata' ? 'outlier' ???????????????????????????????Guy Harrison - Yet Another Database Blog - Exadata Smart Flash Logging–Outliersflash log feature was effective in eliminating or at least reducing very extreme outlying redo log sync times.????????? Solaris 11.1 ?? I/O ??????????????????????Oracle Announces Availability of Oracle Solaris 11.1 and Oracle Solaris Cluster 4.1Oracle Solaris 11.1 exposes OracleSolaris DTraceI/O interfaces that allow an Oracle Database administrator to identify I/O outliers and subsequently isolate network or storage bottlenecks.

    Read the article

  • Host-only network ?VM??????????

    - by katsumii
    VirtualBox ?????·?????????·???? (Oracle VM VirtualBox??)????VM?????????9??????????????????????????????????????????????????????????????????Oracle Data Guard Basic Hands On Training???????!Oracle Data Guard ??????????????Oracle Enterprise Manager ??? Oracle Database???????????????JRockit Flight Recorder?????RAC ??????????????! Oracle RAC 11g R2 ?????????Oracle Database 11g Release 2??????????????????Oracle GoldenGate???????Oracle Complex Event Processing11g SmartGrid???????? ?????Oracle Complex Event Processing11g CEP?BAM??? EDA????????? ????? ?????VM??????Host-only network?????????????????????????????????????????????????????Bridged???????????IP?????????????????????????????Linux??sshd??????????????????????????????????Windows??????????????????????????????? port forwarding ???????Poderosa ?????????? portforwading ????????????????????? ??????PC?? ssh -p 23 oracle@(VBox???) ??????????   

    Read the article

  • ?????? ??????????! ?Gold???? vol.5 <??>

    - by M.Morozumi
    ???ORACLE MASTER Gold Oracle Database 11g?????????????? ?????????????????????? ------------------------------- FLASHBACK ( ) ??????????Point-in-Time ???????????? DROP TABLE ?????????????????( ) ????????????????1????????? a. DATABASE b. TABLE c. COLUMN d. ????????????? ??????????????? ------------------------------- ??:b. TABLE ??: FLASHBACK TABLE ???????????Point-in-Time ???????????? DROP TABLE ?????????????????FLASHBACK COLUMN ??????????????

    Read the article

  • ?????!?Oracle ACE??

    - by OTN-J Master
    OTN???????????????????????????3???????Oracle ACE???????????????????! ??????Oracle ACE??????????????????????????????????(?????????????????????????) ?? ??? (Oracle Database??????)”Oracle ?????????” ????? (Oracle Database??????)”???????????~???????????????”  ????? (Oracle Fusion Middleware??????) ”??????????~???????????”??????????????????????????Oracle ACE ?????????????????????????IT???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????? Oracle ACE?????????????????(?????????????????????????)???????????·?????????Oracle ACE????????!? ???Oracle ACE????????Oracle ACE?????????????????????OTN Japan???????????????????????????????????????????????????????????????????????

    Read the article

  • ?????? ??????????! ?Bronze???? vol.11 <??>

    - by M.Morozumi
    ------------------------------- ????: REPLACE ?????????JACK and JUE?????????J???BL??????????????BLACK and BLUE??????????????????? REPLACE ?????????????????1????????? ???: REPLACE('JACK and JUE', 'BL', 'J') REPLACE('JACK and JUE', 'J', 'BL') ????????????? ??????????????? ------------------------------- ?? 2. REPLACE('JACK and JUE', 'J', 'BL') ?? REPLACE ??? 2 ??????????????????? 3 ????????????????? ??????? Oracle Database 11g: ?? ????·???? Oracle Database 11g: ????????? I

    Read the article

  • ?????????98!OTN???????????????

    - by atsuko.nishihata
    ???????????????????????????? ??????????????????????????? ????????? ??????????????????????????????·??? ?????????????????? ???? OTN???? ?????? ?????? ?????????????????????????????? ?????????????????????????OTN???? ?????? ?????? ????????????????????????????? ?????3??5???500???????????? ???????????????????????? ???98(????)???Oracle Database?????????!~?????????????Oracle Database?????!~ ???????????????????? ??98??????????????????????98???????????????????????????? ????????????????! ??????????? ????????????????????????(!!)???????????

    Read the article

  • ?????? ??????????! ?Bronze???? vol.4 <??>

    - by M.Morozumi
    ???ORACLE MASTER Bronze Oracle Database 11g?????????????? ?????????????????????? ------------------------------- ????: Oracle Database 11g ???READ ONLY ?????????????????????????? ???????????????????????????1????????? a.?????????? DML ???????? b.?????????? SELECT ... FOR UPDATE ???????? c.??????? DROP ??????????? d.????????????????????ALTER TABLE ... READ WRITE ????????? ??????????????? ------------------------------- ??:c.??????? DROP ??????????? ??: ??????????? DROP ???????????????????????

    Read the article

  • ?????? ??????????! ?Gold???? vol.4

    - by M.Morozumi
    ??????????????????????????????????????????????????????????????????? ???ORACLE MASTER Gold Oracle Database 11g??????????????????????? ------------------------------- ????: ???????????????????????????????????1????????? a. BACKUP DATABASE ???????????? b. LIKE ?????????? BACKUP ARCHIVELOG ???????????? c. ALL ?????????? BACKUP ARCHIVELOG ???????????? d. ?????????????????? 2 ?????? ???????????????

    Read the article

  • ?????? ??????????! ?Gold???? vol.4 <??>

    - by M.Morozumi
    ???ORACLE MASTER Gold Oracle Database 11g?????????????? ?????????????????????? ------------------------------- ???????????????????????????????????1????????? a. BACKUP DATABASE ???????????? b. LIKE ?????????? BACKUP ARCHIVELOG ???????????? c. ALL ?????????? BACKUP ARCHIVELOG ???????????? d. ?????????????????? 2 ?????? ??????????????? ------------------------------- ??:d. ?????????????????? 2 ?????? ??: ?????????????????? 1???????????????????????????

    Read the article

  • ??????????? Oracle OpenWorld Tokyo 2012 ?????? ~?????????????~ ????????!

    - by M.Morozumi
    Oracle OpenWorld Tokyo 2012?JavaOne Tokyo 2012 ???????????????????????????Oracle Open World ?????????????????2????????? Exadata ???????·DBA·????????? Exadata?????????(???)???Oracle Exadata Database Machine ??? Exadata Storage Server X2-2 ??????????Exadata ???????????????????????????????????Database Machine?????????????????????????????????????????????????????????? ?????????(???) 2012?4?2?~4?3? Oracle BI Suite EE 10g??????! 11g????????????????????!! Oracle BIEE 10g???? 11g Report/Dashboard ?????Oracle BI Suite EE 10g?????????11g???(????)????????????????????????? Oracle BIEE 10g???? 11g Report/Dashboard ?? 2012?4?3?~4?4?

    Read the article

facebook twitter digg google delicious technorati stumbleupon myspace wordpress linkedin gmail igoogle windows live tumblr viadeo yahoo buzz yahoo mail yahoo bookmarks favorites email print

< Previous Page | 498 499 500 501 502 503 504 505 506 507 508 509  | Next Page >