I don't know, scanning duff code in qotd for the sake of it? You'd probably just as likely find that the output would be ordered.

selectReplace( convert(varchar,

CAST( CAST(a AS VARCHAR(8))...

Good article.

Paul White (9/9/2013)

---

dwain.c - Article body

---

Since we always hear that SQL does not guarantee row ordering without an explicit ORDER BY clause, we assume that the same case is...

shouldve couldve...

call me skeptical but i always thought a pms job was to whip you as hard as they could and grab all the glory...

Jeez, this thread still going. I wonder if one had to search for '%this thread still going%' if this thread would return the highest count...

Good thought, we normally get the ubiquitously descriptive "General Network Error" when that happens.

Ah, I've got it! Search your code for:

WAITFOR DELAY '100:00:00'

:hehe:

A slightly more professional...

In your original post you mention that the step that executes the SSIS package is not initiated from the job, how have you managed to determine this i.e. are you...

I think we'll probably need some more information if we're going to be able to help. Any more information about the job and underlying tasks would help.

LiteSpeed appears to have, um, quirks - just a another avenue to investigate as earlier versions caused jobs to hang when backing up to a network drive if I remember...

From you op, it appears that Litespeed is involved in the process. Have you checked the Litespeed vendor documentation or contacted them?

No pun intended, right Barry? 😉

Erlands' study reminds me of constructing sql statments in VBA before ADO based on user parameters and the ever increasing...

RBarryYoung (5/27/2009)

---

Max (5/27/2009)

---

...

GilaMonster (5/27/2009)

---

Yes it was and yes it it. However, it would make not the slightest bit of difference.

In 2005, no matter now much you recompile a 'catch-all'...

Yeah, something about midnight-black, shiny and...

see above for sore losers 😛

been there to - them questions be scurvy, argh

the be question real should: "it why ivarchar isn't?" like I[/b]nternational

Edit: Chad you make me want...

TheSQLGuru (5/27/2009)

---

Topical and timely words to the wise from Bart Duncan (someone who REALLY knows what is going on with SQL Server) and isn't just a pretender like myself! ...

Greetings all

A couple of thoughts:

1.

Gianluca Sartori (5/20/2009)

---

Now I'm sure that SQLServer uses shortcircuit OR. Try this:

DECLARE @tmpTab TABLE (

column1 int,

column2 int

)

declare @param1 int

declare @result int

set @param1 =...