Jeff Moden

Forum Replies Created

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

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

hegdesuchi - Monday, October 22, 2018 1:22 PM
I have to calculate a new Label column for each combination of Start Date 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)

October 25, 2018 at 9:29 am

#2011174
RE: Naming Conventions for SQL Server Objects

drew.allen - Thursday, October 25, 2018 8:31 AM
Jeff Moden - Thursday, October 25, 2018 8:01 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 25, 2018 at 8:42 am

#2011157
RE: How to build an app with GUI that works with SQL Server?

andycadley - Thursday, October 25, 2018 12:33 AM
Having worked in a university previously, I can tell you that a lot of GUI...
--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 8:33 am

#2011154
RE: Naming Conventions for SQL Server Objects

David Burrows - Thursday, October 25, 2018 1:53 AM
Jeff Moden - Wednesday, October 24, 2018 4:01 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 8:01 am

#2011141
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

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