Jeff Moden

Forum Replies Created

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

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
RE: First SQl job were you nervous?

thomashohner (5/9/2014)
Well I finished my Interview with the Director of Programing. He said no further interviews were necessary and that he would be drafting a proposal for employment. 😀 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)

May 10, 2014 at 8:15 pm

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

If you want real performance, I'd recommend that you stop counting altogether. Indexed views have an overhead on inserts in that they have to recalculate the totals 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)

May 10, 2014 at 8:10 pm

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

[font="Arial Black"]WHY[/font] are you returning 600K rows to begin with???:blink: And [font="Arial Black"]WHERE [/font]are you returning them to? :unsure:
--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 10:36 am

#1712397

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