Ninja's_RGR'us (11/16/2011)

---

GSquared (11/16/2011)

---

Roy Ernest (11/16/2011)

---

Ninja's_RGR'us (11/16/2011)

---

L' Eomot Inversé (11/16/2011)

---

But it was Remi who said it, and in the thread, and the combination of those two factors seems to me to...

If you can't get it another way, run a trace and run the task. Get the SQL out of the trace.

But you should be able to open up the...

Brandie Tarvin (11/16/2011)

---

Dev (11/16/2011)

---

This is cross-question. This is what I suggested to Ashu. 😀

But what I...

Roy Ernest (11/16/2011)

---

Ninja's_RGR'us (11/16/2011)

---

L' Eomot Inversé (11/16/2011)

---

But it was Remi who said it, and in the thread, and the combination of those two factors seems to me to require the...

Ninja's_RGR'us (11/14/2011)

---

GSquared (11/14/2011)

---

Tom Brown (11/14/2011)

---

OK I've read and inwardly digested the link. :blush:

Seems like SNAPSHOT Read committed is one way to go. However if I investigate this and...

Ninja's_RGR'us (11/16/2011)

---

Koen Verbeeck (11/15/2011)

---

Ninja's_RGR'us (11/15/2011)

---

Same here.

No offense if I forgot anything else. I didn't reread the whole 2 weeks either...

Steve Jones - SSC Editor (11/15/2011)

---

PhilipC (11/14/2011)

---

What makes you so strongly say not to backup a SQL database across the network out of interest?

I've been doing this for a while...

Steve Jones - SSC Editor (11/14/2011)

---

Bill Stutters (11/14/2011)

---

I think part of the problem with the lack of people going into CS majors is that the industry has done a very...

Ninja's_RGR'us (11/15/2011)

---

Brandie Tarvin (11/15/2011)

---

EDIT: Nevermind. I see you were quoting them for Grant. DOH....

I haven't tried a data file on a network share yet.

On the other hand, data files on a SAN aren't really "local", but I have plenty of databases working that...

JJ B (11/14/2011)

---

I thought this was a great editorial and appreciated the good reminder.

I also think this is a walking advertisement for thoroughly documenting the "why" of code as much...

MisplacedChildhood (11/14/2011)

---

Ian Elliott (11/7/2011)

---

I don't want to go out of my way to offend people but it seems that these days people like to go out of their way to...

I totally understand prioritizing that way.

And I used to deal with financial services data going from mainframe flat-files into relational stores, then into analysis cubes, then back to flat files....

If by "criticism" you mean badmouthing something with statements like...

Greg Charles (11/14/2011)

---

It's too bad nobody referenced BOL for this quote:

"If a SELECT is used in an application or script that has logic dependent on the number of columns...