Jeff Moden

Forum Replies Created

Viewing 15 posts - 13,576 through 13,590 (of 59,095 total)

RE: Choosing the Birthday of a Customer by month?

@chef423 ,
Would you post the CREATE TABLE statement (with all the indexes) for you're Customer table, please? I'd like to generate...
--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)

November 28, 2017 at 6:25 am

#1969676
RE: Choosing the Birthday of a Customer by month?

Jason A. Long - Monday, November 27, 2017 11:16 PM
Here's a quick test, using just over 3.25 million rows of data in...
--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)

November 28, 2017 at 5:45 am

#1969666
RE: Current Quarter

drew.allen - Monday, November 27, 2017 10:33 AM
craig.jenkins - Monday, November 27, 2017 9:28 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)

November 27, 2017 at 9:05 pm

#1969643
RE: Trigger to notify when mssql job is disabled

myukas - Monday, November 27, 2017 6:32 AM
this trigger thing is just a big pain for this. Is there a way with...
--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)

November 27, 2017 at 8:35 pm

#1969642
RE: Choosing the Birthday of a Customer by month?

ScottPletcher - Friday, November 24, 2017 10:22 AM
Jeff Moden - Friday, November 24, 2017 9:13 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)

November 27, 2017 at 8:24 pm

#1969641
RE: Choosing the Birthday of a Customer by month?

ScottPletcher - Friday, November 24, 2017 8:02 AM
It makes zero sense to pull out just the month and index it. You'd be...
--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)

November 27, 2017 at 8:11 pm

#1969640
RE: Choosing the Birthday of a Customer by month?

chef423 - Wednesday, November 22, 2017 8:51 AM
Jeff Moden - Tuesday, November 21, 2017 8:46 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)

November 27, 2017 at 8:08 pm

#1969639
RE: Are the posted questions getting worse?

Ed Wagner - Monday, November 27, 2017 6:32 AM
Jeff Moden - Monday, November 27, 2017 6:21 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)

November 27, 2017 at 8:03 pm

#1969638
RE: How to search songs_words table for songs that contain a group of words?

Davismarsel - Monday, November 27, 2017 3:43 PM
Hello,
I have an SQL database of of songs with a table that consists of...
--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)

November 27, 2017 at 5:52 pm

#1969637
RE: Shrinking Transaction Log Files

Of course, I agree with all the info about having both a backup and restore plan and taking regular backups to support the RTO (Recovery Time Option) and RPO (Recovery Point...
--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)

November 27, 2017 at 5:35 pm

#1969636
RE: Start Fixing Your DB with Better Code

patrickmcginnis59 10839 - Monday, November 27, 2017 6:29 AM
On the "tower of babel" thing... no... it wasn't stupid. As you say, 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)

November 27, 2017 at 10:35 am

#1969570
RE: Slow query - client or server issue

Grant Fritchey - Wednesday, November 22, 2017 9:12 AM
Jeff Moden - Wednesday, November 22, 2017 7:19 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)

November 27, 2017 at 6:26 am

#1969509
RE: Are the posted questions getting worse?

Ed Wagner - Monday, November 27, 2017 5:22 AM
Lynn Pettis - Saturday, November 25, 2017 12:13 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)

November 27, 2017 at 6:21 am

#1969507
RE: Help with code to Grouping the text in multiple lines

v.razaghzadeh - Sunday, November 26, 2017 7:24 AM
Hello everyone
I am a newcomer to the world of TSQL and was wondering if someone...
--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)

November 26, 2017 at 11:08 am

#1969457
RE: Start Fixing Your DB with Better Code

patrickmcginnis59 10839 - Saturday, November 25, 2017 2:30 PM
Jeff Moden - Saturday, November 25, 2017 11:32 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)

November 26, 2017 at 12:13 am

#1969447

Viewing 15 posts - 13,576 through 13,590 (of 59,095 total)