David Burrows (5/26/2009)

---

SQL Server takes the numeric value up to the first Alpha character as a numeric value (SELECT 1.) and the alpha characters that follow are then the alias...

josephptran2002 (5/24/2009)

---

Hi Ike,

How are you doing? I am greatly appreciated your helps, I already solved the problem by using SSMS or Import/export wizard. You are very nice person, and may...

You really have to be kidding, right?

I guess some people just don't get it, do they?

Time to wonder off back to the desert...

Well, it is what the rest of the world calls football or futbol. Sorry, but us Americans call it...

Would not matter, if she isn't happy, no one...

That's good. Forum etiquette, however, says that if you ask for help that you...

Jeffrey Williams (5/22/2009)

---

Lynn Pettis (5/22/2009)

---

I know this one too well. My middle daughter has her permit now, and there are times I wonder if she even knows what she's...

Jeffrey Williams (5/22/2009)

---

Right now, taking my daughter out for driving lessons is some of the best time off I can imagine. It can also be some of the most...

Okay, don't get upset here, but what do you think is the difference between appending and overwriting?

ason (5/22/2009)

---

This is a query sample. If I do not use user function, query run 3-4 mins since diffirence between enddade and begdate not greater then 7 days. If I...

john.arnott (5/22/2009)

---

Jan Van der Eecken (5/22/2009)

---

Lynn Pettis (5/22/2009)

---

Plus, position and angles plays a role. People in the stands may see something that an AR or Referee can't simply because...

You may want to look at raising the cost threshold for parallelism Option. The default is 5, perhaps up it to 10, and see what happens to your query...

Ed Klein (5/22/2009)

---

Lynn - yes the parallel plan is listed as having a lower cost, however it doesn't.

Gail said to run the query in grid mode so...

Jan Van der Eecken (5/22/2009)

---

Lynn Pettis (5/22/2009)

---

Plus, position and angles plays a role. People in the stands may see something that an AR or Referee can't simply because of...

Gail,

Tell me if I am reading this right. Does the query plan say that the parallel query "should" be more efficient (cost less)? I'm not sure what the...