Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,371 through 11,385 (of 59,095 total)

RE: Are the posted questions getting worse?

Sean Lange - Tuesday, August 28, 2018 1:42 PM
haha my mother in law still uses AOL....not even kidding. They haven't used...
--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)

August 28, 2018 at 2:30 pm

#2003724
RE: Are the posted questions getting worse?

Ed Wagner - Tuesday, August 28, 2018 10:51 AM
TomThomson - Tuesday, August 28, 2018 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)

August 28, 2018 at 2:29 pm

#2003723
RE: index scan where seek expected

ScottPletcher - Tuesday, August 28, 2018 11:54 AM
Jeff Moden - Tuesday, August 28, 2018 11:43 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)

August 28, 2018 at 12:15 pm

#2003687
RE: I need some help with Text data type in SQL Server table.

rkordonsky 63916 - Tuesday, August 28, 2018 11:02 AM
drew.allen - Tuesday, August 28, 2018 10:34 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)

August 28, 2018 at 11:54 am

#2003682
RE: index scan where seek expected

ScottPletcher - Tuesday, August 28, 2018 9:29 AM
If you (almost) always query by COLA or ( COLA, COLB ), then cluster the table...
--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)

August 28, 2018 at 11:43 am

#2003678
RE: index scan where seek expected

While I agree that rebuilding an index will typically not help code and that having proper stats usually will, there is one time where rebuilding an index actually does help.
--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)

August 28, 2018 at 7:41 am

#2003589
RE: Index Usage Statistics report

as1981 - Friday, August 24, 2018 7:07 AM
All,
I've just looked at this report for the first time so I may be missing...
--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)

August 27, 2018 at 7:27 pm

#2003541
RE: Is it recommended to update statistics automatically?

Shifting gears a bit... I've seen lot's of people recommend updating stats based on how long it's been since the stats have been updated. I don't understand that recommendation because...
--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)

August 27, 2018 at 7:07 pm

#2003539
RE: Stored Procedure with mode flag

Jonathan AC Roberts - Monday, August 27, 2018 7:07 AM
Sergiy - Monday, August 27, 2018 7:00 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)

August 27, 2018 at 6:59 pm

#2003538
RE: Best way to prep LOGINS, JOBS, Replication, Proxies for a recovery scenario

Express12 - Monday, August 27, 2018 12:52 PM
Is there a tool out there that will help prep for a RECOVERY scenario (outside...
--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)

August 27, 2018 at 6:56 pm

#2003537
RE: 'Comedy Limited' with SQL Server

jyoung 18482 - Monday, August 27, 2018 5:24 PM
1) All I can say is "use the right tool for the job"...
--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)

August 27, 2018 at 6:45 pm

#2003536
RE: 'Comedy Limited' with SQL Server

jyoung 18482 - Monday, August 27, 2018 3:25 PM
rafael.zimberoff - Monday, August 27, 2018 2:52 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)

August 27, 2018 at 4:10 pm

#2003528
RE: 'Comedy Limited' with SQL Server

robert.sterbal 56890 - Monday, August 27, 2018 12:16 PM
The best delimiter in my experience is the one that isn't in any...
--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)

August 27, 2018 at 1:35 pm

#2003518
RE: Compute & Rollup

drew.allen - Monday, August 27, 2018 9:43 AM
kd11 - Sunday, August 26, 2018 12:07 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)

August 27, 2018 at 12:12 pm

#2003501
RE: 'Comedy Limited' with SQL Server

robert.sterbal 56890 - Monday, August 27, 2018 11:11 AM
Jeff Moden - Monday, August 27, 2018 9:31 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)

August 27, 2018 at 12:09 pm

#2003498

Viewing 15 posts - 11,371 through 11,385 (of 59,095 total)