Jeff Moden

Forum Replies Created

Viewing 15 posts - 30,376 through 30,390 (of 59,101 total)

RE: Teach myself SSIS

opc.three (4/11/2012)
dwain.c (4/10/2012)
Gotta bookmark this thread. SSIS is next on my SQL learning expedition!
Awesome! Two outspoken anti-RBAR-advocates in one thread threatening to learn SSIS, I might fall over :hehe:
EDIT:...
--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)

April 11, 2012 at 2:41 pm

#1472233
RE: Are the posted questions getting worse?

Lynn Pettis (4/11/2012)
Brandie Tarvin (4/11/2012)
GilaMonster (4/11/2012)
Yes, they are. http://www.sqlservercentral.com/Forums/Topic1281318-203-1.aspx
Wow. Did I catch that right? The OP posted in an Article discussion because we weren't answering the questions elsewhere?
And now he...
--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)

April 11, 2012 at 12:00 pm

#1472095
RE: Create script to split databases into 5 groups based on database size

pamozer (4/11/2012)
This looks great. Thank you so much. So you are basically everytime you go around checking the accumulator table for the group that has the smallest size...
--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)

April 11, 2012 at 10:11 am

#1472007
RE: Create script to split databases into 5 groups based on database size

BTW, here's the group count by MB Size when I run your code for 5 partitions.
GroupID(No column name)
144921
245546
346272
445626
574991
--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)

April 10, 2012 at 8:57 pm

#1471650
RE: Create script to split databases into 5 groups based on database size

I think you'll find that the following balances "the load" quite nicely. You can easily change the number of database groups (starting at "0", by the way) just 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)

April 10, 2012 at 8:13 pm

#1471642
RE: Data and Log Space Alerts

simonrichards74 (4/10/2012)
Jeff Moden (4/10/2012)
simonrichards74 (4/10/2012)
Hey, hope I am not stepping on anyone's toes here.
I have been looking into setting this up, so documented my steps and submitted an...
--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)

April 10, 2012 at 7:03 pm

#1471638
RE: Recursive CTE for Item supersession question

It makes real sense. Thanks for taking the time to explain all of 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)

April 10, 2012 at 6:26 pm

#1471636
RE: Are the posted questions getting worse?

SQLRNNR (4/6/2012)
Recently had a client using cloud managed backup tools to perform SQL Backup. They lost a LUN and needed to restore. Cloud tools took 24 hours restoring...
--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)

April 10, 2012 at 5:44 pm

#1471622
RE: Teach myself SSIS

Heh... "It Depends!"
--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)

April 10, 2012 at 5:28 pm

#1471620
RE: Teach myself SSIS

opc.three (4/10/2012)
Jeff Moden (4/10/2012)
Heh... crud. Two decent links to how to learn it. That probably means that I'm going to have to spend some time learning about 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)

April 10, 2012 at 4:54 pm

#1471610
RE: Optimizing Query

slpgma (4/10/2012)
Yes you are correct. The definition of being rehired is that the first and last names are equal. If there are two rows where the names equal and...
--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)

April 10, 2012 at 4:37 pm

#1471603
RE: How to get the sequence

Cadavre (4/10/2012)
Matt Miller (#4) (4/10/2012)
Note: while cadavre's code will generate a sequence number within the query run, it's not a deterministic sequence number. As a result, rows might...
--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)

April 10, 2012 at 4:25 pm

#1471598
RE: Recursive CTE for Item supersession question

Thanks for the feedback, Shannon. Heh... yeah... the "devil's in the data" on this type of stuff.
As a sidebar, this was a really interesting problem. Dwain (and, apparently,...
--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)

April 10, 2012 at 4:19 pm

#1471596
RE: Data and Log Space Alerts

simonrichards74 (4/10/2012)
Hey, hope I am not stepping on anyone's toes here.
I have been looking into setting this up, so documented my steps and submitted an article.
It is 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)

April 10, 2012 at 4:04 pm

#1471583
RE: Teach myself SSIS

Heh... crud. Two decent links to how to learn it. That probably means that I'm going to have to spend some time learning about 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)

April 10, 2012 at 4:02 pm

#1471581

Viewing 15 posts - 30,376 through 30,390 (of 59,101 total)