Sorry, saw this thread earlier but my life is a bit zany at the moment.

Remove the 100 percent part. There's no purpose to it and the old trick of...

Side note: I use max posts per page... and we've hit 500 pages. 🙂

Public is a database role, and as mentioned above, you can just outright remove said user from the database. However, this becomes a problem if you're doing NT group...

allbymyself (3/24/2011)

---

Great points indeed. I mean no disrespect to DBAs. I'm just used to having to wear many hats and am not knowing of all tasks for someone who only...

GSquared (3/24/2011)

---

Nah, check the interviews on http://thehollywoodinterview.blogspot.com/2010/09/paul-verhoeven-starship-troopers.html, and so on. Definitely wasn't done that way. Also, the DNA from the book is in every frame of the movie....

*facepalm* Thanks...

There's no where clauses on any of this, you're mass updating in multiple passes... Yeah, that's gonna hurt.

The nc index really only hurts if you're updating something in the...

I don't have SSIS in front of me, but I'm 99% sure you can load the SQL Statement as an expression. Build out your dynamic query in the expression...

Warning: They melt if you put...

You wouldn't directly. You'd read the row into the stream in a datasource,...

Thanks for the solution...

Well, no cursor declares in this code, I assume this is an excerpt then.

The first has references in code with a short string to...

Jeff Moden (3/22/2011)

---

FredS-1001785 (3/21/2011)

---

The original problem I was trying to solve was that I wanted to make sure that I was dropping temporary tables after using them. Hence, searching...

sqldba_icon (3/21/2011)

---

Another update, now when i drop fk/truncate/insert data back/ add fk the good table(table1) also gives bad performance? Why would that be.. In the interim i will tryt o...

First thing that comes to mind is dropping it out to a recordset destination and then using that in a foreach loop (with 1 loop for your one row) in...