Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,816 through 10,830 (of 59,095 total)

RE: increment months for two dates combination as a new label column

David Burrows - Thursday, October 25, 2018 2:02 AM
Jeff Moden - Wednesday, October 24, 2018 6:34 PM
--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 25, 2018 at 7:54 am

#2011138
RE: Move old DBs to new existing servers.

Shifting gears a bit to the actual migration... I saved on a huge amount of down time during such a migration by restoring the full backups from the night before...
--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 25, 2018 at 7:41 am

#2011132
RE: NOT IN vs NOT EXISTS

Thom A - Thursday, October 25, 2018 4:59 AM
Perhaps my initial post mislead people, but the query in my initial post wasn't...
--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 25, 2018 at 7:35 am

#2011129
RE: Prevent accidental DB drop\delete

frederico_fonseca - Wednesday, October 24, 2018 5:15 PM
Jeff Moden - Wednesday, October 24, 2018 4:58 PM
--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 24, 2018 at 8:17 pm

#2011057
RE: Index space

WhiteLotus - Wednesday, October 24, 2018 6:11 PM
Thanks for the response
Sorry total record should be 1.5 Billion so (15 times...
--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 24, 2018 at 8:09 pm

#2011056
RE: Move old DBs to new existing servers.

Admintering Databases - Wednesday, October 24, 2018 12:48 PM
I have bunch of DBs I am trying to migrate from old DB serves...
--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 24, 2018 at 6:51 pm

#2011054
RE: increment months for two dates combination as a new label column

ScottPletcher - Wednesday, October 24, 2018 5:06 PM
Lynn Pettis - Wednesday, October 24, 2018 3:27 PM
--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 24, 2018 at 6:34 pm

#2011053
RE: Naming Conventions for SQL Server Objects

Jonathan AC Roberts - Wednesday, October 24, 2018 4:23 PM
Jeff Moden - Wednesday, October 24, 2018 4:01...
--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 24, 2018 at 6:26 pm

#2011052
RE: Split comma delimited field?

Jonathan AC Roberts - Wednesday, October 24, 2018 3:51 PM
Lynn Pettis - Wednesday, October 24, 2018 3:23...
--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 24, 2018 at 6:07 pm

#2011049
RE: NOT IN vs NOT EXISTS

Ask the ring knocker if he likes pork chops and then feed him your results.
Lordy, I hate such "experts". As always, one good test is worth 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 24, 2018 at 6:04 pm

#2011048
RE: How to do a basic loop in SQL

jcelko212 32090 - Wednesday, October 24, 2018 2:15 PM
barry.nielson - Tuesday, October 23, 2018 3:55 PM
--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 24, 2018 at 5:20 pm

#2011044
RE: Prevent accidental DB drop\delete

Sue_H - Wednesday, October 24, 2018 11:52 AM
Subhash Chandra - Wednesday, October 24, 2018 9:46 AM
--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 24, 2018 at 4:58 pm

#2011040
RE: Naming Conventions for SQL Server Objects

Jeffrey Williams 3188 - Wednesday, October 24, 2018 1:08 PM
xsevensinzx - Wednesday, October 24, 2018 4:27 AM
--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 24, 2018 at 4:01 pm

#2011031
RE: Are the posted questions getting worse?

Brandie Tarvin - Wednesday, October 24, 2018 11:24 AM
WHEE!
Just got a text from my mom, who is watching the munchkin.
Guess who...
--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 24, 2018 at 11:30 am

#2010978
RE: Coming from Oracle - How Do I Do This Date Conversion in SQLServer?

Lynn's method will not provide leading zeros for times < 10, which you seem to indicate is required in your original post. The following formula will.
--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 24, 2018 at 9:39 am

#2010966

Viewing 15 posts - 10,816 through 10,830 (of 59,095 total)