Hi Andy,

Thanks for your great write up on the BIML, they have a  great help to my learning of BIML.

I know it is a bit cheeky...

I am having challenges with the reference data -- version control/keeping track of the reference data especially the large ones (> 100000 rows). I am thinking of using the merge...

I strike the gold today.

Thank you very much for the efforts and sharing with the community. Have been thinking of doing the similar thing but always got pushed out by...

Thanks for the reply,

I am talking about updating one table at a time as whole transaction. The 30% seems to be about right as we did the update on the...

Thanks for the quick reply,

Sounds good. Look forward to it.

Alan

Thanks Stan for the great post,

One thing I found with SSIS and XML is it is relatively easy to deal with the simple xml but very hard when working on...

Hi Lynn,

I was reading MCITP 70-432 ebook and came cross this section explaining why tran log won't free up:

The database is participating in replication and the distribution database is...

Cool. It's not currently a problem for us as we don;t use table partition and I will remove the restriction on lob/re-org.

Have a good weekend!

Thanks again

Thanks Jack for the very quick reply,

Indeed I am looking at both Ola's and Michelle's index scripts :-). At this stage, I am more for Michelle's script as it's more...

If not clustered index, drop and recreate the index.

Alan

If you clear the procedure cache actually makes the script running faster, it's very likely your db stats is out of dated so the exec plan SQL produced is not...

I have never used the table partition in production before. I heard the table partition is better for OLAP data warehouse, is this true? If it is, does it have...

I had the similar problem in the past. The problem was from a backup job based on maintenance plan. The rollback would never finish and new backup couldn't not be...

I have done the log shipping between SQL 2000 and SQL 2005 using my own scripts. I haven't tried it myself but I would think technically you could logship between...