Radovan Jablonovsky (2/8/2008)

---

Hi,

If it is possible in your production environment to dynamically change number of processors, then it is OK. In our environment it is more conservative, therefore I am...

I absolutely agree, Matt... same thing goes with the SUM() OVER... they (MS) don't allow the necessary ORDER BY to calculate a running total using SUM() OVER like they do...

Which error? The one about conversion from char to date producing an out of range value? And, even if you fix that, you'll still end up with a...

VARCHAR(MAX)

Philippe Cand (2/6/2008)

---

Hello,

This article is getting unprecedented proportions.

How could we have MS SQL engine development database guys participating in the discussion If they are not yet already doing so...

Amazing... I've...

Thanks, Adam :blush:

Just a couple of suggestions, folks...

First, there is no need for a loop in the creation of a "Tally" or "Numbers" table. Second, to be truly effective and to...

Yes... the solution is posted above... the server must be logged into the domain as a user that can actually "see" the file path.

First, mailing you the solution wouldn't do anyone else any good...

Second, take a look at BCP in Books Online... it's likely your best bet.

Import 1 line and count the LEN difference between the line with delimiters and the line where the delimiters have been replaced with nothing and add 1 to that.

For fixed...

Chirag (2/6/2008)

---

Hi Jeff

I have a doubt abt the index selection when i ran your code

in the article ' Running total.......'

I created the table dbo.JBMTest , added the clustered...

Matt Miller (2/5/2008)

---

Jeff Moden (2/5/2008)

---

It IS a cool solution... Wasn't so good in the performance department on my machine, though... it took 29 minutes to do the million row example...

Perfect... another "convert" to denounce the evils of RBAR 😛

Thanks, for the feedback, Whitt. Real glad we could collectively make such a difference for you.

Tony McGarry (2/6/2008)

---

I prefer this simple and elequent way to generate numbers.

I doesn't generate unnecessary numbers and is easy to understand

[font="Courier New"]CREATE FUNCTION dbo.GetSequence

(

@Start BIGINT,

...