Gee Craig, I don't know what to say, except wow! I got pulled into an SSIS mess yesterday afternoon so did not have time to do any testing. Even if...

No problem. I am curious now though, because a default of 100 is not really appropriate for most shops IMO...I usually change the default to 90 on all my systems...

Adrian Strudwick (6/24/2011)

---

Thanks guys - will make sure we have both backed up then (think we do already - certainly MSDB is).

I was aware of scripting out the linked server...

Here's a query I have used in the past to generate commands I can run later. The script was not tested on partitioned tables. Adjust the WHERE clause and fill...

PS The column does not have to be persisted either. A computed column would keep the footprint of the table down and still qualify for inclusion in an index.

AFAIK the WHERE clause is evaluated before the SELECT column list so what you're describing makes no sense to me. If you can reproduce the situation please post sample DDL,...

Workloads are useful for this: http://msdn.microsoft.com/en-us/library/ms190957.aspx

You can set the default for the database back to 0 (functionally same as 100) with this...

sp_configure 'show advanced options', 1;

GO

RECONFIGURE;

GO

sp_configure 'fill factor', 100;

GO

RECONFIGURE;

GO

...however that only affects new indexes that...

If you're still out there I may have found a workaround for you. Try adding a no-op select statement to "declare" metadata to the pipeline.

Credit here:

http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/ee686cf8-0880-4a1d-8706-ba72fbb2eba8/%5B/url%5D

I just ran into the...

Thanks for taking the time, I appreciate your responses. You're correct Kevin, the thread definitely took on a slightly different personality once indexes were added to the mix and so...

TheSQLGuru (6/23/2011)

---

I also note that it should be better to put the data into the table and THEN build the index. Should be both faster AND result in a...

He's going from a Java data structure to a SQL table, not a SQL table to another SQL table.

You're very welcome 🙂

I see. It appears that Data Manager is the problem. Unless Data Manager can be configured to generate those insert statements with the N in front of the string literal...

I just looked up Oracle's SPOOL and I don't know of anything equivalent in native T-SQL. You could write or borrow a SQLCLR function that can write to a text...