Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,136 through 15,150 (of 59,097 total)

RE: Today's Random Word!

Revenant - Wednesday, April 19, 2017 2:58 PM
ManicStar - Wednesday, April 19, 2017 2:25 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)

April 19, 2017 at 4:27 pm

#1938991
RE: tempdb curiosity

TheSQLGuru - Wednesday, April 19, 2017 8:59 AM
Jeff Moden - Wednesday, April 19, 2017 8:38 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)

April 19, 2017 at 4:09 pm

#1938984
RE: Deadlocks on Clustered Index

Eric M Russell - Wednesday, April 19, 2017 2:16 PM
DesNorton - Wednesday, April 19, 2017 1:45...
--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)

April 19, 2017 at 3:32 pm

#1938975
RE: SQL help - Need to know the first date of previous month and last date of previous month...

mw112009 - Wednesday, April 19, 2017 10:06 AM
Did I pass the test then ?
"It Depends" on the next time you need to...
--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)

April 19, 2017 at 2:35 pm

#1938964
RE: tempdb curiosity

fizzleme - Tuesday, April 18, 2017 4:34 PM
I maintain a sql server 2012 server with 4 tempdb files. The first one is...
--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)

April 19, 2017 at 8:38 am

#1938837
RE: Table size and indexes

Eric M Russell - Wednesday, April 19, 2017 7:02 AM
SQLRNNR - Tuesday, April 18, 2017 1:36 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)

April 19, 2017 at 7:49 am

#1938816
RE: SQL help - Need to know the first date of previous month and last date of previous month...

mw112009 - Wednesday, April 19, 2017 7:10 AM
Phil Parkin - Wednesday, April 19, 2017 6:55 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)

April 19, 2017 at 7:40 am

#1938810
RE: Are the posted questions getting worse?

SQLRNNR - Tuesday, April 18, 2017 1:29 PM
jasona.work - Tuesday, April 18, 2017 1:18 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)

April 18, 2017 at 9:01 pm

#1938712
RE: SQL help - Need to know the first date of previous month and last date of previous month...

SQLRNNR - Tuesday, April 18, 2017 1:14 PM
This thread has gone quite a ways sideway, imo.
Let's try to get this thing turned...
--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)

April 18, 2017 at 8:31 pm

#1938709
RE: Window Function defaults

TomThomson - Tuesday, April 18, 2017 5:29 PM
Jeff Moden - Monday, April 17, 2017 3:37 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)

April 18, 2017 at 8:12 pm

#1938707
RE: SQL Server Telemetry

Eric M Russell - Tuesday, April 18, 2017 7:57 AM
When Microsoft says that they're collecting data just for quality of service purposes...
--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)

April 18, 2017 at 8:06 am

#1938525
RE: Are the posted questions getting worse?

Luis Cazares - Tuesday, April 18, 2017 7:40 AM
Thom A - Tuesday, April 18, 2017 7: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)

April 18, 2017 at 8:03 am

#1938523
RE: SQL help - Need to know the first date of previous month and last date of previous month...

mw112009 - Tuesday, April 18, 2017 6:43 AM
Credit to DesNorton
Jeff: The dates are used as default values in a SSRS report. ...
--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)

April 18, 2017 at 7:44 am

#1938519
RE: SQL Server Telemetry

David.Poole - Tuesday, April 18, 2017 2:39 AM
All these systems are put together with the best and honourable intentions. The problem comes...
--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)

April 18, 2017 at 6:58 am

#1938493
RE: SQL Server Telemetry

Sean Redmond - Tuesday, April 18, 2017 3:01 AM
DPÂ» All these systems are put together with the best and honourable intentions.
Are they?...
--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)

April 18, 2017 at 6:10 am

#1938485

Viewing 15 posts - 15,136 through 15,150 (of 59,097 total)