Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,191 through 20,205 (of 59,072 total)

RE: need help on Scalar value Function

ScottPletcher (6/25/2015)
sgmunson (6/25/2015)
ScottPletcher (6/25/2015)
GilaMonster (6/25/2015)
Nolock hints, do you know what they do? (hint, they don't make queries faster)
Why does everyone keep repeating that? Of course NOLOCK hints make queries...
--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, 2015 at 7:41 am

#1809122
RE: Building a Tree Structure in an efficient and faster way.

a4apple (6/25/2015)
Hmmm... MLM. If that's true, are you using a "uni-level" payout system?
Yes, absolutely... I saw your article Jeff.. My only question is if one account changes its...
--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, 2015 at 7:37 am

#1809120
RE: Count of consecutive years of participation (islands and gaps)

OLSONEJ (6/30/2015)
Whoops, that is my fault. 4 should have three upon looking at it again. My apologies.
Still, what do you want to do for the scenario in my...
--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, 2015 at 7:31 am

#1809116
RE: Using a Recursive CTE to Generate a List

ChrisM@Work (6/30/2015)
Paul White (6/28/2015)
...All this frequently confuses DBAs and developers who are used to tuning performance based solely on logical reads (not a school of thought I subscribe to by...
--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, 2015 at 7:30 am

#1809115
RE: Are the posted questions getting worse?

Congratulations, Alan and family!
--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 29, 2015 at 10:18 pm

#1808967
RE: The New DBA

xsevensinzx (6/28/2015)
I'm only 2 years into my role as more or less the accidental DBA to most. However, that is not my title on paper. I am just a developer...
--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 29, 2015 at 9:10 pm

#1808962
RE: The New DBA

I wasn't going to post on this thread because the term DBA has become so diluted by idiocy and incompetence that the term "DBA" has almost become an insulting term...
--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 29, 2015 at 8:29 pm

#1808961
RE: how to allocate the File sizes (Disk Partition Alignment for tempdb)

Database admin(DBA) (6/29/2015)
I have question about tempdb needs to be configured 100GB 64kb block size.its fresh installation.
how to allocatte the file sizes.still im not sure how many log files needs...
--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 29, 2015 at 7:17 pm

#1808957
RE: Count of consecutive years of participation (islands and gaps)

Despite the good code that has shown up on this thread and to add to the questions that Sean and Maggo have asked, I'm not sure that the definition of...
--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 29, 2015 at 7:08 pm

#1808955
RE: Using a Recursive CTE to Generate a List

Thanks for dropping by, Paul.
While I absolutely agree that (especially with a RBAR-like rCTE that counts) single rows are processed through the Table Spool in this case, a logical read...
--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 28, 2015 at 11:53 pm

#1808666
RE: How to deploy a encrypted procedure on the client machine.

Still, it's a handy idea even if it is 6 years later.
--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 28, 2015 at 8:13 pm

#1808657
RE: Using a Recursive CTE to Generate a List

Jeff Moden (6/28/2015)
Ok. I've decided to get to the bottom of this once and for all. I've posted the following on the MVP email site. We'll see...
--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 28, 2015 at 12:55 pm

#1808648
RE: Using a Recursive CTE to Generate a List

Ok. I've decided to get to the bottom of this once and for all. I've posted the following on the MVP email site. We'll see what happens...
According...
--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 28, 2015 at 12:11 pm

#1808644
RE: Using a Recursive CTE to Generate a List

Even with that fine hypothesis, it's not conclusive proof that the table spool is being read one row at a time for each row or one page at a time...
--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 28, 2015 at 11:14 am

#1808641
RE: Using a Recursive CTE to Generate a List

I'm still working on it. Everything I come up with has had a hole in 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)

June 27, 2015 at 10:28 pm

#1808617

Viewing 15 posts - 20,191 through 20,205 (of 59,072 total)