Jeff Moden

Forum Replies Created

Viewing 15 posts - 13,561 through 13,575 (of 59,095 total)

RE: Why dbid is 1 for master, 2 for tempdb, 3 for model and 4 for msdb?

Perry Whittle - Thursday, November 30, 2017 10:29 AM
Jeff Moden - Wednesday, November 29, 2017 9:26 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 30, 2017 at 10:46 am

#1970105
RE: We Need DevOps for Performance

David.Poole - Tuesday, November 28, 2017 10:35 AM
I don't think DB platforms have kept up with the needs of a DevOps culture...
--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 30, 2017 at 7:21 am

#1970032
RE: We Need DevOps for Performance

From the article:
The same thing should be done for our relational systems. The Ops part of DevOps needs to 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 30, 2017 at 7:05 am

#1970029
RE: Logon Trigger suddenly caused spike in query time

NC1 - Wednesday, November 29, 2017 8:29 AM
Jeff, I spoke with one of my developers and he said they do indeed have...
--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 8:59 pm

#1969988
RE: Why dbid is 1 for master, 2 for tempdb, 3 for model and 4 for msdb?

Perry Whittle - Wednesday, November 29, 2017 9:03 AM
master starts first, id is 1
tempdb is usually just before model, especially evident...
--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 9:26 am

#1969936
RE: Logon Trigger suddenly caused spike in query time

Eirikur Eiriksson - Wednesday, November 29, 2017 8:17 AM
Jeff Moden - Wednesday, November 29, 2017 8:02 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 29, 2017 at 8:25 am

#1969925
RE: Logon Trigger suddenly caused spike in query time

Eirikur Eiriksson - Wednesday, November 29, 2017 7:05 AM
Jeff Moden - Wednesday, November 29, 2017 6:48 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 29, 2017 at 8:02 am

#1969918
RE: Logon Trigger suddenly caused spike in query time

By any chance, do the connection strings have MARS enabled?
--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 6:48 am

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

Jeff Moden - Tuesday, November 28, 2017 3:17 PM
Davismarsel - Tuesday, November 28, 2017 2:06 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 29, 2017 at 6:13 am

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

Viewing 15 posts - 13,561 through 13,575 (of 59,095 total)