Showing posts with label plan. Show all posts
Showing posts with label plan. Show all posts

Monday, March 19, 2012

How to use regular expressions on SSIS?

Hi everyone,

Is it possible? I haven't idea how to implement as if it were done from conventional .Net code

I'd like to check every field for a plan file

First field NNNNNNN

Second field XXXNNNNNNN

,,

Thanks for any input or idea,

You can use a script task ; an example of using here

About the second part of question an ideea can come from here.

|||This transform may also be of use - http://www.sqlis.com/91.aspx|||

Thanks indeed to both. It's useful.

|||

Hi Darren,

Regarding your link about Regular Expressions tasks, unfortunately, third-components are not allowed in our environment...

|||

enric vives wrote:

Hi Darren,

Regarding your link about Regular Expressions tasks, unfortunately, third-components are not allowed in our environment...

That's uunfortunate!

|||

I appreciate many organisations think that way.

I would be interested in knowing why that is the case for you?

What would it take to allow such component usage in your organisation? I'd be happy to see what could be done to help people like youself in these situations. Do you not use any non-MS products? If you are intertested then I'd be happy to discuss this further or offline, mail me darren dot green at konesans com

How to use query analyzer to find the most efficient one in many select statemen

Hi, everyone.
I have read a lot of topics about execution plan for query, but I got little.
Please give me some help with examples for comparing different select statements to find the best efficient select statement.
Thank you very much.Avoid table scans like the plague. Use "where" clauses whenever possible to reduce the amount of raw data you're working with. Make sure you have proper indexing. Also, read this:

http://www.databasejournal.com/features/mssql/article.php/1437391|||hi,
you can check this web site : http://www.sqlservercentral.com/columnists/rmarda/performanceaddinghints_printversion.asp
it's under (Using The Index Hint) section
good luck|||A simple "first pass" that can sometimes make it clear which statement is a dog and which is good is to:

Pop all your select statements in a single window in QA. Hit Ctrl + K. Hit F5. Look at the query plan window.

You will see a plan for each statement including an "overall cost" for each statement. Sometimes this shows you clearly which is better\ worse without a need to look much further.

For more detailed optimisation you need to look at the individual components of the plans, run things like SET STATISTICS IO ON, SET STATISTICS TIME ON, look at Profiler and so on.|||IMHO you should avoid index hints until you are much more comfortable with optimisation and query tuning.