Jeff Moden

Forum Replies Created

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

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
RE: Compute & Rollup

kd11 - Sunday, August 26, 2018 12:07 PM
This statement will produce: Select EmpID, Yr, sum(Sales)as Sales from Sales Group by EmpId, Yr 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 26, 2018 at 6:56 pm

#2003378
RE: Convert Varchar field

TomThomson - Sunday, August 26, 2018 4:37 PM
It's very rarely that I disagree with you Jeff, but I think PL/1 was...
--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:53 pm

#2003377
RE: Rebuilding Indexes

TomThomson - Sunday, August 26, 2018 2:18 PM
There's a nasty tendency for developers who write in brain-dead languages like C++ and...
--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 3:22 pm

#2003370
RE: Copy all files from folder

girl_bj - Sunday, August 26, 2018 8:24 AM
How can I copy all files from folder.
G:\MainFolder\Folder\
Inside this Folder has txt files. I want...
--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:06 am

#2003357

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