Jeff Moden

Forum Replies Created

Viewing 15 posts - 25,396 through 25,410 (of 59,099 total)

RE: Cursor fetch loops endlessly

LutzM (11/17/2013)
Wait a minute, Jeff!
You suggest to "simply" add a FROM clause to the update statement? (The alias isn't mandatory, is it?)
Interesting, what kind of "previous experience" you can...
--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 17, 2013 at 5:32 pm

#1666989
RE: Are the posted questions getting worse?

Grant Fritchey (11/15/2013)
RBarryYoung (11/15/2013)
SQLRNNR (11/15/2013)
Barry, where have you been?
Mostly just working. I answer questions over at StackOverflow sometimes, but that's about it.
StackOverflow? Traitor!
Ha!
Good to see around, even if only...
--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 17, 2013 at 4:28 pm

#1666983
RE: Are the posted questions getting worse?

WayneS (11/16/2013)
My opinion - accept all interviews, even those that you know you don't want. The one thing people don't get enough practice in is interviewing...
+1000 to that. 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)

November 17, 2013 at 4:27 pm

#1666982
RE: Cursor fetch loops endlessly

Based on a "gut" feeling and previous experience with "run away updates", try replacing the UPDATE statement in your code with the following and let us know what happens.
UPDATE...
--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 17, 2013 at 3:59 pm

#1666977
RE: Select Statement Sum Question

scotsditch (11/16/2013)
Please let me know if you have any other advice on how I can improve my posts.
I'd strongly recommend you try to run your code before you post it....
--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 16, 2013 at 5:07 pm

#1666909
RE: Guidance

Heh... Grant's article really strikes a note for me but not the way that most people would think.
I'm truly amazed at how much time people spend looking at the different...
--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 16, 2013 at 10:27 am

#1666896
RE: Crystal Formula to T-SQL

You have to use CASE instead of IF and you have to use CAST or CONVERT instead of CSTR (if it means "convert to string"). You also have 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 16, 2013 at 9:08 am

#1666893
RE: query logic question...

roy.tollison (11/15/2013)
OK I can use the UNPIVOT to get me the information of the mf_# that contains a matching value.
select pkey, mf_value, mf_field from table1
unpivot
(mf_value for mf_field in (mf_1, mf_2,...
--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 15, 2013 at 9:02 pm

#1666866
RE: Create a date table

arun1_m1 (11/14/2013)
The start_range and end_range would vary based on input. May be I am unable to explain but for now creating a physical table would not solve the problem. Sorry...
--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 15, 2013 at 6:40 pm

#1666861
RE: Script to Delete Reports Older than a Certain Number of Days

Simbo_mk (11/14/2013)
Any suggestions???
Yes... use the DOS command I posted instead. 😛
--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 15, 2013 at 12:32 pm

#1666810
RE: Jr DBA Team interview advice

jlgkatda (11/14/2013)
Goodmorning,
I have an interview tomorrow with about 3 DBAs.
The Manager wants me to come in to meet with them as she wants me to become their Jr. DBA.
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 14, 2013 at 3:00 pm

#1666559
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (11/14/2013)
Greg Edwards-268690 (11/14/2013)
Show me the person who is a master of all things SQL Server.
They are as rare as seeing a unicorn!
No such thing, 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)

November 14, 2013 at 11:14 am

#1666479
RE: Are the posted questions getting worse?

SQLRNNR (11/14/2013)
Greg Edwards-268690 (11/14/2013)
Show me the person who is a master of all things SQL Server.
They are as rare as seeing a unicorn!
SQL Server covers such a broad range 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)

November 14, 2013 at 9:47 am

#1666446
RE: Script to Delete Reports Older than a Certain Number of Days

hisakimatama (11/8/2013)
Hm. I could be wrong on this, but I believe xp_delete_file will only work on SQL Server backup and report files; that is, files ending in .trn, .bak,...
--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 14, 2013 at 9:42 am

#1666441
RE: Query Runs for Long Inspite of Indexes on table

GilaMonster (11/12/2013)
Evaluate how often that table is accessed by the ID column and how often it's accessed by the date column. If it's evaluated by the date far more often,...
--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 13, 2013 at 5:21 pm

#1666244

Viewing 15 posts - 25,396 through 25,410 (of 59,099 total)