Jeff Moden

Forum Replies Created

Viewing 15 posts - 16,696 through 16,710 (of 59,101 total)

RE: Are the posted questions getting worse?

Eirikur Eiriksson (10/9/2016)
Who deleted the thread on stuffing overlapping intervals?
😎
Looks like the automatic spam hider had a ball there. I can still see it but it is marked as...
--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 10, 2016 at 9:40 am

#1905693
RE: Are the posted questions getting worse?

Eirikur Eiriksson (10/8/2016)
Ouch ...biting the tongue....
😎
We all know the reason for the given answer... she simply doesn't know any better method even after she's been shown how to avoid loops...
--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, 2016 at 2:48 pm

#1905537
RE: t-sql 2012 cursor

wendy elizabeth (10/8/2016)
I used this loop since I was trying to determine how to solve my problem.
Understood and appreciated. The question now, though, is... do you understand how 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, 2016 at 2:36 pm

#1905536
RE: Bingle is my Senior DBA

kenambrose (10/8/2016)
Answer the newbie/basic questions with links? then all you need is a standard suite of links you can reuse over and over again. And the poster will...
--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, 2016 at 2:20 pm

#1905535
RE: Bingle is my Senior DBA

pdanes (10/8/2016)
I don't know about for the net in general, but for this forum, maybe Steve could institute some sort of marking for people that know what they are talking...
--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, 2016 at 1:32 pm

#1905531
RE: 70-463 Exam v. Training Kit

manub22 (4/17/2015)
My apologizes @jeff and other users.
I thought to reply on some related threads, but didn't realized that I was doing this too much.
Sorry for spamming.
Nah... my bad and I'm...
--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, 2016 at 12:49 pm

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

Seggerman-675349 (10/8/2016)
on more practical matters - several critical stored procedures for my client, the largest employer in our county - rely on the quirky method to load daily 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)

October 8, 2016 at 12:39 pm

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

Lynn Pettis (10/7/2016)
Hugo Kornelis (10/7/2016)
Jeff Moden (10/7/2016)
Hugo Kornelis (10/7/2016)
You could wrap the fast but unreliable method ...
Heh... maybe for you but it's never been unreliable for me. You must...
--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 7, 2016 at 4:16 pm

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

Hugo Kornelis (10/7/2016)
Jeff Moden (10/7/2016)
Hugo Kornelis (10/7/2016)
You could wrap the fast but unreliable method ...
Heh... maybe for you but it's never been unreliable for me. You must be doing...
--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 7, 2016 at 4:14 pm

#1905482
RE: Select all child nodes

Outstanding. Thanks for the tutorial, Alan. I might learn XML yet. 😉
--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 7, 2016 at 3:57 pm

#1905478
RE: How to flatten rows when in unknown for a PIVOT

Great. Thanks for the feedback, Jeff. I really appreciate it.
--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 7, 2016 at 3:55 pm

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

Hugo Kornelis (10/7/2016)
You could wrap the fast but unreliable method ...
Heh... maybe for you but it's never been unreliable for me. You must be doing something wrong. 😉
--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 7, 2016 at 10:41 am

#1905424
RE: Re-porption SQL Data files

coreyjbaum (9/28/2016)
I have a single data file thats over 5tb in size and id like to split it up into multiple files across multiple drives. Whats the best way 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)

October 7, 2016 at 7:43 am

#1905371
RE: Introducing the Set-based Loop

Oh my... with a title like that, I'm not sure how I missed the original publication of this article, Luis. Thanks for taking the time to write it....
--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 7, 2016 at 7:16 am

#1905365
RE: Very bad performance on a good HP DL380 Gen9 Server

lensmithjr (10/6/2016)
Hi Kevin,
Thanks for the ideas. I am going to try some of these out when I get the server back on-line. I have also created a second data RAID...
--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 6, 2016 at 10:51 pm

#1905315

Viewing 15 posts - 16,696 through 16,710 (of 59,101 total)