Jeff Moden

Forum Replies Created

Viewing 15 posts - 16,666 through 16,680 (of 59,067 total)

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
RE: Duplicate rows confusion

Anil Paneru (10/6/2016)
Hello,
I've this table that I pulled from sqlzoo. I loaded this data in my sql server 2016.
name region area...
--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:44 pm

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

Ah... if you want a bit of a bonus column that identifies how many addresses there are for each AddressKey, we just need to add another aggregation.
WITH...
--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:19 pm

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

First, thank you for posting truly readily-consumable test data. You sure made it easy for me to concentrate on the answer.
Here's the code to solve your problem. CROSSTABs...
--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:15 pm

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

To be honest and IMHO, a simple auditing system would serve you and the task of proof much better than doing a linked list. You could even setup a...
--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 9:54 pm

#1905311

Viewing 15 posts - 16,666 through 16,680 (of 59,067 total)