Jeff Moden

Forum Replies Created

Viewing 15 posts - 14,641 through 14,655 (of 59,097 total)

RE: Looking Back

TomThomson - Friday, August 4, 2017 5:57 PM
Jeff Moden - Friday, August 4, 2017 3:09 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 4, 2017 at 7:27 pm

#1954211
RE: Looking Back

bdcoder - Thursday, August 3, 2017 9:14 AM
Jeff Moden - Thursday, August 3, 2017 9:03 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 4, 2017 at 3:09 pm

#1954203
RE: Looking Back

bdcoder - Thursday, August 3, 2017 7:45 AM
TomThomson - Thursday, August 3, 2017 7:08 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 3, 2017 at 9:03 am

#1953989
RE: Help me hate PowerShell a little less, please.

Thanks, Thom. Santa said he's going to give me a new brain this Christmas. I've asked him if he could push that up a bit because, apparently, mine isn't working...
--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 2, 2017 at 10:13 pm

#1953886
RE: Cursor Performance

I've worked for companies that bought software where you were unable to do your own patches because of the so called "support" contracts. If you touch it, you break the...
--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 2, 2017 at 9:54 pm

#1953885
RE: Changing type from INT to BIGINT why so slow?

leehbi - Tuesday, August 1, 2017 3:28 AM
Thanks folks. Interesting food for thought. Solved the issue with an intermediate table. Thankfully,...
--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 2, 2017 at 9:22 pm

#1953883
RE: how to deploy 10 T-SQL scripts across 200 databases

Again, I agree that CMS is fine for administering multiple servers but this problem (according to the original post) has nothing to do with multiple servers. It has to do with...
--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 2, 2017 at 8:08 pm

#1953881
RE: how to deploy 10 T-SQL scripts across 200 databases

Luis Cazares - Wednesday, August 2, 2017 10:17 AM
Jeff Moden - Wednesday, August 2, 2017 8:42 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 2, 2017 at 5:57 pm

#1953871
RE: Help me hate PowerShell a little less, please.

David Burrows - Wednesday, August 2, 2017 9:06 AM
On my 2016 server it was not installed by default.
I had to install Active...
--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 2, 2017 at 9:16 am

#1953791
RE: Help me hate PowerShell a little less, please.

Thom A - Wednesday, August 2, 2017 8:43 AM
Jeff Moden - Wednesday, August 2, 2017 8: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 2, 2017 at 9:14 am

#1953790
RE: Cursor Performance

Ed Wagner - Monday, July 31, 2017 5:49 PM
whenriksen - Monday, July 31, 2017 3:45 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 2, 2017 at 9:05 am

#1953788
RE: how to deploy 10 T-SQL scripts across 200 databases

premkumardr - Tuesday, August 1, 2017 5:26 PM
sqlguy80 - Tuesday, July 25, 2017 12: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)

August 2, 2017 at 8:42 am

#1953785
RE: Help me hate PowerShell a little less, please.

Jeff Moden - Wednesday, August 2, 2017 8:31 AM
Thom A - Wednesday, August 2, 2017 2:19 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 2, 2017 at 8:38 am

#1953784
RE: Help me hate PowerShell a little less, please.

Thom A - Wednesday, August 2, 2017 2:19 AM
ActiveDirectory is NOT part of of the standard install of PowerShell, 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)

August 2, 2017 at 8:31 am

#1953781
RE: High level performance report aimed at senior management

lassell - Friday, July 21, 2017 3:47 PM
Hi all,
I've been in the SQL space for a number of years now and recently...
--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 1, 2017 at 1:56 pm

#1953664

Viewing 15 posts - 14,641 through 14,655 (of 59,097 total)