If you go via a CLR regex function, you can try this regex to see if it satisfies your spec:

(?xm)^[+-]?\d{1,3}(,\d{3})+(\.\d+)?$

|

^[+-]?\d{1,3}(\.\d+)?$

tested in RegexBuddy vs this input:

-4.012

6berry

+8

-234,345,234.012

7

pbo.PoBox34

got mathes:

-4.012

+8

-234,345,234.012

7

without seeing your...

it is an SSIS package, and yes at times I call a child package from within a parent one.

Thank again for your help. It seems you showed me a way...

Thanks, Brandie.

does it mean that in this new solution I'll need to rebuild all supporting objects like datasources, smtp managers, referenced packages etc? Or I could be able to reference...

RE: Best bet for users (ones who aren't tools written by Microsoft) is to create the indexes on a test DB and run their tests.

Thanks, I'll follow your advice.

if the reports are failing when you run them in the SSRS Report Server/Manager , next I usually:

1. open the reports up in Visual Studio SSRS Solution and make sure...

Have you established that your two servers can talk to each...

GilaMonster (6/5/2012)

---

It's been possible since SQL 2000 or before, but it's undocumented and needs options that you, as a user, don't have. It's how DTA works. It creates hypothetical indexes...

in VisualStudio, in your SSRS Solution, right-click on a Project [one of...

without seeing actual data you are trying to load into a table from a flat file it's hard to see what's wrong.

can you create a small test file, say with...

thank you for your answer.

alternatively one can use .NET Regex.Match Class method to create a SQL scalar-valued CLR function to find those junk chars

in the range between \u0020 and \u007F [those one above ascii...

Pablo, Thanks for your prompt response.

Sergei Z

RE: Just be sure the WHERE clause includes "TRANSACTIONDATE between low-limit and high-limit" where low-limit and high-limit exactly match a specific partition that should tell SQL Server to hit a...

Is TRANSACTIONDATA the table expected to get the updates?

SQL Server 2008 has the ability to escalate locks to "partition" level before locking the whole table - this would...

PaulB-TheOneAndOnly (3/26/2012)

---

Shame these are not partitioned tables 🙂

Probably the easiest way run this process in batches and even do it in parallel would be to use the content of NBSEQUENCE,...