Jeff Moden

Forum Replies Created

Viewing 15 posts - 12,271 through 12,285 (of 59,095 total)

RE: simple select * from table takes around 15 secons

Lynn Pettis - Monday, May 21, 2018 12:58 PM
csltech - Monday, May 21, 2018 11: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)

May 22, 2018 at 5:37 am

#1991388
RE: A Great Case for Powershell

HighPlainsDBA - Monday, May 21, 2018 1:00 PM
Jeff Moden - Monday, May 21, 2018 11:01 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)

May 22, 2018 at 5:32 am

#1991386
RE: Index Fragmentation showing up blank

deep_trance_ - Monday, May 21, 2018 6:26 PM
Jeff Moden - Friday, May 18, 2018 1:34 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)

May 22, 2018 at 4:40 am

#1991383
RE: SQL Server on Linux, does it have Microsoft's full attention?

As good as it is, I'm just hoping that the start supporting the Windows Version the way it needs to be supported.
--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)

May 21, 2018 at 2:32 pm

#1991349
RE: Storing multiple variations of the same data?

aaron.reese - Monday, May 21, 2018 9:46 AM
This is really a question of semantics, if it is necessary to have a properly...
--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)

May 21, 2018 at 12:32 pm

#1991326
RE: The SQL Saturday Thread

Ray K - Monday, May 21, 2018 11:44 AM
Steve Jones - SSC Editor - Monday, May 21,...
--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)

May 21, 2018 at 12:25 pm

#1991323
RE: The SQL Saturday Thread

Lynn Pettis - Monday, May 21, 2018 10:29 AM
Jeff, if you are at Denver I will be sure to be there...
--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)

May 21, 2018 at 12:22 pm

#1991321
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor - Monday, May 21, 2018 11:13 AM
Jeff Moden - Monday, May 21,...
--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)

May 21, 2018 at 12:20 pm

#1991319
RE: A Great Case for Powershell

HighPlainsDBA - Monday, May 21, 2018 9:45 AM
It's worth learning IMO, I automatically restore and DBCC CHECKDB our production backups each night...
--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)

May 21, 2018 at 11:01 am

#1991303
RE: So when will it happen?

Chris Lambrou (Redgate) - Monday, February 6, 2017 8:47 AM
Hi Jeff,
I spent last Friday and most of the weekend looking into this,...
--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)

May 21, 2018 at 10:37 am

#1991297
RE: Are the posted questions getting worse?

Luis Cazares - Monday, May 21, 2018 10:11 AM
A question for all the BBQ aficionados.
First, some background. We're organizing a BBQ contest...
--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)

May 21, 2018 at 10:21 am

#1991291
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor - Monday, May 21, 2018 8:20 AM
Jeff Moden - Friday, May 18,...
--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)

May 21, 2018 at 10:16 am

#1991288
RE: The SQL Saturday Thread

Ray K - Sunday, May 20, 2018 6:37 PM
Jeff Moden - Saturday, May 19, 2018 3:08 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)

May 21, 2018 at 9:59 am

#1991282
RE: The SQL Saturday Thread

Steve Jones - SSC Editor - Monday, May 21, 2018 9:12 AM
Heading the SQL Sat LA in a few weeks.
The only other...
--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)

May 21, 2018 at 9:52 am

#1991276
RE: In what twisted SQL world will a JOIN result in more records than a LEFT JOIN

Heh... Moderators? 😀
I wouldn't delete this thread if I could. It has a lot of good thoughts in it including the thought that sometimes things happen that might...
--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)

May 21, 2018 at 7:45 am

#1991221

Viewing 15 posts - 12,271 through 12,285 (of 59,095 total)