Jeff Moden

Forum Replies Created

Viewing 15 posts - 12,541 through 12,555 (of 59,102 total)

RE: Transferring data between tables

richardmgreen1 - Thursday, April 19, 2018 8:20 AM
ZZartin - Thursday, April 19, 2018 8: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)

April 19, 2018 at 8:46 am

#1987538
RE: SQL Server 2016 Enterprise - Free space recommendation

dajonx - Thursday, April 19, 2018 7:41 AM
Thank you.
I wasn't sure if the NTFS performance degrading when there's less than 15% free...
--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, 2018 at 8:42 am

#1987537
RE: Log File running out of space

itmasterw 60042 - Thursday, April 19, 2018 6:06 AM
Hi,
Recently I changed our database recovery model from Simple to Full. However, now 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)

April 19, 2018 at 8:28 am

#1987535
RE: Transferring data between tables

richardmgreen1 - Wednesday, April 18, 2018 6:32 AM
The tables are, for the most part, identical.
I know it seems too obvious but I...
--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, 2018 at 8:09 am

#1987527
RE: Are the posted questions getting worse?

Lynn Pettis - Wednesday, April 18, 2018 2:19 PM
Lynn Pettis - Tuesday, April 17, 2018 10:26 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, 2018 at 7:26 am

#1987510
RE: Default trace - high read activity on disk

Paul Cresham - Thursday, April 19, 2018 5:38 AM
We are running Idera's SQL Diagnostic Manager and we also have some Red Gate...
--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, 2018 at 7:23 am

#1987509
RE: Default trace - high read activity on disk

Paul Cresham - Wednesday, April 18, 2018 2:01 PM
I've noticed on one of our servers running SQL Server 2014 Enterprise in Resource...
--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, 2018 at 7:18 pm

#1987438
RE: Join on field of varying length

daniness - Wednesday, April 18, 2018 1:59 PM
Hi Scott,
Thanks for your reply. I'm not following your code. In this portion:
--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, 2018 at 7:02 pm

#1987437
RE: Are the posted questions getting worse?

Jason A. Long - Monday, April 16, 2018 10:00 AM
Jeff Moden - Monday, April 16, 2018 8:58...
--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 17, 2018 at 8:35 am

#1987159
RE: Removing stored procedures to move to cloud

Eric M Russell - Tuesday, April 17, 2018 7:30 AM
The way I see it, usage of stored procedures actually makes the application...
--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 17, 2018 at 8:09 am

#1987147
RE: Execution plan missing.

mig28mx - Thursday, April 12, 2018 6:40 PM
Hi all.
Recently I have found with the help of one of the Bent Ozar, scritps....
--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 17, 2018 at 7:51 am

#1987140
RE: Desperation on the Forums

Marcia J - Monday, April 16, 2018 9:12 PM
Your post reminded me of something that happened my freshman year in college (many,...
--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 17, 2018 at 7:48 am

#1987139
RE: Removing stored procedures to move to cloud

Shifting gears a bit and to quote Walt Kelly, "We have met the enemy... and he is us". As Steve Jones posted about his son taking computer classes, so we...
--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 17, 2018 at 7:03 am

#1987132
RE: Removing stored procedures to move to cloud

sgmunson - Tuesday, April 17, 2018 6:32 AM
xsevensinzx - Tuesday, April 17, 2018 6: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)

April 17, 2018 at 6:45 am

#1987126
RE: Removing stored procedures to move to cloud

funbi - Tuesday, April 17, 2018 6:00 AM
Hugo Kornelis - Tuesday, April 3, 2018 1:50 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 17, 2018 at 6:30 am

#1987122

Viewing 15 posts - 12,541 through 12,555 (of 59,102 total)