Answer / Saurabh Sonkar

It seems like you are asking about SQL performance issues. This question requires specific information about the database schema, indexes, queries, and server configuration to provide an accurate answer. Some common causes of performance degradation include insufficient indexing, inefficient queries, improper use of JOINs, and resource contention.

What severity level errors are managed in TRY-CATCH block?

1 Answers  

---

i have created ODBC through Data sources and tests completed sucessfully. when i am Trying to connect SQL Server through ODBC (ODBC :Oracle Open Client Adapter for ODBC 2.0.2.15.0 Microsoft SQL Server 09.00.3054) unable to Connect to SQL*Plus: Release 8.0.4.0.0. it is given following error-message . Error: ORA-03121: NO interface driver connected- function not performed.

1 Answers   Investment Bank,

---

when i save float data value 11.22 but this see in table 11.220000004758456 type ? how to save only two decimal point.

1 Answers  

---

hp asking for replication floppy to do reinstall 25254 server assistant

1 Answers  

---

Hi, I am trying to encode data from flatfile and then to decode the encoded data to original form. Procedures that I followed:- 1. Encoded the field 'A_ID' using AES_ENCRYPT(A_ID,'abd') in the expression transformation. The A_ID got encoded in the output table(oracle) 2. To decode this back I used AES_DECRYPT(A_ID,'abd'). But after executing the workflow, I am not getting any data in output. can anybody tell me how to decrypt the encoded data back to original form ??

1 Answers  

---

I entered the data in SQL toad version 9.0.1 in English and Arabic language but when i do the query i get the data in Arabic language with (??? question mark) ,please your support.

1 Answers  

---

What is the meaning of lock escalation and why/how to stop this?

1 Answers  

---

WHAT IS HTTP 500 Internal Server Error? CAN I SOLVE THIS?

4 Answers   CTS, Infosys,

---

In one table there is 10 records without id num,without primary key and it is not sorted then how to extract last 6 record from table?

4 Answers  

---

java.sql.SQLException:Invalid state, the statement object is closed Hai all i got this error when i am multiple times referesh web page

1 Answers   HCL,

---

How will you Handle Error in SQL SERVER 2008?

1 Answers  

---

When you get following error? Error 3154: The backup set holds a backup of a database other than the existing database.

1 Answers  

---