Jeff Moden

Forum Replies Created

Viewing 15 posts - 36,436 through 36,450 (of 59,102 total)

RE: Fibonacci Sequence CTE

Mordred (10/9/2010)
Thanks for your response. I agree with that logic but then why are there so many that would say 55 is the tenth I wonder?
Mostly because they start...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

October 9, 2010 at 7:56 pm

#1234657
RE: Solving the "Running Total" & "Ordinal Rank" Problems (Rewritten)

mjswart (9/22/2010)
Hi Jeff,
Records aren't always stored physically ordered on a data page. Most of the time they are physically ordered correctly, but the actual order comes from the slot...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

October 9, 2010 at 6:38 pm

#1234654
RE: Fibonacci Sequence CTE

IIRC, by definition, the first Fibonacci number is refererred to as F₀ = 0 and F₁ = 1 soooooo the TENTH number is actually F₉ = 34.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

October 9, 2010 at 5:54 pm

#1234652
RE: Finding Sequences (Need help ASAP)

{edit} My apologies... I had posted some code here and then think I found a bug later. I took the code down until I can determine if it's...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

October 9, 2010 at 1:21 pm

#1234643
RE: Finding Sequences (Need help ASAP)

[edit] Just an FYI... It would appear that the Zip file still contains the original 13 nulls.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

October 9, 2010 at 9:59 am

#1234629
RE: Finding Sequences (Need help ASAP)

I've been waiting because it seems that the requirements for this problem have been modified several times thoughout this thread. Soooooo.... let's make sure the requirements are actually very...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

October 9, 2010 at 9:36 am

#1234625
RE: similar like Oracle RAC

GilaMonster (10/8/2010)
Jeff Moden (10/8/2010)
Why wouldn't "Federated Servers" in SQL Server do the same thing?
That's when you split a database across multiple servers so that each holds a piece.
RAC has multiple...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

October 8, 2010 at 6:39 am

#1234188
RE: TSQL Help

vilonel (10/8/2010)
Great article Jeff (The "Numbers" or "Tally" Table: What it is and how it replaces a loop.) - have used your example and my query works and the results...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

October 8, 2010 at 6:33 am

#1234187
RE: Convert CSV values in three columns to rows

Very cool, Pavel. Thanks.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

October 8, 2010 at 6:30 am

#1234182
RE: Finding Sequences (Need help ASAP)

craig-404139 (10/7/2010)
WayneS (10/7/2010)
Jeff Moden (10/7/2010)
So... without me running all the code presented so far, what has been decided? Does the numbering restart for each prefix or not?
k from the...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

October 8, 2010 at 6:26 am

#1234180
RE: Locking a row

Gianluca Sartori (10/8/2010)
Jeff Moden (10/7/2010)
Man... well done. Just don't ever put something like this in a transaction... it will cause deadlocks in the "outside" world. Also, make the...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

October 8, 2010 at 3:12 am

#1234084
RE: similar like Oracle RAC

Gianluca Sartori (10/7/2010)
Jeff Moden (10/7/2010)
saurabh.deshpande (10/7/2010)
Can we have anything like Oracle RAC available in SQL Server.
Thanks
What is "Oracle RAC"?
Oracle RAC stands for Real Application Cluster, that...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

October 8, 2010 at 3:04 am

#1234081
RE: Are the posted questions getting worse?

The Dixie Flatline (10/7/2010)
I just had an idea for an epic summer movie. It involves an intrepid group of DBA's and SQL Developers who get sent...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

October 8, 2010 at 2:55 am

#1234077
RE: Are the posted questions getting worse?

Roy Ernest (10/7/2010)
Anybody looking for chairs or recliners?
How do we report spam?
Hit the [Report] button instead of the [Quote] button and leave a quick note "Looks like spam".
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

October 8, 2010 at 2:50 am

#1234074
RE: Are the posted questions getting worse?

WayneS (10/7/2010)
Brandie Tarvin (10/7/2010)
GilaMonster (10/7/2010)
This has got to take some form of prize. http://www.sqlservercentral.com/Forums/FindPost1000227.aspx
Time to get the crystal ball out again.
Apparently it's my turn to feel snippy. I couldn't resist.
IMO,...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

October 8, 2010 at 2:43 am

#1234071

Viewing 15 posts - 36,436 through 36,450 (of 59,102 total)