Jeff Moden

Forum Replies Created

Viewing 15 posts - 22,426 through 22,440 (of 59,099 total)

RE: Where are the DBA's!?

schwizla (11/17/2014)
Hi, thanks for your replies. I agree, certified DBA figures will not really paint the accurate picture for the reason you state. But I'm guessing that's the only tangible...
--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)

November 22, 2014 at 12:18 pm

#1760349
RE: What Counts for a DBA: Empathy

Perhaps it's because I've been shot at and missed, s--t at and hit so many times by front-enders and managers with their hair on fire in the face of a...
--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)

November 22, 2014 at 12:14 pm

#1760348
RE: calculating working hours per day for week/month for each employee

tamer.h (11/22/2014)
Jeff Moden (11/21/2014)
tamer.h (11/21/2014)
sometimes many users have two check outs or two checkins, it happens during the day when two users pass together from the gate and they using...
--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)

November 22, 2014 at 1:56 am

#1760319
RE: Are the posted questions getting worse?

Lynn Pettis (11/22/2014)
Jeff Moden (11/22/2014)
David Burrows (11/21/2014)
Well Jeff would have to employ GBAG (Glass By Agonizing Glass) or get an Overflow Exception 😀
Heh... I've reached the "Overflow Exception" a couple...
--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)

November 22, 2014 at 1:44 am

#1760316
RE: What Counts for a DBA: Empathy

From the article:
So, the next time a manager is screaming at you about deadlines, remember that it's probably not because of a lack of empathy or a desire to compromise...
--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)

November 22, 2014 at 1:33 am

#1760314
RE: Are the posted questions getting worse?

David Burrows (11/21/2014)
Well Jeff would have to employ GBAG (Glass By Agonizing Glass) or get an Overflow Exception 😀
Heh... I've reached the "Overflow Exception" a couple of times in my...
--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)

November 22, 2014 at 12:02 am

#1760309
RE: Are the posted questions getting worse?

Ed Wagner (11/21/2014)
Now that is just too funny - a bar called R-Bar. Jeff would have to bring the industrial pork chop launcher and spike the pork chops 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)

November 21, 2014 at 11:51 pm

#1760306
RE: Are the posted questions getting worse?

Sean Lange (11/21/2014)
andrew gothard (11/21/2014)
Bar in my home town.
Can't see it being suitable for a gathering, somehow. Certainly if Jeff Moden's invited,
http://www.tavistockleisure.com/r-bar.htm
LOL here is the mug from a...
--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)

November 21, 2014 at 11:48 pm

#1760305
RE: Are the posted questions getting worse?

andrew gothard (11/21/2014)
Bar in my home town.
Can't see it being suitable for a gathering, somehow. Certainly if Jeff Moden's invited,
http://www.tavistockleisure.com/r-bar.htm
Mmmmm... pretty good menu. Too bad it's on...
--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)

November 21, 2014 at 6:50 pm

#1760300
RE: calculating working hours per day for week/month for each employee

tamer.h (11/21/2014)
sometimes many users have two check outs or two checkins, it happens during the day when two users pass together from the gate and they using one card only.
Such...
--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)

November 21, 2014 at 5:52 pm

#1760299
RE: SQL DBA knowing user passwords

ScottPletcher (11/20/2014)
Jeff Moden (11/20/2014)
ZZartin (11/20/2014)
There's a difference between a service account login used by an application to connect, which a dba should know as the dba is likely the one...
--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)

November 21, 2014 at 9:37 am

#1760210
RE: calculating working hours per day for week/month for each employee

tamer.h (11/20/2014)
Ok, so what do you want to do if the employee works through midnight?
really I don't have any idea, what is your suggestion?
What do you want to...
--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)

November 20, 2014 at 3:36 pm

#1759980
RE: SQL DBA knowing user passwords

ZZartin (11/20/2014)
There's a difference between a service account login used by an application to connect, which a dba should know as the dba is likely the one who will need...
--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)

November 20, 2014 at 3:30 pm

#1759979
RE: SQL DBA knowing user passwords

sqldriver (11/20/2014)
Jeff Moden (11/20/2014)
NJDave (11/20/2014)
Today, a DBA in my group doesn't understand the reasoning and has experiencing storing the passwords for end-users.
Sounds mean but my suggestion is that anyone that...
--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)

November 20, 2014 at 10:09 am

#1759900
RE: calculating working hours per day for week/month for each employee

tamer.h (11/20/2014)
based on (first in/last out) rule, i need to calculate the working hours (difference between first and last timing per day) per each employee.
Ok, so what do you 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)

November 20, 2014 at 10:05 am

#1759899

Viewing 15 posts - 22,426 through 22,440 (of 59,099 total)