Jeff Moden

Forum Replies Created

Viewing 15 posts - 33,406 through 33,420 (of 59,099 total)

RE: "..table "ItemNum" cannot be reorganized because page level locking is disabled"

guna.vaishu (7/1/2011)
The index "xfer_id" (partition 1) on table "mdw_xfer_s2" [font="Arial Black"]cannot be reorganized because page level locking is disabled.[/font]
The error pretty much says it all. In order for 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)

July 2, 2011 at 8:25 am

#1347441
RE: A Little Interviewing Advice

djackson 22568 (7/1/2011)
While it is true that these MAY NOT be opposites, for most managers they are.
I have to disagree with that, as well. I've found that most managers...
--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)

July 1, 2011 at 10:02 pm

#1347394
RE: For And ForEach Loops

The Dixie Flatline (7/1/2011)
Quick war story: Someone once asked me to look at a cursor-based query they wrote to split a single large table into three separate tables....
--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)

July 1, 2011 at 9:27 pm

#1347390
RE: loops

A cursor is nothing more than a rersource intensive loop. Don't use a cursor.
Please post what the other logic is for each PK and we'll try to show you...
--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)

July 1, 2011 at 7:44 am

#1347022
RE: For And ForEach Loops

filipeesch (7/1/2011)
Ares these loops exists in TSQL 2k8 R2 language?
Is there a way to loop thru a query result without using cursor , fetch and while?
In Oracle we can do:
For(...
--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)

July 1, 2011 at 7:37 am

#1347020
RE: Running Total Issue - ANything New On this Aside from Jeff Modens "Quirky Update"?

Craig Farrell (6/30/2011)
Jeff Moden (6/30/2011)
I don't know if it'll make people feel any better about the "Quirky Update" but Tom Thompson and Paul White added a couple of things to...
--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)

July 1, 2011 at 7:26 am

#1347014
RE: Update Query

Brandie Tarvin (7/1/2011)
SQLkiwi (6/30/2011)
Jeff Moden (6/29/2011)
... it's not even spelled correctly.
http://en.wikipedia.org/wiki/Foobar
Thanks, Paul. I was wondering why Jeff was saying that, but I forgot about the real fubar acronym.
You don't even...
--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)

July 1, 2011 at 7:24 am

#1347013
RE: Recursive hierarchy with grouping totals

Thanks... I wanted to take a deeper dive on this particular post and your code will help a lot. 🙂
--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)

July 1, 2011 at 6:51 am

#1346994
RE: Finding the substring where the start position is the nth occurrence of a character?!

SQLkiwi (6/30/2011)
Jeff Moden (6/30/2011)
One more "extension" of the problem you posed.
Did you forget to post the splitting code?
I didn't post the code but, if you look under the code window...
--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)

July 1, 2011 at 6:47 am

#1346993
RE: Recursive hierarchy with grouping totals

rud (7/1/2011)
Thanks, that has worked
Really? Would you post the code you ended up with, please, because I just don't see that particular aggregation doing what you asked. 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)

July 1, 2011 at 4:33 am

#1346933
RE: Finding the substring where the start position is the nth occurrence of a character?!

Tony,
One more "extension" of the problem you posed. It's super easy to break out all of the individual parts of the path and number them. Shamelessly borrowing from...
--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)

June 30, 2011 at 9:12 pm

#1346843
RE: Finding the substring where the start position is the nth occurrence of a character?!

WebTechie38 (6/30/2011)
Wow!!!
I am very impressed and very thankful for your help!!
Thanks.
I had to spend some time working through your example:
1) I had to create the tally table.
2) I...
--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)

June 30, 2011 at 9:00 pm

#1346840
RE: A Little Interviewing Advice

OCTom (6/30/2011)
Teamwork is overrated. I think the skillset and the willingness to learn new skills is more important. I have yet to see an employer value teamwork highly. They speak...
--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)

June 30, 2011 at 8:42 pm

#1346835
RE: Running Total Issue - ANything New On this Aside from Jeff Modens "Quirky Update"?

YSLGuru (6/30/2011)
If one is trying to produce output that includes a running total or running balance and the "quirky Update" method from Jeff Moden is not an option and you're...
--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)

June 30, 2011 at 8:27 pm

#1346832
RE: Running Total Issue - ANything New On this Aside from Jeff Modens "Quirky Update"?

hwells (6/30/2011)
Craig Farrell (6/30/2011)
The Running Totals issue in SQL is that it's really a presentation layer thing, not a SQL thing, which is why it causes such issues.
Craig, would...
--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)

June 30, 2011 at 8:26 pm

#1346831

Viewing 15 posts - 33,406 through 33,420 (of 59,099 total)