Jeff Moden

Forum Replies Created

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

RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

The other fly in the ointment is that it's also coming up with the wrong sums.
--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:43 pm

#1970214
RE: Force execution plan in a view

Luis Cazares - Thursday, November 30, 2017 9:32 AM
Sergiy - Thursday, November 30, 2017 2:17 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 8:01 pm

#1970211
RE: What is the best ways of storing unstructured data in sql server 2016, except filestream.

TUellner - Thursday, November 16, 2017 9:14 AM
Jeff Moden - Wednesday, November 15, 2017 9:07 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 7:41 pm

#1970210
RE: We Need DevOps for Performance

David.Poole - Thursday, November 30, 2017 7:56 AM
Jeff Moden - Thursday, November 30, 2017 7: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 30, 2017 at 6:31 pm

#1970207
RE: Add Column to Staging table

Deletes are pretty expensive and they're fully logged even in the SIMPLE recovery model. Why not just use the generated "dupe number" (row number) to process only the data you...
--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 5:55 pm

#1970205
RE: The Difference Between Rollup and Cube

gfabbri - Thursday, November 30, 2017 12:21 AM
very interesting. The point is the order of fields in the GROUP BY ROLLUP, that...
--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 5:41 pm

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

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