Click here to Skip to main content
15,914,163 members
Home / Discussions / Database
   

Database

 
GeneralRe: T-SQL Help Pin
Steven J Jowett5-Sep-07 22:27
Steven J Jowett5-Sep-07 22:27 
QuestionHigh Volume of Insert Statement Pin
logicon5-Sep-07 6:38
logicon5-Sep-07 6:38 
AnswerRe: High Volume of Insert Statement Pin
Colin Angus Mackay5-Sep-07 8:34
Colin Angus Mackay5-Sep-07 8:34 
GeneralRe: High Volume of Insert Statement Pin
logicon5-Sep-07 9:33
logicon5-Sep-07 9:33 
GeneralRe: High Volume of Insert Statement Pin
Colin Angus Mackay5-Sep-07 9:45
Colin Angus Mackay5-Sep-07 9:45 
GeneralRe: High Volume of Insert Statement Pin
logicon5-Sep-07 11:05
logicon5-Sep-07 11:05 
GeneralRe: High Volume of Insert Statement Pin
Colin Angus Mackay5-Sep-07 12:36
Colin Angus Mackay5-Sep-07 12:36 
QuestionKeyword search in Stored Proc Pin
martin_hughes5-Sep-07 4:08
martin_hughes5-Sep-07 4:08 
I've done some googling and reading, and found a few solutions to this, but none that struck as being being particularly elegant, so thought I'd ask for some advice Smile | :)

I have a dynamically generated sql query which enables users to do keyword searches. The user can specify some wildcards to enable partail matching and so forth. It works, and is fairly secure - well I think it is, but I'm sure some crafty soul could hack it if they wanted to.

Anyway, while it works, I'd like to remove all of the querying logic from my application in to stored procedures (as much as a proof of concept and learning exercise than anything else), but I'm becoming unstuck by my lack of T-SQL knowledge.

The major problems I'm having are:
1) How to parse the input string and build the search criteria (including wildcards)
2) How to efficiently iterate over a record set and pull out records matching the criteria

As noted earlier, I have found some solutions - but the amount of SQL involved was fairly impressive, involving the building of temprorary tables, and multiple passes of the table etc. I just get the feeling that given a relatively large table (about 3 million records), performance is going to be an issue.

I'm not too concerned about being bound to SQL Server 2005 in this instance, so could anybody point me in the right direction of the techniques and language constructs I should look at? Woould this be an ideal place to use a CLR stored procedure?


Me: Can you see the "up" arrow?
User:Errr...ummm....no.
Me: Can you see an arrow that points upwards?
User: Oh yes, I see it now!

-Excerpt from a support call taken by me, 08/31/2007

QuestionToo much time consumed while binding datatable to grid Pin
Nouman Bhatti5-Sep-07 1:42
Nouman Bhatti5-Sep-07 1:42 
AnswerRe: Too much time consumed while binding datatable to grid Pin
Michael Potter5-Sep-07 3:58
Michael Potter5-Sep-07 3:58 
GeneralRe: Too much time consumed while binding datatable to grid Pin
Nouman Bhatti6-Sep-07 19:49
Nouman Bhatti6-Sep-07 19:49 
GeneralRe: Too much time consumed while binding datatable to grid Pin
Michael Potter7-Sep-07 3:21
Michael Potter7-Sep-07 3:21 
QuestionCrystal Report Query Engine error Pin
santhoshmohan4-Sep-07 23:48
santhoshmohan4-Sep-07 23:48 
AnswerRe: Crystal Report Query Engine error Pin
Frank Kerrigan5-Sep-07 0:47
Frank Kerrigan5-Sep-07 0:47 
JokeRe: Crystal Report Query Engine error Pin
Colin Angus Mackay5-Sep-07 1:21
Colin Angus Mackay5-Sep-07 1:21 
QuestionInvoking function inside a Stored procedure affect perfomance?? Pin
Vipin.d4-Sep-07 23:06
Vipin.d4-Sep-07 23:06 
AnswerRe: Invoking function inside a Stored procedure affect perfomance?? Pin
Vasudevan Deepak Kumar4-Sep-07 23:15
Vasudevan Deepak Kumar4-Sep-07 23:15 
GeneralRe: Invoking function inside a Stored procedure affect perfomance?? Pin
Vipin.d5-Sep-07 4:35
Vipin.d5-Sep-07 4:35 
AnswerRe: Invoking function inside a Stored procedure affect perfomance?? Pin
Frank Kerrigan5-Sep-07 0:56
Frank Kerrigan5-Sep-07 0:56 
QuestionFilter the Null Column Pin
RichardBlare4-Sep-07 22:59
RichardBlare4-Sep-07 22:59 
AnswerRe: Filter the Null Column Pin
Vipin.d4-Sep-07 23:07
Vipin.d4-Sep-07 23:07 
GeneralRe: Filter the Null Column Pin
RichardBlare4-Sep-07 23:34
RichardBlare4-Sep-07 23:34 
AnswerRe: Filter the Null Column Pin
Vasudevan Deepak Kumar4-Sep-07 23:40
Vasudevan Deepak Kumar4-Sep-07 23:40 
AnswerRe: Filter the Null Column Pin
kumarrumak5-Sep-07 0:48
kumarrumak5-Sep-07 0:48 
AnswerRe: Filter the Null Column Pin
Frank Kerrigan5-Sep-07 1:00
Frank Kerrigan5-Sep-07 1:00 

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.