Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,211 through 15,225 (of 59,101 total)

RE: How do you define employee satisfaction?

dietztm - Monday, April 10, 2017 2:04 PM
IowaDave - Monday, April 10, 2017 1:53 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 10, 2017 at 6:41 pm

#1937527
RE: EXCEL HELL!!!

h540663 - Monday, June 22, 2015 3:08 AM
Jeff Moden (6/19/2015)Heh... I agree. Compared to the ACE driver, the Jet driver 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)

April 10, 2017 at 5:46 pm

#1937524
RE: Alternating Cursors?

bmg002 - Monday, April 10, 2017 4:26 PM
As an alternate to using a cursor for each DB, could you use:
EXEC sp_Msforeachdb 'INSERT...
--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 10, 2017 at 5:30 pm

#1937523
RE: Improving performance using partitioning

Grant Fritchey - Monday, April 10, 2017 8:00 AM
Partitioning of data is meant to be a management tool, not a query performance...
--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 10, 2017 at 8:49 am

#1937453
RE: Query to backup the databases on a SQL instance using a config table

ffarouqi - Monday, April 10, 2017 8:03 AM
Jeff: Again circling back to the same question. I clearly stated that I 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 10, 2017 at 8:32 am

#1937449
RE: Adding More Power

TomThomson - Sunday, April 9, 2017 12:06 PM
Jeff Moden - Tuesday, April 4, 2017 11:00 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 10, 2017 at 8:17 am

#1937444
RE: Help in finding actual days and hours difference!!!

Ed Wagner - Sunday, April 9, 2017 7:12 AM
One more thing to consider is that the varchar allows invalid data in...
--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 10, 2017 at 8:04 am

#1937438
RE: Query to backup the databases on a SQL instance using a config table

ffarouqi - Sunday, April 9, 2017 11:10 PM
Jeff Moden - Sunday, April 9, 2017 11:02 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 10, 2017 at 7:53 am

#1937432
RE: Archiving or Moving Data

TheSQLGuru - Sunday, April 9, 2017 1:22 PM
I actually like the multiple database notion for such scenarios. With a good naming scheme...
--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 10, 2017 at 7:47 am

#1937431
RE: Running Total

DesNorton - Sunday, April 9, 2017 11:57 PM
Jeff Moden - Friday, April 7, 2017 11:48 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 10, 2017 at 7:43 am

#1937428
RE: Are the posted questions getting worse?

TomThomson - Sunday, April 9, 2017 11:49 AM
Sean Lange - Tuesday, April 4, 2017 10:50 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 10, 2017 at 7:35 am

#1937426
RE: By Design

Heh... I rank the term "By Design" and, especially, the term "Operates as Designed" right up there with other "lameties" (to coin a phrase and is similar to the 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)

April 9, 2017 at 11:25 am

#1937351
RE: Query to backup the databases on a SQL instance using a config table

ffarouqi - Saturday, April 8, 2017 11:41 PM
Hi Folks,
I am looking for a script that would help me take the backup of...
--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 9, 2017 at 11:02 am

#1937349
RE: Query to backup the databases on a SQL instance using a config table

Igor Micev - Sunday, April 9, 2017 5:41 AM
Why don't you want to go with ola's scripts? Maybe you should read more...
--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 9, 2017 at 10:27 am

#1937348
RE: Archiving or Moving Data

I did the same thing with a similar table, which contains the binary for a WAV file for recorded calls. It currently contains 91 months (we have to keep everything...
--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 9, 2017 at 10:24 am

#1937347

Viewing 15 posts - 15,211 through 15,225 (of 59,101 total)