Steve,

Why not just create a new permanent filegroup with the required number of files in it; and move the data once?  It seems like a lot of work to move...

Now that two years has passed and we now have SQl 2016 and beyond; have they improved the cascading delete problem?

Yeah, you're going to have to test that out. My reply was most assuredly for SSIS 2008 as it was posted 4 years ago.

Google "SQL Server Sparse Vector" to get the full details. The Sparse Vector tracks the storage of sparse columns. In the Sparse Vector (among other things) is two bytes...

So it looks like you're saying I'm still making things too complex.

Rather than have one file group with files on six LUNS; perhaps have multiple file groups;

Perhaps...

Thanks Perry.

So in the case of my six luns; I guess the best thing to do is create one FileGroup with a data files on each LUN (of the same...

anand_vanam (7/10/2010)

---

1. I am running the SSIS package using SQL agent job. (but I want to run many jobs at the same time which calls the same SSIS package, but...

I'm just kidding around.

If I'm not mistaken you gave your presentation barefoot, right?

Before that you were wearing Birkenstocks.

Wow... I'm scared of me. I swear I'm not some kind of...

Thanks Gail.

By the way; I attended your session last week @ SQLPass. I enjoyed it very much.

Do you ever wear shoes? 🙂

Regarding the extra join; it makes sense. Thanks...

Also, anyone implementing filtered indexes might want to check their stored procedures to see if they were written under "set quoted_identifier off". I created filtered indexes and suddenly several...

Thanks, EdVassie. We are planning our server hardware upgrade next fiscal year; so we'll probably do both at the same time. We recently made a mandatory switch to EMC...

On hindsight I guess I could provide a little more information.

I currently manage several SQL Server 2008 instances; and all of them are running on servers with Windows Server...

opc.three (6/17/2011)

---

Looks right. Neat technique.

It won't affect you using it for the problem stated but from the article there is this gotcha: Note that as of SQL Server 2008 the...

No sooner than I typed this I read an article by Adam Machanic that seemed to wrap everything into one...

http://sqlblog.com/blogs/adam_machanic/archive/2009/08/24/dr-output-or-how-i-learned-to-stop-worrying-and-love-the-merge.aspx

Essentially it looks like I can do....

INSERT into History

SELECT...

Did you even read my post, or perhaps did you mean to post to a different thread?

When I looked at the links you provided they were for beginners sql queries....