Jeff Moden

Forum Replies Created

Viewing 15 posts - 31,591 through 31,605 (of 59,101 total)

RE: If your employer stops paying for your cert

lkokeunda (12/22/2011)
Lastly, with due respect, it sounds like your opinion sounds to be an unemployed person's perspective. I would find an employed person's opinion equally helpful.
Actually, I'm gainly fully...
--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)

December 23, 2011 at 6:00 am

#1425120
RE: If your employer stops paying for your cert

lkokeunda (12/22/2011)
My boss got her boss to pay for my one SQL server cert, but is ignoring my request for financially supporting my further cert endeavor (study materials purchase, 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)

December 22, 2011 at 7:32 pm

#1425006
RE: An Efficient Set-based Solution for Islands and Gaps

I took a look at the link you posted. It's good code and it definitely solves your problem. Not sure why I missed the basis of your original...
--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)

December 22, 2011 at 7:14 pm

#1425003
RE: An Efficient Set-based Solution for Islands and Gaps

My appologies... you're problem IS the same problem as solving for sequence islands. Let me see what I can do.
--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)

December 22, 2011 at 6:24 pm

#1425002
RE: An Efficient Set-based Solution for Islands and Gaps

jordonpilling (12/22/2011)
Why do you ask anyway? are there some shortfalls i am not aware off?
Possibly but I don't know for sure. I'd have to see your related queries 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)

December 22, 2011 at 6:18 pm

#1425001
RE: An Efficient Set-based Solution for Islands and Gaps

jordonpilling (12/21/2011)
EDIT: Answered on StackOverflow: http://stackoverflow.com/questions/8592764/crosstabbing-rows-based-on-sequence-islands-in-a-list-of-times
Hi Jeff
Loving your solution, but i'm struggling to apply it to a scenario where the ID is a compund of multiple columns.
Let me explain 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)

December 22, 2011 at 5:42 pm

#1424998
RE: Random Slowness in Insert statment

Ninja's_RGR'us (12/22/2011)
Jeff Moden (12/21/2011)
Aspet Golestanian Namagerdi (12/21/2011)
Actually I stopped the Log shipping Backup job and also I disable the replication jobs but still every 10 minutes,slowness happens on SQL...
--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)

December 22, 2011 at 5:23 pm

#1424995
RE: People That Get It Done

TravisDBA (12/22/2011)
Stephanie J Brown (12/16/2011)I have to disagree; I've not noticed union workers to be any more likely to "sluff off" than exempt workers, supervisors, or managers.
Baloney!!!!!! What you...
--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)

December 22, 2011 at 5:07 pm

#1424992
RE: Creating a sum column without losing records

Thanks for the great feedback, Todd. 🙂
--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)

December 22, 2011 at 9:33 am

#1424856
RE: Merge Join and Implementing type 2 need Suggestions

Dev (12/22/2011)
Duplicate Post.
http://www.sqlservercentral.com/Forums/Topic1225529-392-1.aspx
Normally when you take on the responsibility of identifying a duplicate post, you also take on the responsibility of a little traffic control. This...
--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)

December 22, 2011 at 6:27 am

#1424765
RE: First name And last Name in SQL

Yeah... that's why "LastName" had a degree indication in 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)

December 22, 2011 at 12:26 am

#1424599
RE: Does a SQL backup write tot he transaction log file?

wchaster (12/20/2011)
Microsoft SQL Server 2008 (SP2) - 10.0.4000.0 (X64) Sep 16 2010 19:43:16 Copyright (c) 1988-2008 Microsoft Corporation Standard Edition (64-bit) on Windows NT 5.2 <X64>...
--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)

December 21, 2011 at 11:56 pm

#1424596
RE: HTML using XML PATH

parth83.rawal (12/21/2011)
Hey It just Worked for me!!
Thanks a ton.....
small query how can i mark this as answer..!!! 😉
Can you post the code you finally ended up with, please?...
--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)

December 21, 2011 at 11:52 pm

#1424595
RE: Defining local procedure

David Moutray (12/21/2011)
Now that you mention it, I do remember reading about temporary stored procedures. I wondered at the time (and I am wondering now) what possible use anyone...
--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)

December 21, 2011 at 11:48 pm

#1424594
RE: Merge Join and Implementing type 2 need Suggestions

The easiest way that I've found to do this is to write an INSERT Trigger for the process.
--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)

December 21, 2011 at 11:41 pm

#1424592

Viewing 15 posts - 31,591 through 31,605 (of 59,101 total)