Jeff Moden

Forum Replies Created

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

RE: Need to rename server but name is in lots code - alias?

First, protect yourself for the future because this won't be the last time you run into such a thing. STOP putting 3 and 4 part naming into your code. Instead,...
--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 9:19 am

#1991431
RE: A Great Case for Powershell

Jeff Moden - Monday, May 21, 2018 6:02 AM
call.copse - Monday, May 21, 2018 3:22 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 9:14 am

#1991428
RE: A Great Case for Powershell

Heh... guess I'll have no need for Python, either, then. I do the dynamic pivoting all in T-SQL, as well. 😀
--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 7:30 am

#1991399
RE: Converting N rows to columns, including custom headers

baoshenglishanghai - Monday, May 21, 2018 12:44 AM
Hello,
I have been stuck on this for a long time now, I hope that someone...
--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:46 am

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

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