| CMD, Batch | CMD : code to copy the files from 1 folder to another | Copy files to another folder, Pass file name in file, command Prompt, xcopy, copy source to destination |
| CMD, BAtch | CMD : Copy the Folder Structure only | Copy Folder Structure, XCOPY command, batch, command prompt |
| SQL Server | SQL Server Database in Single User Model | SQL 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 Screen | Taskbar overlapping, remote machine, mstsc |
| Oracle Apps | The Certificate is not valid and cannot be used to verify | Java Home |
| Oracle | Oracle Database IMPDP Error | Oracle 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 Query | SSMS SQL Server Management Studio, close automatically when execute Query |
| SQL Server | Search String in SQLServer in All databases all tables all columns | Search String in SQLServer in All databases all tables all columns |
| SQL Server | SQL Server Installation Error | Error 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 wise | query 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" Error | Kyocera, MFP, Add toner |
| PHP | How to Launch First Page using XAMPP on local machine | Xampp first Page launch on local machine |
| Java Script,PHP | Create Search TextBox on Webpage | Search box, search from table, Embed with website |
| Macro | Macro to Change the Font/Color/Size/Alignment of Text Box content PowerPoint | Macro Code, Powerpoint, excel, change Font properties |
| Excel | Macro Code to Copy Content from Excel File to PowerPoint, Each Row to Each Slide | Excel, Macro Error, Copy content from Excel to Powerpoint, excel rows data to powerpoint |
| VB | VB : run time error 429: ActiveX component can't create object | Visual Basic, Macro, run time error 429: |
| VB | VB : Compile Error: User Defined Datatype not defined | Visual Basic, macro error |
| Oracle | ORA-12899: value too large for column ColumnName | IMPDP, 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 Backup | IMPDP, 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 Rows | String to rows, comma separated string to rows, query Logic, SQL Excercise, Requirement solution, Practice, Query Logic |
| SQL Server | Concatenate Rows in SQL Server | Concatenate 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 Server | Window function, over Partition by, sum, avg, min, max, row_number, query Logic |
| Oracle | ORA-01940: cannot drop a user that is currently connected | Oracle Kill users |
| Oracle | Kill Connection of Connect Users Oracle | Kill connected Users |
| Oracle | Kill EXPDP Job -Oracle | Oracle import export impdp, expdp error, kill job |
| Oracle | ORA-02304: Invalid Object Identifier Literal | Oracle Database Restore Error, IMPDP |
| Oracle | Error While Restore Oracle Database - ORA-28365: wallet is not open | Database restore error , wallet is not Open |
| Excel | Minus 2 dates and calculate the difference in years/Months/Days separately | Minus 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 Days | Minus/Subtract 2 dates in Excel, Result is not showing in Number of Days |
| SQLServer | SQL Server : Find Out the List of Backups taken of Database | SQLServer List of backup done for a database, Audit |
| SQLServer | Interview Question 2 - Count of all Occurrence of status/color until it changes to another | Logical 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 both | Logical Question Solution in SQLServer,SQL Excercise, Requirement solution, Practice, Query Logic |
| Oracle | ORA-28040: No matching authentication protocol | Connection Issue Oracle Update SQLNet.ora file |
| Oracle | TNS-12560: TNS:protocol adapter error/ TNS-00530: Protocol adapter error | Oracle TNS Error |
| Computer | Change Machine Password While Working on Remote Machine | Change Password, Remote Machine, Remote VM, MSTSC |
| Oracle | ERROR While EXPDP (Oracle Restore) : ORA-39143: dump file "c:\**********\.dmp" may be an original export dump file | ORA-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/Files | Duplicate Documents Generate, Copy of Documents, Batch, cmd, random files |
| SQLServer | Basic SQL interview Questions - Part 1 | Basic Interview questions, SQL Excercise, Requirement solution, Practice, Query Logic |
| SQLServer | SQLServer Function Replace Special Char | Replace Special Character, Function,SQL Excercise, Requirement solution, Practice, Query Logic |
| Oracle | SYS.DBMS_DATAPUMP' must be declared | Oracle Restore Error, Oracle_SID, Oracle SID |
| SQL Server | Database Database Name is already open and can only have one user at a time | Database Single User mode, Multi user Mode,SQL Server Database Restore Error |
| Postgres | pg_dump Postgres Backup Restore Error | Postgres Restore Error, Version Issue |
| SQL Server/Oracle | How to Find Duplicate Records in Table | Interview Question | Study SQlServer, Duplicate Records Concept , Row_number usage |
| SQL Server/Oracle | The transaction log for database 'Database Name' is full due to 'LOG_BACKUP | SQL 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 Reorganize | Index Rebuild SQLServer, Cursor, Ifelse, Dynamic Query, Execute Immediate,SQL Excercise, Requirement solution, Practice, Query Logic |
| SQL Server | Drop table If Already Exists SQLServer | Drop 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 extend | ORA-32773 operation not supported, smallfile, tablespace ORA-01653 extend, oracle, loop, plsql, plsql insert |
| Linux | Rebuild Linux RPM | Rebuild Linux RPM |
| Oracle | Rebuild All Indexes using 1 SQL | Single query | Oracle, 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 date | Change 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 file | Execute 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 1 | Connection, Connect error SQL CMD, sqlcmd, sqlcmd with SQL Server, Execute query on sqlcmd |
| SQL Server | How to execute query on CMD | Execute multiple query on sqlcmd, semicolon not working |
| SQL Server | SQL Server - Set Default Time stamp in date | set default time, add time in date, default timestamp, time stamp |
| Pentaho | Invalid byte 1 of 1-byte UTF-8 sequence | Kettle table input step special character replacement from SQL Query |
| Python | py0019 : Color code in idle Python Shell | Color 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 Table | row count of each table sql server |
| SQL Server | print row count in begin try on delete | delete result show in result window, print delete command result, print delete result, begin try catch, begin end |
| oracle | Count of Each Table Oracle | cursor in oracle , for loop in oracle, execute immediate, dynamic sql execution |
| oracle | Simple Cursor and For Loop in Oracle | curso in oracle, for loop in oracle, cursor for loop |
| Python | py0018 : Change color of button on hover and borderless button | change 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 supported | trace only in SQL Developer |
| SQL Server | Deleted Offline Database? No Issue | offline database |
| SQL Server | Delete Offline Database and Space Recovery | Recovery |
| SQL Server | SQL Server Audit Table Total Count Total Nulls Len of Data | row count, total count in table, each field count, and each field maximum data length |
| SQL Server | Foreign Key Reference Tables | parent and child references |
| SQL Server | SQL Server Database Restore Audit | identify 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 used | identify 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 defined | select 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 python | use function from another file |
| Python | py0012 : try catch in Python / DB connection in try catch | try catch in python |
| Python | py0011 : Learnt Something impressive in Python | Learnt Something impressive in Python |
| Python | py0010 : Firefox not opening Websites which are in Tunnel/Proxy | firefox not working with python, proxy issue |
| Python | py0009 : How to Declare Variable and Use variable in same file of Other file | python declare variables |
| Python | py0008 : connection with sqlserver database | connection sqlserver |
| Python | py0007 : Click on div ul li span class "Display Name" Selenium Python | element 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 capabilities | pthyon |
| Python | py0004 : Begginner error, Open Firefox | python not able to open firefox |
| Python | py0003 : pip install selenium SyntaxError: invalid syntax, while install selenium | pip install command |
| Python | py0002 : No Python interpreter is selected | interpreter |
| Python | py0001 : could not find main class com/intellij/idea/main | could not find main class |
| Oracle | dba_data_files data file not appears but dbf file in exists on FileSystem | dbf file not exists in filesystem oracle |
| Oracle | Error ORA-01144: File size (5242880 blocks) exceeds maximum of 4194303 blocks | oracle tablespace issue |
| SQL Server | Convert Semicolon Separated String in Rows Along With Respective Data | semicolon Separated data |
| SQL Server | SQL Server | DB Restore Error | Restore error, Active Connection , Database already in use, kill active connections, kill connection |
| Excel | MACRO to List Out All Tab Names Along With Field Header Name | Macros |
| QlikView | QV30 Qlikview Interview Questions | Interview question |
| SpagoBI | failed to load the jni shared library | jni library |
| SpagoBI | java was started but returned exit code 13 | exit code 13 |
| Excel | Add Random Data in Spreadsheet | Generate random data |
| Talend | Talend Startup Error | talend error, Setup JDK, JDK missing |
| Xampp | Xampp Starting Error | Xampp |
| Cassandra | Java HotSpot(TM) Client VM warning: Cannot open file /cassandra37/logs/gc.log due to No such file or directory | cassandra |
| 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 fields | inconsistent checkpoint in hadoop |
| Hadoop | Hadoop datanode/namenode error | name node error in hadoop |
| Hadoop | Unable to instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClient | metastore |
| Hadoop | RuntimeException org.apache.hadoop.security.AccessControlException | Runtime exception |
| Hadoop | The system cannot find the batch label specified - nodemanager | batch label |
| Pentaho | Want to save kettle Logging in database? | logging database |
| Solutions | database url and driver | url and driver |
| Oracle | Playing With SQL Quries | SQL Queries fun |
| Pentaho | Create Folder/Subfolder in transformation java script | Folder in java |
| Pentaho | Get the list of all tables using JDBC driver using kettle | get list of all tables |
| Pentaho | Define Variable for Database Connection in kettle | database connection, connection variables, dynamic connection in kettle etl tool |
| Oracle | ORA-00119: invalid specification for system parameter LOCAL_LISTENER | oracle |
| Oracle | ORA-39095: Dump file space has been exhausted: Unable to allocate 8192 bytes | oracle |
| Oracle | want to divide table into 10 equal parts | table division |
| Excel | How to auto delete macro code after execution | delete macro code |
| Excel | Auto Open [Run] macro code - when workbook open | Auto open excel |
| SQL Server | Add/upload documents in image or varbinary datatype | add images in field |
| Pentaho | How to pull out blob content out to a directory using kettle | blob 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 transformation | replace speacial char |
| Pentaho | Split string on the first occurrence of underscore using kettle | split data |
| SQL Server | SQLServer - Integer Format | integer formatiing |
| SQL Server | SQLSERVER - licensed limit of 10240 MB per Databae | limit 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 sequence | Table Input |
| Pentaho | kettle - Filter step not working initialize both input steps | Filter 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 long | string 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 column | rotate table |
| Oracle | LISTAGG function giving extra spaces in result | listagg function |
| Windows | Share files with Virtual machine | share file |
| Oracle | ORA-00054: resource busy and acquire... | resource busy |
| Oracle | Some Oracle Basic Queries | oracle basic query |
| Office | Open office dictionary missing / Not working | dictionary missing |
| Oracle | ORA-12519, TNS:no appropriate service handler found | service handler |
| SpagoBI | Error retriving the viewpoint list | viewpoint list |
| Oracle | Sqldeveloper Startup error | sqldeveloper start |
| SQL Server | Search String in all tables Sql Server | serch string |
| SQL Server | Invalid length parameter passed to the substring function | |
| Buissness Objects | Universe Design tool, Unable to connect Datasource | unverse 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 mysql | Mysql, 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 itself | Kettle 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 crashed | Recover 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 machine | MYSQL connection with remote machine |
| Oracle | ORA-12154: TNS:could not resolve the connect identifier specified | |
| Mysql | Few regular used commands Mysql | regular commands |
| Mysql | Let' us a new start with Mysql | mysql intial |
| SQL Server | INITCAP Function in SQL Server | initcap |
| Oracle | Used/Free space in a tablespace | find unsed space |
| Oracle | schema / user Logon logoff track oracle | schema logon logoff track |
| Oracle | Upload file to BLOB type column/field | upload content in blob , add content in blob |
| Oracle | Finding UNUSED indexes in oracle | unused indexes |
| SQL Server | Msg 5074, Level 16, State 1, Line 1 | sql server error |
| SQL Server | SQL-SERVER Backup RESTORE error | restore database |
| Oracle | Error related to /dev/shm while oracle installation | install oracle |
| Oracle | Uninstall Oracle from Linux Operating System | uninstall 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 denied | sql plus error |
| SQL Server | SQLCMD error | sql cmd issues |
| SQL Server | SQLCMD not working | sql cmd issues |
| SQL Server | Fulltext Index SqlServer | Sql server full text index |
| Oracle | SqlDeveloper : Backspace button not working | SQL Developer backspace button |
| Postgres | Forgot username password of POSTGRES | recover username and password Postgres |
| Oracle | Error While configuring "emca" | emca error |
| SQL Server | Enabling Remote Connections for MSsql | enable remote connection MSSQL |
| Oracle | Full Text Index error | full text index error |
| Oracle | dbms_metadata.get_ddl Not DisPlay full query | oracle error , plsql output not shown |
| SQL Server | v$session equivalent in sqlserver ,User Connected to SqlServer and Kill session | sql server connections |
| Oracle | Create table at Run Time | create table dynamically |
| Oracle | TRY to execute select query on tablAe , that contains BLOB datatype | select query on blob column |
| Oracle | ORACLE Error - ORA-01034 & ORA-27101 | shared memory realm |
| Oracle | SP2-0110: Cannot create save file "afiedt.buf" | oracle error |
| Oracle | ORA-28056: Writing audit rec .... solved | Writing audit records to Windows Event Log failed |
| Facebook | Recent facebook content | Facebook Content |
| Tips and Tricks | How To Boot From A USB Flash Drive / Pen Drive | Install windows from pendrive |
| Software | Mount ext2 ext3 partitions in window READ_ONLY | Mount 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.x | Linux, Partition mount on Linux |
| Tips and Tricks | Marvell Yukon 88E8040 PCI-E Fast Ethernet Controller Driver for Linux | Ethernet card solution, Dell Ethernet issue |
| Software | No Content to Display | |
| Software | No Content to display | |
| Software | Imagicon 3.0 | Icon |
| Worlds Biggest | World's Biggest Engine | Worlds Biggest |
| Songs | Download hd Songs | Download vedio songs |
| Windows | No Content to display | deleted story |
| Windows | O.S. | os beer story |
| VB | VB Paint 1.02 | Paint software in VBA |
| DOS | DOS CALCULATOR VER 1.0 | calulcator in dos |
| Windows | DAA and GBI files to ISO | Open daa file, daa file extension |
| Windows | Increase Window Index rating upto 9.9 | Increase windows rating |
| Windows | HOW TO LOCK FOLDER ! | Lock Folder, Security |
| Windows | Brand windows with your name and add your photo | change windows properties, hack |
No comments:
Post a Comment