Ninja's_RGR'us (7/26/2011)

---

You can['t] use truncate on a table with FK on it. So you'd have to use delete + reseed on all tables. That would get annoying realy...

Truncate the target tables, working from the bottom up in your...

TravisDBA (7/25/2011)

---

It does when you have to communicate with others, and strong dialects affect...

bitbucket-25253 (7/25/2011)

---

So to forestall any complaints on another QOD I submitted, it includes creating a schema, a table, code inserting the data, and the settings for auto create stats, update...

Jeff Moden (7/25/2011)

---

mtillman-921105 (7/25/2011)

---

Too many of these posters don't realize the level of expertise that they are getting here. Maybe you all need more intimidating titles like "Grand Intergalactic...

Childhood advertisements

Ninja's_RGR'us (7/19/2011)

---

Craig Farrell (7/19/2011)

---

So, the questions: Yes, you can apply MAXDOP to any DML statement.

I disagree with the above. Don't adjust maxdop serverwide, adjust the cost to initiate it...

So, the questions: Yes, you can apply MAXDOP to any DML statement.

I disagree with the above. Don't adjust maxdop serverwide, adjust the cost to initiate it (5 is way...

dma-669038 (7/19/2011)

---

I have no arguments with whether or not it works for you. Perfectly legitimate if it does. I just don't agree with above points in all employment situations. Where...

dma-669038 (7/19/2011)

---

Craig Farrell (7/19/2011)

---

cengland0 (7/19/2011)

---

joe in the falls (7/19/2011)

---

Until I'm invested in a company and care if it succeeds, you get what you paid for. One full day's...

cengland0 (7/19/2011)

---

joe in the falls (7/19/2011)

---

BTW, 6-7 jobs in 8 years, is nothing to brag about! If I saw his resume, it would go in the trash can! Shows me...

Double posting. Please direct all conversation here:

http://www.sqlservercentral.com/Forums/Topic1143769-2789-1.aspx

OP, please don't do that. It dilutes the assistance you may receive. I realize you're up a creek in trouble but...

huy1002 (7/18/2011)

---

today i have a disk failure on my SQL Server 2000. even though i have built the drive, but i cannot get the server to start still.

I get an...

Yes, using xp_cmdshell and dtexec.exe. the /set option will allow you to set a package variable, which can...

LutzM (7/18/2011)

---

Craig Farrell (7/18/2011)

---

Without seeing your sample data, I had to make some assumptions. Don't where clause AFTER you initiate the ROW_NUMBER(). That's what's removing the rows on...