Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,451 through 21,465 (of 59,072 total)

RE: Query help. Previous using previous row

johnnycougar (2/25/2015)
/* Can't edit title. Meant to say "Set current row using values in previous row' */
Hello,
I've tried all sorts of code i.e. cross apply, running totals, etc. ...
--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)

February 25, 2015 at 11:48 am

#1780024
RE: Share your best possible answers--

Moin Ul Haque (2/25/2015)
I can quote my own experience here - Out of need, I was asked to develop a database maintenance solution which would monitor several things on our...
--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)

February 25, 2015 at 8:52 am

#1779945
RE: Are the posted questions getting worse?

Thanks folks. Has anyone any particular pleasantries that have occurred from Dev to Stage to Prod with RedGate Compare?
@Lynn...
Are you saying that you had to make some tweaks 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)

February 24, 2015 at 11:52 am

#1779693
RE: Are the posted questions getting worse?

Brandie Tarvin (2/24/2015)
Jeff Moden (2/24/2015)
Just curious... does anyone use RedGate Compare to promote code from Dev to Staging to Prod? Looking for both positive and negative comments on experiences....
--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)

February 24, 2015 at 10:52 am

#1779682
RE: Are the posted questions getting worse?

Just curious... does anyone use RedGate Compare to promote code from Dev to Staging to Prod? Looking for both positive and negative comments on experiences. Thanks folks.
--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)

February 24, 2015 at 10:41 am

#1779677
RE: Trying to insert results from sp_spaceused (tablename) into different table.

Remove the parenthesis and the related single quotes from the EXEC.
--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)

February 23, 2015 at 11:26 pm

#1779486
RE: disk drive is almost full

Sounds like an interview question.
--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)

February 23, 2015 at 11:24 pm

#1779485
RE: Job in Rollback not showing in Activity Monitor

Doe the job use xp_CmdShell or a CmdExec step?
--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)

February 23, 2015 at 11:18 pm

#1779484
RE: Remove the double quote

kennyhuang0108 (2/23/2015)
Thanks Lowell.
I just checked with my boss and the strings can be double quoted.
Thank you very much for your time.
Hope in the future, i wont post...
--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)

February 23, 2015 at 10:28 pm

#1779479
RE: How to get Desired Out Put Like

suresh0534 (2/17/2015)
Hi,
Below is the My Table data...
TypeUser Name region duration1duration2dailsMathSilverGold
ARamesh Section01 ...
--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)

February 23, 2015 at 8:17 pm

#1779471
RE: How to return top n and sum up the rest

Heh... deleted my post. I was having too much fun. 🙂
--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)

February 23, 2015 at 8:09 pm

#1779470
RE: Are the posted questions getting worse?

Lynn Pettis (2/23/2015)
Mark one off, 100 days on the calendar to go. 100 days on the calendar to go, 100 days to go, ...[/i]
Careful, now. Someone might read...
--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)

February 23, 2015 at 7:49 pm

#1779465
RE: sp_Blitz Last good DBCC CHECKDB over 2 weeks old - tempdb

Now that's some good info. Thanks, Ola.
--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)

February 23, 2015 at 7:45 pm

#1779464
RE: Queries and Joining tables

LinksUp (2/23/2015)
Jeff Moden (2/23/2015)
Heh... table names as plural nouns. Makes for some interesting and non-automatable naming conventions.
So, let me ask... do you have an Employee table or an Employees...
--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)

February 23, 2015 at 7:28 pm

#1779460
RE: Queries and Joining tables

spaghettidba (2/23/2015)
Jeff Moden (2/23/2015)
spaghettidba (2/23/2015)
Highly debatable...
The ISO standards suggest that table names are pluralized. I admit that I agree with Celko on this one.
No problem... I don't follow those either....
--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)

February 23, 2015 at 7:08 pm

#1779459

Viewing 15 posts - 21,451 through 21,465 (of 59,072 total)