If you're really creating XML data files larger than 2GB (esepcially if you start getting into multiples of 2GB), then your long-term solution is - don't use T-SQL to do...

Steve Jones - SSC Editor (8/9/2011)

---

It is in dependent of location and you bring up good points, majorbloodnock. However using foreign firms v domestic ones can make a difference. Ultimately...

Is it the SQL Server process or the extraction causing the issue? I can't say that I've played with running multiple competing instances of RS or BCP, but being...

Grant Fritchey (8/10/2011)

---

No real way around this. The whole idea of hints to take away control from the optimizer. One of the many reasons I'm not in favor of using...

Jason - were you able to get SSRS and SSAS running on Home Premium? I haven't yet upgraded to 7, but I had to run Vista Business and/or Ultimate...

GSquared (8/5/2011)

---

Your cynicism towards my intelligence, integrity, and judgement is duly noted.

I do live in the US. I haven't had the particular problems you are detailing here. Your...

GSquared (8/5/2011)

---

Nevyn (8/5/2011)

---

GSquared (8/5/2011)

---

Freddie-304292 (8/5/2011)

---

I really don't see what this argument has to do with freedom. The government builds your roads, your railways, maintains your public parks. It provides many...

cengland0 (8/4/2011)

---

That depends on many factors.

Are you in a group or individual plan?

What do you want...

Leo.Miller (8/2/2011)

---

Jeff Moden (8/2/2011)

---

Leo.Miller (8/1/2011)

---

I can't see any real benefit of using an iTVF, since as far as I can see, [font="Arial Black"]you can still only pass it a single...

JimS-Indy (8/2/2011)

---

Interesting... "change the definition..." Do you suggest I do that in the view definition on SS2k5, or the connection string in Access (not really practical, since every user has...

If everyone is using the view as the basis for their work (be it a report or an Access "table"), change the definition of the view, and everyone points at...

This may be a bit late to the party, but - the easiest way to reload a table is to front it with a view. This way you can...

You can still schedule outages and practice for the unexpected. Depending on how critical the uptime is - perhaps you want to practice offsite.

I worked for a Life Insurance...

As long as you're using bound columns within your update and not...

Steve Jones - SSC Editor (7/29/2011)

---

There's nothing to replace Word's review features anywhere. Need a PC for that, or a Mac/Fusions.

I am tempted to get a real keyboard for writing...