Jeff Moden

Forum Replies Created

Viewing 15 posts - 35,161 through 35,175 (of 59,102 total)

RE: Killed a SPID; Not Completing...

dajonx (2/1/2011)
I have attached the results from sp_who2. The stuck SPID is 99. As you can see, the SPID is being blocked by itself. If there is...
--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 4, 2011 at 3:53 pm

#1282746
RE: Table variable as Output Parameter

Oddly enough, I haven't used MERGE in 2k8, yet. But, I believe you'll still need to make that query dynamic SQL using a variable for the USING table name.
--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 4, 2011 at 7:05 am

#1282435
RE: ssis and ssrs interview questions

parmar.randheer11 (2/3/2011)
Hey,
I don’t want to take others opportunity 🙂 I am not job less :-). I know some answers are not up to marks I am correcting those and definitely...
--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 4, 2011 at 6:58 am

#1282430
RE: Display More Than 8000 Characters (SQL Spackle)

JJ B (2/3/2011)
JJ B. If you're not currently using a loop or the method in the article, what are you using?
I'll tell ya, but you have to be kind (not...
--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 4, 2011 at 6:54 am

#1282427
RE: Formatting Dates with 3 Character Months (SQL Spackle)

UMG Developer (2/3/2011)
Jeff Moden (2/2/2011)
BWAA-HAA!!! Thanks for the great feedback, David. And, just to make sure, I have to tell you that that version of the Tally table...
--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 4, 2011 at 6:47 am

#1282420
RE: Need the Price with the Latest Date

Craig Farrell (2/3/2011)
Hm, you appear to have hit on something here... especially depending on the indexing.
Using this new benchmarking code:
Wow! Lots'o code! What conclusion do you draw from...
--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 4, 2011 at 6:38 am

#1282408
RE: Need the Price with the Latest Date

drew.allen (2/1/2011)
Jeff Moden (2/1/2011)
drew.allen (1/31/2011)
Craig Farrell (1/31/2011)
After having done some other tests, this method seems to be the quickest, especially if you have a solid index on Item/ChangePriceDate
My tests indicate...
--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 4, 2011 at 6:35 am

#1282406
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (2/3/2011)
I have removed the "questionhacker" thread and account. It might not stop him from coming back, but I also sent an email, so we'll see....
--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 4, 2011 at 6:23 am

#1282395
RE: Are the posted questions getting worse?

Lynn Pettis (2/3/2011)
Lynn Pettis (2/2/2011)
Amazing it is how arrogant some may be.
And then to post here as well?
EDIT: For those interested, the links above are broken.
Probably missing rather than broken......
--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 4, 2011 at 6:17 am

#1282394
RE: Display More Than 8000 Characters (SQL Spackle)

timothyawiseman (2/1/2011)
I have run into this problem off and on, and once even wrote a solution to it ( http://www.sqlservercentral.com/scripts/Print/63240/%5B/url%5D ). After struggling with it myself a few times,...
--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 3, 2011 at 7:07 am

#1281891
RE: Display More Than 8000 Characters (SQL Spackle)

Roy Ernest (1/31/2011)
Hi Jeff, Great article as usual. 🙂
Hi Roy! Thanks for the read and the comment. Always a pleasure.
--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 3, 2011 at 6:59 am

#1281887
RE: ForEach Loop and an ADO Recordset

Thanks for the feedback, Craig. Yep... not that it matters but I agree with that justification. Please understand that, considering the source, I just had to ask. ...
--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 3, 2011 at 6:55 am

#1281885
RE: Are the posted questions getting worse?

GilaMonster (2/3/2011)
Tom Brown (2/3/2011)
[There is a "Report" button I always wondered why then when phrases the like of which this pet troll uses appear directed at our well known...
--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 3, 2011 at 6:37 am

#1281873
RE: Solving the "Running Total" & "Ordinal Rank" Problems (Rewritten)

mmarovic (2/2/2011)
Hello Jeff & Co. Really great article and awesome discussion. I wrote an article about the topic five years ago, but my investigation lacked depth of the Jeff's article...
--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 3, 2011 at 6:32 am

#1281870
RE: UPDATE using a self-join

Brandie Tarvin (2/1/2011)
GSquared (2/1/2011)
Stefan Krzywicki (2/1/2011)
Brandie Tarvin (2/1/2011)
CELKO (1/31/2011)
Successful projects start on lesser SQLs (even ACCESS ) then have to move to DB2, Oracle, Teradata or whatever.
Including Access? What other...
--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 3, 2011 at 12:35 am

#1281744

Viewing 15 posts - 35,161 through 35,175 (of 59,102 total)