Jeff Moden

Forum Replies Created

Viewing 15 posts - 23,671 through 23,685 (of 59,102 total)

RE: Just Enough know-how

BWFC (5/12/2014)
Jeff Moden (5/12/2014)
I've started a real pushback on all of this. It's amazing how many of the candidates (something like 22 out of 24) can't answer the first...
--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)

May 12, 2014 at 12:01 pm

#1712811
RE: Just Enough know-how

I've started a real pushback on all of this. It's amazing how many of the candidates (something like 22 out of 24) can't answer the first question, which is...
--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)

May 12, 2014 at 7:59 am

#1712682
RE: partitioning a large dimension?

If the rows eventually become static, there are some huge pitfalls with individual FileGroups having mounds of wasted space.... and individual FileGroups by month is definitely the way to go...
--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)

May 12, 2014 at 7:50 am

#1712677
RE: created a index rebuild job want to understand what happens when it runs

You're correct. But I've never seen it do that in TempDB even with the Sort_In_TempDB option turned on. It seems to always do it in whatever the source...
--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)

May 12, 2014 at 7:45 am

#1712675
RE: created a index rebuild job want to understand what happens when it runs

ScottPletcher (5/9/2014)
Jeff Moden (5/7/2014)
On the SORT IN TEMPDB thing... It'll only affect TEMPDB by 10 or 20% of what the largest index is.
I don't understand the rationale for 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)

May 12, 2014 at 5:41 am

#1712620
RE: Is a SQL View the fastest way to manage multiple count fields, or does SQL 2014 have something better ?

isuckatsql (5/11/2014)
It seems the jury is still out on the best way to do this.
http://stackoverflow.com/questions/7160411/is-it-better-to-maintain-a-seperate-count-table-vs-running-count-query-every-tim
http://stackoverflow.com/questions/3498646/select-count-vs-keep-a-counter
While I appreciate the concern of the 2 fellows whose posts you cited, I'll suggest...
--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)

May 11, 2014 at 9:27 pm

#1712524
RE: First SQl job were you nervous?

thomashohner (5/11/2014)
Thank you Sir! I am very excited. I know Report writing isn't the most exciting of the Sql professions but I like it. For a new guy like me...
--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)

May 11, 2014 at 8:12 pm

#1712520
RE: Hanging WHILE loop

tombiagioni1983 (5/11/2014)
If there is a better method of implementation, please share it with me.
There's is indeed. See Luis' code, which he previously posted. Remember that CROSS APPLY is...
--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)

May 11, 2014 at 8:03 pm

#1712517
RE: Which would be faster, an SSIS Foreach or SQL Cursor for 6300 rows?

sqlservercentral.com 32358 (5/11/2014)
I had chosen this over set based because there's a set of processes that need followed depending on the values in each row.
Stop thinking like 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)

May 11, 2014 at 8:01 pm

#1712516
RE: Hanging WHILE loop

Luis Cazares (5/11/2014)
Your query looks just like mine but using a while loop instead of a single operation. Why would you do that.
Because and like he said, he's a C#...
--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)

May 11, 2014 at 11:37 am

#1712494
RE: Hanging WHILE loop

tombiagioni1983 (5/7/2014)
Thanks everyone for the quick responses and the helpful attitude! I come from a C# programming background where iterative loops aren't as costly, So i'll definitely be reading 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)

May 11, 2014 at 11:32 am

#1712491
RE: Is a SQL View the fastest way to manage multiple count fields, or does SQL 2014 have something better ?

Heh... :blush: No. It's nothing like that. Actually, it's because I'm a bit lazy. All those recalculated aggregates would mean that I'd have to worry about...
--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)

May 11, 2014 at 9:47 am

#1712480
RE: Just Enough know-how

Having done a couple of dozen interviews for Senior Level Developers and DBAs over the last 2 years or so, I'm totally amazed at how low the bar has been...
--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)

May 10, 2014 at 9:43 pm

#1712434
RE: Calling Local Speakers

Sometimes we forget that... the thing about local speakers, I mean. And it seems that SQL Saturday may have changed quite a bit since Andy originally defined 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)

May 10, 2014 at 9:04 pm

#1712432
RE: Is there any way to improve statistics on a table like this?

In that case, the best you can do is start monitoring and making a plan for the indexes and stats. Check which indexes are used or not and how...
--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)

May 10, 2014 at 8:40 pm

#1712430

Viewing 15 posts - 23,671 through 23,685 (of 59,102 total)