Jeff Moden

Forum Replies Created

Viewing 15 posts - 34,276 through 34,290 (of 59,099 total)

RE: The Job Posting - Do I really have to be the SQL God?

Grreat article, Craig. If people actually study what you wrote, they'll be able to spot and separate the "dream jobs" from the "jobs for Bob" from the "SQL God"...
--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)

April 14, 2011 at 12:18 am

#1311432
RE: Can't work out how to retrieve data

ranjodh_makkar (4/9/2011)
If you dont want to use double hash global temp table then simply use single hash temp table instead.
Also about function let me write a quick template 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)

April 13, 2011 at 10:50 pm

#1311418
RE: Need to pivot the table.

Deeps123 (4/12/2011)
Hi Guys,
i got it working..............
Just rank the records. and then use Pivot operator in SQL 2005 to move the column values into single row.
Cheeers...........
... until you have more columns...
--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)

April 13, 2011 at 10:21 pm

#1311414
RE: Are the posted questions getting worse?

Kiara (4/13/2011)
CirquedeSQLeil (4/13/2011)
GilaMonster (4/13/2011)
CirquedeSQLeil (4/13/2011)
How many of you would walk out on a job without completing it (as a contractor/consultant) - if you were getting paid?
Never (short of illegal practices...
--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)

April 13, 2011 at 10:13 pm

#1311413
RE: Are the posted questions getting worse?

CirquedeSQLeil (4/13/2011)
GilaMonster (4/13/2011)
CirquedeSQLeil (4/13/2011)
Leave the contract early without notice and prior to completing the stated work.
What does his contract require? Solo or contracting house?
Solo contract and it required him 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)

April 13, 2011 at 10:09 pm

#1311412
RE: Are the posted questions getting worse?

Roy Ernest (4/12/2011)
You all are making me looking foolish because I am laughing when going through a SQL Forum. I am getting some strange looks. 😀
BWAA-HAAA!!!! Is THAT really...
--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)

April 13, 2011 at 9:55 pm

#1311409
RE: Creating Delimited Strings

It looks like the SQLCLRs are getting beat up a bit by straight T-SQL. I believe there may be an optimization on the DISTINCT XML example that we 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)

April 13, 2011 at 8:37 am

#1311061
RE: Basic concat over 500 times slower than straight select?

Ninja's_RGR'us (4/13/2011)
Brandie Tarvin (4/13/2011)
Does the order really matter?
It actually could. If it fails to finish in the allowed time I need to be able to start back where 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)

April 13, 2011 at 8:28 am

#1311056
RE: Basic concat over 500 times slower than straight select?

Ninja's_RGR'us (4/12/2011)
How much data did you test with? I have over 8300 tables to concatenate. On top of that the table names or fairly long, here's an "average"...
--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)

April 13, 2011 at 8:17 am

#1311049
RE: Basic concat over 500 times slower than straight select?

Ninja's_RGR'us (4/12/2011)
I don't have a complete list of bad characters and I've got no idea about that type thing you're asking about.
All I know for sure at this point 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)

April 12, 2011 at 1:15 pm

#1310644
RE: UPSERT USING SSIS 2005

MyDoggieJessie (4/11/2011)
I have to ask this question:
In poorly designed tables that have 400+ columns (but luckily do have a unique guid as a PK), wouldn't it just be easier 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)

April 12, 2011 at 12:22 pm

#1310597
RE: Tuning image datatype

Sorry... I lost track of this one.
Is this still a problem? If so, I've run out of ideas based on the current information provided. I believe we need...
--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)

April 12, 2011 at 12:20 pm

#1310593
RE: Weird error when selecting from view.

UMG Developer (4/11/2011)
2nd note to self... find the person who made the change without discussing it and invite him/her out for a high velocity pork chop dinner.
I've seen mention 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)

April 12, 2011 at 12:16 pm

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

Nadrek (4/11/2011)
No, I'm not trolling; I'm advertising your article! The full context was:
-- Quirky update!!! BEWARE!!! Do not use this for critical things!
-- BEFORE USING, read http://www.sqlservercentral.com/articles/T-SQL/68467/
"Do 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)

April 12, 2011 at 12:01 pm

#1310576
RE: Passing multiple parameters using REPLACE function in the query is throwing error.

I causually looked at your code and it appears to be correct. What is the error that is being thrown?
--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)

April 12, 2011 at 11:50 am

#1310566

Viewing 15 posts - 34,276 through 34,290 (of 59,099 total)