When I copied and pasted this from SSMS, it lost most of the formatting, like tabs etc.  What's the best way to keep the formatting?  I can't get the SQL...

/****************************************************************************************
Generate employee data
****************************************************************************************/

INSERT INTO...

My suggestion would be to use Macros to get your data into a normalized format and then attempt to import.

Since you are using page breaks, do you really need an official header?  You can create something that looks like a header before each page break... either in your table,...

Once upon a time, I had a similar issue.  My solution was to transform several field formats because SSIS seems to have some kind of 255 character limit similar to...

Thanks.

I've gone through 6 different reports that I need to add sorting to.   2 out of the 6 did not apply the Group sorting right away.  I added the interactive. ...

Okay.  Thanks for pointing me in that direction.   Stats mgmt was right after fragmentation on my "to-learn" list. 

The file is being saved as Read-Only.  It's related to issues I'm now finding posted all over the internet:  saving files across a file share. 

Barring an explanation I can follow...

Which should I use for deciding what indexes need reorg/rebuild? 

Some sites suggest that Detailed is more accurate, but other sites...

I have read the documentation.  But I don't understand it.  I am a "involuntary DBA".   And I have a hard time following most Microsoft documentation.  I tend to look for forum...

The restart is just SQL Server.   And it is a one-time thing, only because we are moving tempdb to its own drive (and adding additional data files).   
I'll watch...

I've tracked down all the error messages and they just are not specific enough to tell me why SSIS is having trouble making the connection to the Excel file.  I can't find...