Advance Search All Posts


Filter Posts, Type in Below in text Box



Category Post Name Description
CMD, Batch CMD : code to copy the files from 1 folder to anotherCopy files to another folder, Pass file name in file, command Prompt, xcopy, copy source to destination
CMD, BAtch CMD : Copy the Folder Structure onlyCopy Folder Structure, XCOPY command, batch, command prompt
SQL Server SQL Server Database in Single User ModelSQL Server Database in Single User Model
Pentaho Kettle There was a data type error: the data type of java.lang.Long object [5061] does not correspond to value meta [BigNumber(15)]Data type error in kettle
Windows Local Task Bar appear when Remote Machine done in FULL ScreenTaskbar overlapping, remote machine, mstsc
Oracle Apps The Certificate is not valid and cannot be used to verifyJava Home
Oracle Oracle Database IMPDP ErrorOracle Import, ORA-31693 ORA-29913 ORA-01403 ORA-04088
Salesforce error while inserting record in salesforce Error while Insert data in salesforce object, Data loader, workbench, formula field
SQL Server Function Identify Special Character and Replace SQL Server function, search special charater and replace
SQL Server SSMS SQL Server Management Studio, close automatically when execute QuerySSMS SQL Server Management Studio, close automatically when execute Query
SQL Server Search String in SQLServer in All databases all tables all columnsSearch String in SQLServer in All databases all tables all columns
SQL Server SQL Server Installation ErrorError while enabling Windows feature : NetFx3, Error Code : -2146498220, Dot net framework
Oracle Oracle | Find Week Start Date and Week End date Find start date and end date of week, week start date, week end date
Pentaho Salesforce Connection Issue with pentaho Kettle Successful connection with Salesforce
Pentaho Issue with Starting Launch Spoon.bat Kettle Java virtual machine, java compatiblity issue
SQL Server Pentaho Kettle Error: Could not create the Java Virtual Machine. Xmx1024m to Xmx512m Error: A fatal exception has occurred. Program will exit.
Pentaho Writing in Excel Using Excel Writer Step Writing in excel in multiple tabs, at same time. Input Output error can stop the writing into excel, this will help you
SQL Server Procedure | Compare Field Count and Distinct Count From a Database procedure, TSQL, while loop, cursor, dynamic value pass, Output of select into Variable
Python py0023 ValueError: not enough values to unpack how to pass variable in python script while executing from cmd
SQL Server SQL 17 Delete Duplicate from a table having single column query Logic, SQL Excercise, Requirement solution, Practice, Query Logic, Interview Question
SQL Server SQL 16 Populate total number of employee working in Department query Logic, SQL Excercise, Requirement solution, Practice, Query Logic, Interview Question
SQL Server SQL15 Commulative SUM of Sales query Logic, SQL Excercise, Requirement solution, Practice, Query Logic, Interview Question
SQL Server SQL14 Commulative SUM of Sales Year wisequery Logic, SQL Excercise, Requirement solution, Practice, Query Logic, Interview Question
SQL Server Install SSMA/No SQL Server instance was found on this machine SSMA, Configure, sql server migration assistance , oracle to SQlserver
SQL Server SQL13 How to Fill/populate data until next value Scenerio is Data is populate in table but in between some null occurance are available. Need to populate the in null starting from copy from 1 populate data and copy until next occurance of data and so on. query Logic, SQL Excercise, Requirement solution, Practice, Query Logic, Interview Question
SQL Server SQL12 Generate duplicate records as per the count of sequence Want to generate dupkciate ID in sequence, For 1 , generate 1 record For 2 , generate 2 records For 3 , generate 3 records For 4 , generate 4 records and so on these records will be generated all in sequence. query Logic, SQL Excercise, Requirement solution, Practice, Query Logic, Interview Question
HTML/PHP Create Single Line Border Table HTML/CSS Create Single Line Border Table HTML/CSS, border property tags
SQL Server SQL11 Generate Duplicate Data to Some specific count query Logic, SQL Excercise, Requirement solution, Practice, Query Logic, Interview Question
SQL Server SQL10 SQL Excercise, Requirement solution, Practice, Query Logic query Logic, SQL Excercise, Requirement solution, Practice, Query Logic, Interview Question
Python py0022 : 'python' is not recognized as an internal or external command, 'python' is not recognized as an internal or external command,operable program or batch file.
Python py0021 : Make Python connection with SQLServer database Below is the code which can be used for to make connection with SQLServer database. Make sure python have already imported with pyodbc driver. If you have missing driver, use below command to install driver.
Python py0020 : Python PIP install Error You are using pip version 18.1, however version 20.3.3 is available. You should consider upgrading via the 'python -m pip install --upgrade pip' command.
Kyocera kyocera taskalfa 1800 "Add Toner" ErrorKyocera, MFP, Add toner
PHP How to Launch First Page using XAMPP on local machineXampp first Page launch on local machine
Java Script,PHP Create Search TextBox on WebpageSearch box, search from table, Embed with website
Macro Macro to Change the Font/Color/Size/Alignment of Text Box content PowerPointMacro Code, Powerpoint, excel, change Font properties
Excel Macro Code to Copy Content from Excel File to PowerPoint, Each Row to Each SlideExcel, Macro Error, Copy content from Excel to Powerpoint, excel rows data to powerpoint
VB VB : run time error 429: ActiveX component can't create objectVisual Basic, Macro, run time error 429:
VB VB : Compile Error: User Defined Datatype not definedVisual Basic, macro error
Oracle ORA-12899: value too large for column ColumnNameIMPDP, oracle restore, remap_table, error, value too large for column
Oracle ORA-39151: Table "DatabaseName"."TableName" exists.Oracle restore, IMPDP, remap_Table, remap table
Oracle Restore Table From Full BackupIMPDP, oracle restore, restore 1 table, restore single table
Talend Talend Start Up Error : An error occurred while automatically activating bundle org.talend.designer.core (1557).Talend Error, JDK issue
SQL Server Semicolon, comma separated data to RowsString to rows, comma separated string to rows, query Logic, SQL Excercise, Requirement solution, Practice, Query Logic
SQL Server Concatenate Rows in SQL ServerConcatenate rows in sql Server, SQLSERVer, comma separated, semicolon seprated, prepare IN Clause, SQL Excercise, Requirement solution, Practice, Query Logic
SQL Server Window functions in SQL ServerWindow function, over Partition by, sum, avg, min, max, row_number, query Logic
Oracle ORA-01940: cannot drop a user that is currently connectedOracle Kill users
Oracle Kill Connection of Connect Users OracleKill connected Users
Oracle Kill EXPDP Job -OracleOracle import export impdp, expdp error, kill job
Oracle ORA-02304: Invalid Object Identifier LiteralOracle Database Restore Error, IMPDP
Oracle Error While Restore Oracle Database - ORA-28365: wallet is not openDatabase restore error , wallet is not Open
Excel Minus 2 dates and calculate the difference in years/Months/Days separatelyMinus 2 dates and calculate the difference in years/Months/Days separately
Excel Minus/Subtract 2 dates in Excel, Result is not showing in Number of DaysMinus/Subtract 2 dates in Excel, Result is not showing in Number of Days
SQLServer SQL Server : Find Out the List of Backups taken of DatabaseSQLServer List of backup done for a database, Audit
SQLServer Interview Question 2 - Count of all Occurrence of status/color until it changes to anotherLogical Question Solution in SQLServer,SQL Excercise, Requirement solution, Practice, Query Logic
SQLServer Interview Question 1 - Print only those ParentID which are having 1 Female Child and 1 Male Chile bothLogical Question Solution in SQLServer,SQL Excercise, Requirement solution, Practice, Query Logic
Oracle ORA-28040: No matching authentication protocolConnection Issue Oracle Update SQLNet.ora file
Oracle TNS-12560: TNS:protocol adapter error/ TNS-00530: Protocol adapter errorOracle TNS Error
Computer Change Machine Password While Working on Remote MachineChange Password, Remote Machine, Remote VM, MSTSC
Oracle ERROR While EXPDP (Oracle Restore) : ORA-39143: dump file "c:\**********\.dmp" may be an original export dump fileORA-39001 : invalid argument value, ORA-39000 : bad dump file specification, ORA-39143: Import Export Error, IMPDP, EXPdp, IMP, EXP
General Generate Multiple copy of Document/FilesDuplicate Documents Generate, Copy of Documents, Batch, cmd, random files
SQLServer Basic SQL interview Questions - Part 1Basic Interview questions, SQL Excercise, Requirement solution, Practice, Query Logic
SQLServer SQLServer Function Replace Special CharReplace Special Character, Function,SQL Excercise, Requirement solution, Practice, Query Logic
Oracle SYS.DBMS_DATAPUMP' must be declaredOracle Restore Error, Oracle_SID, Oracle SID
SQL Server Database Database Name is already open and can only have one user at a timeDatabase Single User mode, Multi user Mode,SQL Server Database Restore Error
Postgres pg_dump Postgres Backup Restore ErrorPostgres Restore Error, Version Issue
SQL Server/Oracle How to Find Duplicate Records in Table | Interview QuestionStudy SQlServer, Duplicate Records Concept , Row_number usage
SQL Server/Oracle The transaction log for database 'Database Name' is full due to 'LOG_BACKUPSQL Server, transaction log full, Not able to Insert any data in SQLServer, SQL Query not working, Shrink Log
SQL Server/Oracle A Very Unique Case : Delete Duplicate from Cross Referenced Table [Parent Child relationship]Interview Question, Cross Refernce Parent Child Relation Ship, relationship Duplicate delete, Query LOGIC, SQL Excercise, Requirement solution, Practice, Query Logic
SQL Server/Oracle Multi Association (many to Many)Interview Question, Multi Association, Many to Many Structure Database Design,SQL Excercise, Requirement solution, Practice, Query Logic
SQL Server Index Rebuild and ReorganizeIndex Rebuild SQLServer, Cursor, Ifelse, Dynamic Query, Execute Immediate,SQL Excercise, Requirement solution, Practice, Query Logic
SQL Server Drop table If Already Exists SQLServerDrop Table, SQL Drop Table, If Already Exists, SQL Excercise, Requirement solution, Practice, Query Logic
Oracle ORA-32773: operation not supported for smallfile tablespace ORA-01653: unable to extendORA-32773 operation not supported, smallfile, tablespace ORA-01653 extend, oracle, loop, plsql, plsql insert
Linux Rebuild Linux RPMRebuild Linux RPM
Oracle Rebuild All Indexes using 1 SQL | Single queryOracle, Oracle Indexes, Rebuild Indexes , Index
MongoDB Mongo DB : Installation Error : The domain, user name and/or password are incorrect. Remember to use "." for the domain if the account is on the local machine.Installation Error, MongoDB, Domain Name, Username, password
SQL Server SQL Server - Set Default Time stamp in dateChange time in Date, Date field, Datetime field, date time
SQL Server How to execute SQL query on CMD using text file and log result in text fileExecute query from sql file using sqlcmd, sqlcmd execute script and output in log, , sqlcmd, sql cmd
SQL Server Sqlcmd: Error: Microsoft SQL Server Native Client 11.0 : Login timeout expired.Connection, Connect error SQL CMD, sqlcmd, sqlcmd with SQL Server, connection error
SQL Server Msg 102, Level 15, State 1, Server *********, Line 1Connection, Connect error SQL CMD, sqlcmd, sqlcmd with SQL Server, Execute query on sqlcmd
SQL Server How to execute query on CMDExecute multiple query on sqlcmd, semicolon not working
SQL Server SQL Server - Set Default Time stamp in dateset default time, add time in date, default timestamp, time stamp
Pentaho Invalid byte 1 of 1-byte UTF-8 sequenceKettle table input step special character replacement from SQL Query
Python py0019 : Color code in idle Python ShellColor code of coding in python, color meaning, command in python
Oracle Function to Find Valid Invalid Date Format Oracle valid invalid date of date type format, find valid invalid date
SQL Server Row Count of Each Tablerow count of each table sql server
SQL Server print row count in begin try on deletedelete result show in result window, print delete command result, print delete result, begin try catch, begin end
oracle Count of Each Table Oraclecursor in oracle , for loop in oracle, execute immediate, dynamic sql execution
oracle Simple Cursor and For Loop in Oraclecurso in oracle, for loop in oracle, cursor for loop
Python py0018 : Change color of button on hover and borderless buttonchange color on hover, create border less button
Python py0017 : Parameter 'bg' value is not used less... (ctrl+F1)set default color of button, usage of paramter bg
Oracle Traceonly option is currently not supportedtrace only in SQL Developer
SQL Server Deleted Offline Database? No Issueoffline database
SQL Server Delete Offline Database and Space RecoveryRecovery
SQL Server SQL Server Audit Table Total Count Total Nulls Len of Datarow count, total count in table, each field count, and each field maximum data length
SQL Server Foreign Key Reference Tablesparent and child references
SQL Server SQL Server Database Restore Auditidentify who restore the database, when restore the database and which backup file used
SQL Server How to Find Latest Database restored on Database and which backup file usedidentify who restore the database, when restore the database and which backup file used
Python py0016 : ModuleNotFoundError: No module named 'Tkinter'no module name
Python py0015: NameError: name 'Select' is not definedselect not defined
Python py0014: table_name1 = table_name.replace(',','') AttributeError: 'pyodbc.Row' object has no attribute 'replace'below is my sample code, where i am getting error table_name1 = table_name.replace(',','') AttributeError: 'pyodbc.Row' object has no attribute 'replace' and in same example you can cover how to use replace in python
Python py0013 : use function from another file in main file pythonuse function from another file
Python py0012 : try catch in Python / DB connection in try catchtry catch in python
Python py0011 : Learnt Something impressive in PythonLearnt Something impressive in Python
Python py0010 : Firefox not opening Websites which are in Tunnel/Proxyfirefox not working with python, proxy issue
Python py0009 : How to Declare Variable and Use variable in same file of Other filepython declare variables
Python py0008 : connection with sqlserver databaseconnection sqlserver
Python py0007 : Click on div ul li span class "Display Name" Selenium Pythonelement having flow like div/ul/li/span/class
Python py0006 : selenium.common.exceptions.WebDriverException: Message: Failed to find firefox binary. You can set it by specifying the path to 'firefox_binary':exception in python
Python py0005 : selenium.common.exceptions.SessionNotCreatedException: Message: Unable to find a matching set of capabilitiespthyon
Python py0004 : Begginner error, Open Firefoxpython not able to open firefox
Python py0003 : pip install selenium SyntaxError: invalid syntax, while install seleniumpip install command
Python py0002 : No Python interpreter is selectedinterpreter
Python py0001 : could not find main class com/intellij/idea/maincould not find main class
Oracle dba_data_files data file not appears but dbf file in exists on FileSystemdbf file not exists in filesystem oracle
Oracle Error ORA-01144: File size (5242880 blocks) exceeds maximum of 4194303 blocksoracle tablespace issue
SQL Server Convert Semicolon Separated String in Rows Along With Respective Datasemicolon Separated data
SQL Server SQL Server | DB Restore ErrorRestore error, Active Connection , Database already in use, kill active connections, kill connection
Excel MACRO to List Out All Tab Names Along With Field Header NameMacros
QlikView QV30 Qlikview Interview QuestionsInterview question
SpagoBI failed to load the jni shared libraryjni library
SpagoBI java was started but returned exit code 13exit code 13
Excel Add Random Data in SpreadsheetGenerate random data
Talend Talend Startup Errortalend error, Setup JDK, JDK missing
Xampp Xampp Starting ErrorXampp
Cassandra Java HotSpot(TM) Client VM warning: Cannot open file /cassandra37/logs/gc.log due to No such file or directorycassandra
Cassandra No single argument constructor found for class [Ljava.lang.String;; in 'reader', line 10, column 1:cassandra
Cassandra WARNING! Powershell script execution unavailable.cassandra
Hadoop How to load data in hadoop?load data in hadoop
Hadoop How to clear cache of run (saved password of shared folder)clear cache
Hadoop SecondaryNameNode Inconsistent checkpoint fieldsinconsistent checkpoint in hadoop
Hadoop Hadoop datanode/namenode errorname node error in hadoop
Hadoop Unable to instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClientmetastore
Hadoop RuntimeException org.apache.hadoop.security.AccessControlExceptionRuntime exception
Hadoop The system cannot find the batch label specified - nodemanagerbatch label
Pentaho Want to save kettle Logging in database?logging database
Solutions database url and driverurl and driver
Oracle Playing With SQL QuriesSQL Queries fun
Pentaho Create Folder/Subfolder in transformation java scriptFolder in java
Pentaho Get the list of all tables using JDBC driver using kettleget list of all tables
Pentaho Define Variable for Database Connection in kettledatabase connection, connection variables, dynamic connection in kettle etl tool
Oracle ORA-00119: invalid specification for system parameter LOCAL_LISTENERoracle
Oracle ORA-39095: Dump file space has been exhausted: Unable to allocate 8192 bytesoracle
Oracle want to divide table into 10 equal partstable division
Excel How to auto delete macro code after executiondelete macro code
Excel Auto Open [Run] macro code - when workbook openAuto open excel
SQL Server Add/upload documents in image or varbinary datatypeadd images in field
Pentaho How to pull out blob content out to a directory using kettleblob content extract
Pentaho Call job through kitchen, stop displaying error on batch [kettle]kettle
SQL Server Function to process each character of String [SQL server]process each charater of string
Pentaho Replace Special Char from string for "table input step" kettle transformationreplace speacial char
Pentaho Split string on the first occurrence of underscore using kettlesplit data
SQL Server SQLServer - Integer Formatinteger formatiing
SQL Server SQLSERVER - licensed limit of 10240 MB per Databaelimit restore database
Pentaho Kettle log contains string - ERROR (version 5.4.0.1-130, build 1 from ** by buildguy)kettle log
Pentaho Table Input/Evaluate rows number in a table/Execute SQL step, On error abort all job sequenceTable Input
Pentaho kettle - Filter step not working initialize both input stepsFilter step not working
Pentaho Caused by: java.sql.SQLRecoverableException: No more data to read from socket at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1200)Data from socket
Oracle ORA-01704: string literal too longstring literal is long
Oracle Fill null values with previous values, until next come in the row
Oracle Change orientation of table, (Rotate table) rows to columnrotate table
Oracle LISTAGG function giving extra spaces in resultlistagg function
Windows Share files with Virtual machineshare file
Oracle ORA-00054: resource busy and acquire...resource busy
Oracle Some Oracle Basic Queriesoracle basic query
Office Open office dictionary missing / Not workingdictionary missing
Oracle ORA-12519, TNS:no appropriate service handler foundservice handler
SpagoBI Error retriving the viewpoint listviewpoint list
Oracle Sqldeveloper Startup errorsqldeveloper start
SQL Server Search String in all tables Sql Serverserch string
SQL Server Invalid length parameter passed to the substring function
Buissness Objects Universe Design tool, Unable to connect Datasourceunverse design
Buissness Objects Universe Design Tool - Oracle jdbc connection error
SQL Server Print Value if No Result return by query
Buissness Objects BO1 Prerequisite Window Version Failed
SQL Server The multi-part identifier could not be bound.
SQL Server SQLSERVER Pass Variable in Dynamic SQL
SQL Server SqlServer Procedure expects parameter '@' of type 'ntext/nchar/nvarchar'
SQL Server SQL server error : Could not find stored procedure
SQL Server sqlserver Cannot specify a column width on data type int
SQL Server SQL server encrypt data at column level
SQL Server Window server service failed to start
SpagoBI SP14 Create Birt report and pass parameter in dataset define in SpagoBI server
Support Dell laptop M1530 xps wifi issue
SpagoBI SP13 SEVERE: Unable to open connection.
SpagoBI SP12 SpagoBi wrong parameter pass in query
SpagoBI SP11 The index 1 is out of range.
SpagoBI SP10 Change the spago BI main page image
SpagoBI SP09 Change the spago BI Home screen
Oracle Error while Oracle installation on Windows 7
Oracle SP2-0768: Illegal SPOOL command
SpagoBI SP08 Modify SpagoBi login page
SpagoBI SP07 Spagobi error: invalid entry size (expected " " but got " " bytes)
SpagoBI SP06 Spagobi error apache.catalina.realm.UserDatabaseRealm startInternal
SpagoBI SP05 java.lang.OutOfMemoryError: PermGen space
SpagoBI SP04 Rotate labels of barchart (high chart)
SpagoBI SP03 The field string-"" must me an alphabetical string (only letters)
SpagoBI SP2 Configure spagoBI server - stand alone apache tomcat
SpagoBI SP1 spagoBi error : At least one JAR was scanned for TLDs yet contained no TLDs
QlikView QV29 Find and replace in all expression and conditions
QlikView QV28 Hidden sheets and objects in QLikkview
Oracle oracle database password cracker
Postgres Install PostgreSQL ODBC drivers in Windows
QlikView QV27 Checklist for a good qlikview developer
QlikView QV26 Naming convention for any qlikview project
QlikView QV25 How to tune a qlikview application
QlikView QV24 button - action "Toggle Select"
QlikView QV23 keepchar & purgechar in qlikview
Oracle ROWNUM - Limiting Results and limitations
Mysql export import of mysql database on LINUX machine
Mysql Search string in mysqlMysql, search string in all tables
Postgres alphanumeric sort in postgres
QlikView QV22 Script error code in Qlikview
QlikView QV21 Check column existence in table
Tips and Tricks Change icon for a particular file extension
QlikView QV20 Filter the null values of column in set analysis
QlikView QV19 Replace all null values
QlikView QV18 Duplicate values in dimension
SQL Server Use Go inside the Begin end in sqlserver
QlikView QV17 Subtract number from variable - set analysis expression
Postgres string search in database postgres
Postgres ERROR: cannot change return type of existing function
Postgres Execute postgres SQL script on cmd
Pentaho CHANGE .KETTLE PATH to directory itselfKettle Home, Kettle Properties file
Oracle ORA-03113: end-of-file on communication channel
QlikView QV16 Create calendar dimension using min max date
QlikView QV15 Hierarchy In QLIKVIEW
QlikView QV14 Peek() used in for loop
QlikView QV13 Peek() and previous()
QlikView QV12 Above() Below() function in qlikview
QlikView QV11 Only() function in qlikview
QlikView QV10 Cross table
QlikView QV9 Dynamic Update
QlikView QV8 Partial Reload
QlikView QV7 Generic load in qlikview
QlikView QV6 Preceding Load
QlikView QV5 Incremental loading
QlikView QV4 Link Tables and concatenate tables
QlikView QV3 synthetic keys
QlikView QV2 QVD datafiles
QlikView QV1 Inline Table
Mysql Dynamic Cursor in mysql
SSIS component "Excel Destination" (40) failed validation and returned error code 0xC020801C
Oracle CHAR semantics and BYTE semantics
Oracle SQLNET.AUTHENTICATION_SERVICES
Oracle Connection error ORA-01031: insufficient privileges
Oracle Copy / clone oracle database
Oracle ORA-01503: ORA-01161: ORA-01110:
Oracle backup controlfile to trace / generate script of control file
SSAS Explore cube using microsoft excel
SSAS Some Simple MDX queries
SSAS Create KPI using ssas (Sqlserver analysis services)
SSAS What is KPI - key performance indicator
SOLR SOLR: Adding a new core
SOLR Unable to create core: new_core Caused by: Can't find resource
SSAS 7. Hierarchy using NAMED QUERY in product table
SSAS 6. Hierarchy using dimproduct, category and subcategory
SSAS 5. Cube using dimsalesterritory table
SSAS 4. Create cube with user-define dimension hierarchy
SSAS 3. Create hierarchy on the basis of user-define dimension on self referencing table
SSAS 2. Create cube having hierarchy dimension (self referencing table)
SSAS 1. Create hierarchy on the basis of regular dimension on self referencing table
Cube/SSAS Cube hierarchy and its operations
SSAS SSAS CUBES HIERARCHY examples
Mysql ERROR 29 (HY000): File 'D:\ est.csv' not found (Errcode: 2 - No such file or directory)
Mysql load data from csv file / text file or any external file
Linux remove ^M from file
Oracle RMAN backup error, RMAN-03009 ORA-19809 ORA-19804
Oracle Increase the Size of flash recovery area
Oracle ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
Oracle ArchiveLog & enable archivelog mode
Oracle ORA-12704: character set mismatch
Oracle Recusive delete in oracle
SQL Server Cannot insert explicit value for identity column in table ' ' when IDENTITY_INSERT is set to OFF.
SQL Server The ALTER TABLE statement conflicted with the FOREIGN KEY constraint
SQL Server Use of CASE statement in UPDATE query
SQL Server Cannot insert the value NULL into column '', table ' '; column does not allow nulls. UPDATE fails.
SQL Server uniqueidentifier [guid] vs int
Cube Advantage and disavantage of MOLAP, ROLAP
SSAS Create your first OLAP Cube in SSAS
Cube Storage types of cube MOLAP, ROLAP, HOLAP
SSAS OLAP CUBE
SQL Server Cannot define PRIMARY KEY constraint on nullable column in table
SQL Server Could not create constraint. See previous errors.
Mysql ERROR 1093 (HY000): You can't specify target table ' ' for update in FROM clause
Mysql ERROR 1442 (HY000): Can't update table ' ' in stored function/trigger because it is
Oracle DML Autocommit in oracle
DataWare House Fact Tables and Dimension Tables
Oracle How to get actual explain plan of query in oracle
Oracle Difference between explain plan and autotrace
Oracle Execution plan of query in Oracle
Oracle why query is get faster after create a index
Mysql Enable log in mysql
Mysql Uninstall mysql sever from Linux machine
Mysql Mysql command on linux terminal move to bash shell
Mysql Install mysql in Linux
Postgres Postgres Create drop constraint script with the help of function
Mysql sys_connect_by_path in mysql
Oracle DML- DATATYPE
Oracle Recover database if it is in between crashedRecover Database, oracle, Oradim, create new service, Recover oracle service if deleted
Oracle Oracle Deinstallation
Oracle Oracle 10g installtion in red hat linux (11g)
Oracle ORA-01102 cannot mount database in EXCLUSIVE mode
Oracle Oracle startup error : ORA-01078: failure in processing system parameters LRM-00109
Oracle Error handling in PLSQL – SQLERRM and SQLCODE
Oracle alter table move command
Oracle Space Tuning / Reclaim space from tablespace / Freeup unused space
Oracle Finding USED UNUSED INDEX IN ORACLE
Mysql Nanoseconds / Millisecond in Mysql
SQL Server RowID Equivalent in SQLSERVER
SQL Server SQL Server Delete Cascade
SQL Server Hashbytes sqlserver
Oracle Full Text Index / Domain Index ( create datastore, assign tablespace for storage)
Oracle Lexer -> Basic Lexer -> Printjoins in DOMAIN index
Oracle domain index is marked LOADING/FAILED/UNUSABLE
Oracle ORA-01653: unable to extend table in tablespace string tips
Oracle Number of Session Vs. Processes
SQL Server Sqlserver Full Text Index , PDF population empty
Mysql MySQL data files .MYD, .MYI, and .frm
Mysql Create procedure, Cursor example , execute immediate
Mysql Unused index MySql
SQL Server Translate Equivalent in Sqlserver
SQL Server Lpad & Rpad in sqlserver
DOS Enter username , password in form using batch file / Hide password batch file
DOS Hide password string in batch
Oracle Some Oracle Query Tricks
Oracle Duplicate Index / Redundant Index Oracle
Oracle Sort Characters (of datatype char, varchar) in order of month name
Excel Execute macro for each sheet in a workbook
Oracle Export and Import tablespace on same database
SQL Server [sqlserver] Subqueries are not allowed in this context.
Mysql Error Code: 1175 You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column
Mysql Error: Explicit or implicit commit is not allowed in stored function or trigger.
Mysql Procedure Hierarchical /recursive data (parent-child relationship)
Mysql Connection with MYSQL from a remote machineMYSQL connection with remote machine
Oracle ORA-12154: TNS:could not resolve the connect identifier specified
Mysql Few regular used commands Mysqlregular commands
Mysql Let' us a new start with Mysqlmysql intial
SQL Server INITCAP Function in SQL Serverinitcap
Oracle Used/Free space in a tablespacefind unsed space
Oracle schema / user Logon logoff track oracleschema logon logoff track
Oracle Upload file to BLOB type column/fieldupload content in blob , add content in blob
Oracle Finding UNUSED indexes in oracleunused indexes
SQL Server Msg 5074, Level 16, State 1, Line 1sql server error
SQL Server SQL-SERVER Backup RESTORE errorrestore database
Oracle Error related to /dev/shm while oracle installationinstall oracle
Oracle Uninstall Oracle from Linux Operating Systemuninstall oracle
Oracle sqlplus: error while loading shared libraries: /u01/app/oracle/product/11.2.0/db_1/lib/libclntsh.so.11.1: cannot restore segment prot after reloc: Permission deniedsql plus error
SQL Server SQLCMD errorsql cmd issues
SQL Server SQLCMD not workingsql cmd issues
SQL Server Fulltext Index SqlServerSql server full text index
Oracle SqlDeveloper : Backspace button not workingSQL Developer backspace button
Postgres Forgot username password of POSTGRESrecover username and password Postgres
Oracle Error While configuring "emca"emca error
SQL Server Enabling Remote Connections for MSsqlenable remote connection MSSQL
Oracle Full Text Index errorfull text index error
Oracle dbms_metadata.get_ddl Not DisPlay full queryoracle error , plsql output not shown
SQL Server v$session equivalent in sqlserver ,User Connected to SqlServer and Kill sessionsql server connections
Oracle Create table at Run Timecreate table dynamically
Oracle TRY to execute select query on tablAe , that contains BLOB datatypeselect query on blob column
Oracle ORACLE Error - ORA-01034 & ORA-27101shared memory realm
Oracle SP2-0110: Cannot create save file "afiedt.buf"oracle error
Oracle ORA-28056: Writing audit rec .... solvedWriting audit records to Windows Event Log failed
Facebook Recent facebook contentFacebook Content
Tips and Tricks How To Boot From A USB Flash Drive / Pen DriveInstall windows from pendrive
Software Mount ext2 ext3 partitions in window READ_ONLYMount ext2 ext3 partitions in windows
Software open office 2007 files into Office 2003?Open New office file in Older version
Linux Mount NTFS Partition on RHEL 5.xLinux, Partition mount on Linux
Tips and Tricks Marvell Yukon 88E8040 PCI-E Fast Ethernet Controller Driver for LinuxEthernet card solution, Dell Ethernet issue
Software No Content to Display
Software No Content to display
Software Imagicon 3.0Icon
Worlds Biggest World's Biggest EngineWorlds Biggest
Songs Download hd SongsDownload vedio songs
Windows No Content to displaydeleted story
Windows O.S.os beer story
VB VB Paint 1.02Paint software in VBA
DOS DOS CALCULATOR VER 1.0calulcator in dos
Windows DAA and GBI files to ISOOpen daa file, daa file extension
Windows Increase Window Index rating upto 9.9Increase windows rating
Windows HOW TO LOCK FOLDER !Lock Folder, Security
Windows Brand windows with your name and add your photochange windows properties, hack










No comments:

Post a Comment

web stats