I've seen that happen (inserting multi-millions of rows into an empty table taking hours) when using a clustered index on the target and the records are inserted in an order...

I totally agree with The Dixie Flatline. Indexes, indexes, indexes. The one caveat I have found working on ETL processes is that having indexes on the tables being...

This is a great post and a great demo of recursion capabilities in T-SQL/SPs. My current issue is the duplicate key/ID in the source data. What I am...

The easiest way to change the URL that users access the Report Manager with is to set up a DNS entry with the desired name pointing to the full address....

<retracted>

I believe the problem with the original statement was how SQL Server handles single. vs. double quotes. In your code, SQL Server was getting confused between the single quote...

I'm with HansVE and the others on the TinyInt split of the address. You can index those columns on any table that includes them and then join each of...

A very interesting article, which I have bookmarked for future reference. I, too, find SSIS difficult to learn coming from a VB/.NET/T-SQL background. I ended up building an...

Whatever others say, I think this is great. I have always needed the ability to execute a SQL Agent job from a web page in an on-demand fashion, and...

This is a great, albeit rather standard, technique for conditional WHERE clauses. Performance has never been an issue for me as long as the evaluated condition is efficient (i.e....

Richard Briggs (3/13/2009)

---

Hey Comrades

how about creating a Peristed Calulated column in your 'person' table.

The column would call one of the function solutions you have discussed.

This makes is easier...

This was perfect timing, Lynn, since I need to produce an Age column in a view for patients in our medical facility. Since I only need to know the...

For Irina: The error is coming from the report itself. It cannot find the DLL. Make sure you add the reference in your *report* project to the...

I have been getting column names with the data when copying the grid to Excel all along. I just click the blank square in the upper left corner of...

I agree with the last sentence in the editorial that project managers need to coordinate issues and then get out of the way. PM is a full time job...