Click here to Skip to main content
14,272,257 members
   

Database

 
GeneralRe: Displaying multiple rows into single row as columns based on id - Sql Server Pin
Mycroft Holmes7-Mar-19 10:50
memberMycroft Holmes7-Mar-19 10:50 
QuestionHelp me with caculate debit balace and incredit by SQL server 2012 Pin
Member 141737536-Mar-19 19:08
memberMember 141737536-Mar-19 19:08 
Rant[REPOST] Help me with caculate debit balace and incredit by SQL server 2012 Pin
Richard Deeming6-Mar-19 21:58
mveRichard Deeming6-Mar-19 21:58 
QuestionSQL Access: Calculate the total elimination of records not the same month and year ? Pin
Member 24584674-Mar-19 21:26
memberMember 24584674-Mar-19 21:26 
QuestionQuery Question Pin
milo-xml1-Mar-19 2:14
professionalmilo-xml1-Mar-19 2:14 
AnswerRe: Query Question Pin
Afzaal Ahmad Zeeshan1-Mar-19 3:19
mveAfzaal Ahmad Zeeshan1-Mar-19 3:19 
GeneralRe: Query Question Pin
milo-xml1-Mar-19 5:31
professionalmilo-xml1-Mar-19 5:31 
GeneralRe: Query Question Pin
Afzaal Ahmad Zeeshan1-Mar-19 7:46
mveAfzaal Ahmad Zeeshan1-Mar-19 7:46 
With that update in the question, first thing that anybody is going to say is to remove the concatenation and use parameters in the query—it will protect you from SQL Injection.

Secondly, there are so many LIKE operators, why are you using searches on the table, and trying to match every column with the input. A quick tip would be, use a separate search for each column and then try to aggregate the overall results. This would have a little amount of WHERE clause, and the query would end quickly, yours is having multiple OR clauses, which is not letting SQL Server short-circuit the query either and is making it run on each of the records.

I would also not be so sure as to whether any indexing would speed up things, but you can try adding indexes on these columns. Read this for more on that, tsql - SQL Server: Index columns used in like? - Stack Overflow

So, you can start by:
1. Add indexers to the columns as needed. You will know where to add them.
2. Create separate stored procedures to find the query results. Then try to aggregate the result of all queries.
3. Use caching to store the results of the most recent queries.
4. Also, try using full text search capabilities of SQL Server.

Full-Text Search - SQL Server | Microsoft Docs
sql - What is Full Text Search vs LIKE - Stack Overflow
The sh*t I complain about
It's like there ain't a cloud in the sky and it's raining out - Eminem
~! Firewall !~

GeneralRe: Query Question Pin
milo-xml1-Mar-19 8:05
professionalmilo-xml1-Mar-19 8:05 
AnswerRe: Query Question Pin
Eddy Vluggen1-Mar-19 7:46
mveEddy Vluggen1-Mar-19 7:46 
GeneralRe: Query Question Pin
milo-xml1-Mar-19 8:03
professionalmilo-xml1-Mar-19 8:03 
GeneralRe: Query Question Pin
Eddy Vluggen1-Mar-19 8:51
mveEddy Vluggen1-Mar-19 8:51 
QuestionMANAGEMENT DOCUMENT Pin
Member 1413102419-Feb-19 2:23
memberMember 1413102419-Feb-19 2:23 
AnswerRe: MANAGEMENT DOCUMENT Pin
Eddy Vluggen19-Feb-19 3:09
mveEddy Vluggen19-Feb-19 3:09 
AnswerRe: MANAGEMENT DOCUMENT Pin
CHill6019-Feb-19 4:14
protectorCHill6019-Feb-19 4:14 
AnswerRe: MANAGEMENT DOCUMENT Pin
Victor Nijegorodov19-Feb-19 9:27
memberVictor Nijegorodov19-Feb-19 9:27 
GeneralRe: MANAGEMENT DOCUMENT Pin
jschell23-Feb-19 11:03
memberjschell23-Feb-19 11:03 
GeneralRe: MANAGEMENT DOCUMENT Pin
Victor Nijegorodov23-Feb-19 11:07
memberVictor Nijegorodov23-Feb-19 11:07 
AnswerRe: MANAGEMENT DOCUMENT Pin
ZurdoDev1-Mar-19 5:52
professionalZurdoDev1-Mar-19 5:52 
QuestionHibernate error ORA-02289: sequence does not exist [SOLVED] Pin
Valentinor16-Feb-19 5:37
memberValentinor16-Feb-19 5:37 
AnswerRe: Hibernate error ORA-02289: sequence does not exist Pin
Richard Deeming18-Feb-19 1:42
mveRichard Deeming18-Feb-19 1:42 
GeneralRe: Hibernate error ORA-02289: sequence does not exist Pin
Valentinor18-Feb-19 2:37
memberValentinor18-Feb-19 2:37 
AnswerRe: Hibernate error ORA-02289: sequence does not exist [SOLVED] Pin
Valentinor18-Feb-19 2:59
memberValentinor18-Feb-19 2:59 
QuestionOracle SQL Developer filter "default tables" [SOLVED] Pin
Valentinor16-Feb-19 3:16
memberValentinor16-Feb-19 3:16 
AnswerRe: Oracle SQL Developer filter "default tables" Pin
Jörgen Andersson16-Feb-19 7:25
protectorJörgen Andersson16-Feb-19 7:25 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.