Jeff Moden

Forum Replies Created

Viewing 15 posts - 13,651 through 13,665 (of 59,095 total)

RE: List All Jobs and Their Schedules

camaro305hp - Monday, November 20, 2017 5:02 PM
Jeff Moden - Monday, November 20, 2017 4:23 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)

November 20, 2017 at 6:52 pm

#1968923
RE: monitor when files get to 80%

myukas - Monday, November 20, 2017 4:24 PM
is there an easy way to monitor and alert when mdf ndf and ldf reach...
--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, 2017 at 4:58 pm

#1968917
RE: Holiday parties: Do you love them or hate them?

I attend the company Christmas Party for four reasons:
1. The "meeting" beforehand is where they lay out what happened in the previous year and what's coming up for 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)

November 20, 2017 at 4:31 pm

#1968915
RE: List All Jobs and Their Schedules

camaro305hp - Monday, November 20, 2017 3:57 PM
rwest 44523 - Wednesday, July 19, 2017 8:04 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)

November 20, 2017 at 4:23 pm

#1968913
RE: Log file R drive- What is consuming it

@coolchaitu ,
I see you've flagged two posts as the answer, so I'm curious... What did you actually come up with? What...
--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, 2017 at 4:00 pm

#1968909
RE: Trigger table read?

jayg359 - Monday, November 20, 2017 10:40 AM
Jeff Moden - Tuesday, November 14, 2017 7:01 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)

November 20, 2017 at 3:56 pm

#1968906
RE: Creating a PDF from a Stored Procedure

Eric M Russell - Monday, November 20, 2017 12:30 PM
This would actually be a good interview question. If the candidate laughs or...
--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, 2017 at 3:53 pm

#1968905
RE: Why dbid is 1 for master, 2 for tempdb, 3 for model and 4 for msdb?

patrickmcginnis59 10839 - Monday, November 20, 2017 3:26 PM
Jeff Moden - Sunday, November 19, 2017 12:20 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)

November 20, 2017 at 3:41 pm

#1968903
RE: Help with aggregate function

ger_serrano - Monday, November 20, 2017 9:11 AM
That is excellent guys. Both queries work as expected. I have modified the query 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 20, 2017 at 10:13 am

#1968816
RE: Why dbid is 1 for master, 2 for tempdb, 3 for model and 4 for msdb?

GilaMonster - Monday, November 20, 2017 4:33 AM
Jeff Moden - Sunday, November 19, 2017 9:42 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)

November 20, 2017 at 10:10 am

#1968815
RE: Amount of RAM in server

tfeuz - Sunday, November 19, 2017 6:25 PM
tfeuz - Sunday, November 19, 2017 6:24 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)

November 19, 2017 at 7:07 pm

#1968712
RE: Not able to get any links to find ebbok for sql 2016 MCSA certification

Thom A - Sunday, November 19, 2017 5:13 AM
sej2008 - Sunday, November 19, 2017 2:58 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)

November 19, 2017 at 6:40 pm

#1968711
RE: mapping an Excel Spreadsheet to a Table

etl2016 - Sunday, November 19, 2017 3:31 PM
Hi
I have a client who will send me an Excel spreadsheet and I have...
--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 19, 2017 at 6:31 pm

#1968710
RE: Amount of RAM in server

tfeuz - Sunday, November 19, 2017 6:13 PM
Jeff Moden - Sunday, November 19, 2017 5:56 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)

November 19, 2017 at 6:21 pm

#1968707
RE: Why dbid is 1 for master, 2 for tempdb, 3 for model and 4 for msdb?

SQL-DBA-01 - Sunday, November 19, 2017 5:05 PM
Jeff Moden - Sunday, November 19, 2017 4:44 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)

November 19, 2017 at 6:02 pm

#1968705

Viewing 15 posts - 13,651 through 13,665 (of 59,095 total)