Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,386 through 11,400 (of 59,099 total)

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
RE: Does SQL compression process takes additional temporary disk space?, 1.2 TB database to compress

Pablo Campanini-336244 - Monday, August 27, 2018 9:37 AM
Compressing 1.2 TB database. Do I need temporary disk space for compression?.
My largest 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 27, 2018 at 9:43 am

#2003458
RE: Limiting the Ability to Concentrate and Collaborate

roger.plowman - Monday, August 27, 2018 8:55 AM
Gotta agree with Jeff.
Open office plans SUCK.
I've worked with tall walls, small walls, offices...
--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 9:34 am

#2003455
RE: Limiting the Ability to Concentrate and Collaborate

Steve Jones - SSC Editor - Monday, August 27, 2018 8:40 AM
FWIW, everyone, including the boss, at Redgate works in an...
--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 9:31 am

#2003454
RE: 'Comedy Limited' with SQL Server

robert.sterbal 56890 - Monday, August 27, 2018 8:26 AM
getting tabular data into a text format is a really really important tool for...
--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 9:31 am

#2003453
RE: 'Comedy Limited' with SQL Server

Mpumelelo - Monday, August 27, 2018 3:45 AM
I spent much of my career just working with the data in the database. 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)

August 27, 2018 at 8:20 am

#2003437
RE: Limiting the Ability to Concentrate and Collaborate

Victor Kirkpatrick - Monday, August 27, 2018 5:38 AM
This is one of those things that's completely different for different people and depends...
--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 8:06 am

#2003435
RE: Limiting the Ability to Concentrate and Collaborate

My opinion is both brief and blunt... open office spaces suck.
They're too noisy, have too many distractions, promote water cooler discussions, and at one company, did nothing at...
--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 26, 2018 at 11:30 pm

#2003388
RE: Are the posted questions getting worse?

TomThomson - Sunday, August 26, 2018 11:58 AM
I reckon Glayva would be better than Drambuie. (After all, "Very good" is surely...
--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 26, 2018 at 8:33 pm

#2003383
RE: 'Comedy Limited' with SQL Server

rafael.zimberoff - Sunday, August 26, 2018 11:06 AM
CSV... how about even supporting MS's own Excel standard? In SSMS, why can't I Save...
--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 26, 2018 at 7:12 pm

#2003381
RE: Insert new records from one database to another using SSIS

RatanDeep Saha - Wednesday, August 22, 2018 5:09 PM
Jeff Moden - Wednesday, August 22, 2018 4:57 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 26, 2018 at 7:06 pm

#2003380
RE: Count the Number of Weekend Days between Two Dates

ScottPletcher - Friday, August 24, 2018 8:23 AM
[For the record, this code works correctly under any/all DATEFIRST settings.]
So does the function 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)

August 26, 2018 at 6:58 pm

#2003379

Viewing 15 posts - 11,386 through 11,400 (of 59,099 total)