I have already done the bets guess indexing, of fields like you suggested and fields that are used for joins or criteria on some of the queries I have been...

Relational Model.

Thanks,

Chris

The way I approached this was to look at the key between the various tables, which would be the field everyone joins on, thinking that would be the best field...

That's great. I'd still like to learn how to deal with spaces for my case, as educational now, more than functional. I will probably be happier using what you have...

I looked at Jeff Moden's function and I don't know that I like being limited to 8K for that function.

On the parameters, that's the way I designed it:

Create Function dbo.Split(@S...

the end goal here is a Split function, which will split a string into fields based on specifying the delimiter. This is for the ETL development I do, which takes...

mister.magoo

You da man! It was a trigger the DBAs had put in the DB to automatically grant execute on items that were created by non-Sysadmins in the DB, but have...

I have also set a DB offline to get exclusive access to it for a restore. Sometimes you have a program that automatically re-establishes a DB connection, as it should,...

Thanks Andrew, that worked like a champ. The help for SSMS, BOL, does not explain enough about special characters and forming the expressions. Your example is making more sense as...

I don't think that SSMS will recognize that. I don't think that Left() is a regular expression operator.

Keep in mind that I am not talking about SQL Server functions here....

Turns out SSIS didn't like the double Nulls and would not cooperate with my various attempts to remove the Nulls.

Here's how I handled it.

1. Load all data into a text...

Well the point in this step of the package I'm developing is to verify that the fixed-length records in this file (no delimiters) have only numerals in the locations of...

Been messing with it a while, and this is what I have come up with. Taking other ideas though.

IsNumeric(IsNull(Replace(NUM_CAP_DAYS, Char(00), 0),0)) = 0

This returns a True for IsNumeric if the...

Configuration files are your friend. You set up a config file with the necessary configuration items in it for each environment you need to run under. When you run the...

I would definitely set up an error destination, even if it's a text field in another table, and change your transformation to send the errors there.

I have to process...