Jeff Moden

Forum Replies Created

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

RE: Choosing the Birthday of a Customer by month?

All the speculation is good... I was hoping the OP would return with the definition of the Customer table so that we can demonstrate the performance of our speculations but...
--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 29, 2017 at 5:49 am

#1969876
RE: Slow query - client or server issue

leehbi - Tuesday, November 28, 2017 7:56 AM
The 2 plans came via sp who - I've ran the query to get 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)

November 28, 2017 at 3:35 pm

#1969818
RE: Table Design

Sean Lange - Tuesday, November 28, 2017 7:22 AM
Jeff Moden - Wednesday, November 22, 2017 3:43 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 28, 2017 at 3:27 pm

#1969816
RE: Table Design

Sue_H - Wednesday, November 22, 2017 5:32 PM
Jeff Moden - Wednesday, November 22, 2017 3:43 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 28, 2017 at 3:22 pm

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

Davismarsel - Tuesday, November 28, 2017 2:06 PM
It's actually an experiment of an app I am creating in java for managing songs...
--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 3:17 pm

#1969814
RE: Slow query - client or server issue

leehbi - Tuesday, November 28, 2017 6:00 AM
Plans attached. I will explore extended events. Good tip about SQL Sentry Plan Explorer.
Those don'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)

November 28, 2017 at 6:30 am

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

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